Exam 8: Database Administration

What can the DBA do if the organization has no additional money for its production system but needs further performance improvements?

The data architect designs, builds, and deploys databases.

Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS support encryption, password support, and authorization rules?

When selecting a DBMS and evaluating the data definitions category, you should ask if the DBMS supports views.

Which process converts a table that is in third normal form to a table no longer in third normal form?

An ____________________ is an internal company network that uses software tools typically used on the Internet and the World Wide Web.

What is it called when a 2-step identity verification procedure is used to grant users access to the system?

A(n) ____________________ site is a backup site that an organization can switch to in minutes or hours because the site is completely equipped with duplicate hardware, software, and data.

Which DBA role organizes metadata, and acts as a liaison between the database administrator and the rest of the database staff?

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 the DBA's role with regard to access privileges?

DBAs should have an understanding of information legislation such as the Data ____________________ Act.

What is it called when a database is divided into segments and the segments are stored on different computers?

All database users need full access to all tables and fields in the database.

What type of environment do database programmers use to develop new programs and modify existing programs?

When the primary key cannot be null, this is known as ____________________.

The DBA determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog.

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?

If performance testing shows that queries based on frequently accessed fields are taking a long time to complete, what can the DBA do that might improve performance?

Which of the following is a log of all database maintenance, with dates, license keys, issues or updates, involved personnel, and resolutions?