Question 1

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

Accepted Answer

A)   ​Cost
B)   ​Future plans
C)   ​Portability
D)   ​Performance C

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

The DBA creates security policies and procedures.​

Accepted Answer

A) True 
 B)False  False

Question 4

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?​

Accepted Answer

A)   ​Backup and recovery
B)   ​Data dictionary
C)   ​Security
D)   ​Integrity

Question 5

Programmers monitor database usage to detect potential security violations.​

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)   ​IT manager
B)   ​DBA
C)   ​CEO
D)   ​user

Question 8

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

Accepted Answer

The answer of Copies of archival files and database backups...

Question 9

____________________ 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.​

Accepted Answer

The answer of ____________________ help means that if a user...

Question 10

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.​

Accepted Answer

A)   CEO​
B)   ​programmer
C)   ​DBA
D)   ​IT manager

Question 11

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?​

Accepted Answer

A)   ​Backup and recovery
B)   ​Security
C)   ​Integrity
D)   ​Replication and distributed databases

Question 12

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

Accepted Answer

A)   ​Conversion
B)   ​Denormalization
C)   ​Normalization
D)   ​Replication

Question 13

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

Accepted Answer

A)   ​Concurrent update
B)   ​Security
C)   ​Limitations
D)   ​Limitations

Question 14

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

Accepted Answer

A)   ​Concurrent update
B)   ​Security
C)   ​Integrity
D)   ​Limitations

Question 15

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

Accepted Answer

The answer of The ____________________ recovery plan specifies the ongoing...

Question 16

What is a hot site?​

Accepted Answer

The answer of What is a hot site?​...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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?​

Accepted Answer

A)   ​Concurrent update
B)   ​Data recovery
C)   ​Data dictionary
D)   ​Security

Question 19

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

Accepted Answer

A)   ​Parallel
B)   ​Relational
C)   ​Conditional
D)   ​Referential

Question 20

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

Accepted Answer

A) True 
 B)False

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.​

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?

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.