Answer: Extraction phase
Explanation: Transactional database is the data collection capable of undoing the transaction that has not been correctly done. Data warehouse id the place where transaction data is transmitted where different types of databases are stored.
The transmission of the information from transactional database to data warehouse is defined in the extraction phase.The extraction phase works by transforming the data into a particular format. It copes the transactional databases's data to the warehouse by making separate space for deposition of data
Answer:
an anti-virus program such as avg
Answer:
ROM
Explanation:
Data in ROM does not erase itself when the computer is shut down. The data is permentely written and stored.
Answer:
CREATE VIEW NHTrips AS
SELECT TripID,
TripName,
StartLocation,
Distance,
MaxGrpSize,
Type,
Season
FROM trip
WHERE State = 'NH';
Explanation:
A view is a user’s view or application program’s view of the database created for execution during a database operation such as those for displaying results, modification of record, updating and deletion of records. It is created by defining a SELECT query and then using a CREATE VIEW command.
syntax for creating view;
The view is created as follows,
Give a view name using the CREATE VIEW command and give optional field names followed by the query using the SELECT statement
I.e
CREATE VIEW viewname
[(column name1, column name2….)] AS Select statement
When the above query is executed, a view named NHTrips will created in the database.