Exam 8: Database Administration

Which of the following DBMS evaluation categories does the following question relate to: What types of files can you import or export?​

​Management approval is not required before the security policies and procedures can be implemented.

The DBA creates security policies and procedures.​

Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content,such as information about programs and the various data items these programs access?​

Programmers monitor database usage to detect potential security violations.​

When a company decides to purchase a new DBMS,the CEO leads the DBMS evaluation and selection effort.​

After the DBMS is purchased,the ____ has primary responsibility for installation and maintenance.​

Copies of archival files and database backups should be stored ____________________-site.​

____________________ help means that if a user is having trouble and asks for help,the DBMS will provide assistance for the particular feature being used at the time the user asks for help.​

The ____ determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog to ensure that users access the database only in ways in which they are entitled to do so.​

Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS allow partial copies and how does the DBMS handle updates to the same data from two or more replicas?​

____ converts a table that is in third normal form to a table no longer in third normal form.​

Which of the following DBMS evaluation categories does the following question relate to: On what operating system and hardware is the DBMS supported?​

​Which of the following DBMS evaluation categories does the following question relate to: How many files can you open at the same time?

The ____________________ recovery plan specifies the ongoing and emergency actions and procedures required to ensure data availability if a disaster occurs.

What is a hot site?​

The CEO of the company determines the database access privileges for all users.​

Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may be locked and are exclusive locks the only ones permitted?​

____ integrity is the constraint that says that the values in foreign keys must match values already in the database.​

To protect an organization's data against physical damage,the DBA creates a disaster recovery plan.​