Data and Database Administration
A data warehouse administrator is concerned with which of the following?

The time to make a decision and the typical roles of a database administrator
The typical roles of a database administrator and redesigning existing applications
The time to make a decision but not the typical roles of a database administrator
The typical roles of a data administrator and redesigning existing applications

ANSWER DOWNLOAD EXAMIANS APP

Data and Database Administration
Which of the following is true concerning open-source DBMS?

Is not competitive against PC-oriented packages and is fully SQL compliant
Is competitive against PC-oriented packages and is not fully SQL compliant
Is free or nearly free database software whose source code is not publicly available
Is free or nearly free database software whose source code is publicly available

ANSWER DOWNLOAD EXAMIANS APP

Data and Database Administration
Backward recovery is which of the following?

Where the after-images are applied to the database
Where the after-images and before-images are applied to the database
Switching to an existing copy of the database
Where the before-images are applied to the database

ANSWER DOWNLOAD EXAMIANS APP

Data and Database Administration
Which of the following is part of an administrative policy to secure a database?

Limiting particular areas within a building to only authorized people
Authentication policies
All of these
Ensure appropriate responses rates are in external maintenance agreements

ANSWER DOWNLOAD EXAMIANS APP