Exam 8: Database Administration

A ____ is a place where a record of certain corporate data is kept.

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

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

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

To implement and enforce security,the DBA uses such features as journaling and metadata.

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

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: What is the unit that may be locked and are exclusive locks the only ones permitted?

What is a hot site? What is a warm site? What is the difference between the two?

The ____ is responsible for providing training in the use of the DBMS.

In order to develop new programs,the programmers need access to the information in the DBMS. They are given access to the ____.

Which of the following DBMS evaluation categories does the following question relate to: Does the vendor of the DBMS supply printed or online training manuals and how good are the manuals?

What is the DBA's role with regard to access privileges?

SQL is an example of a procedural language.

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

An internal company network that uses software tools typically used on the Internet and World Wide Web is called a virtual network.

QBE is an example of a nonprocedural language.

The ____________________ Act of 2002 is a federal law that specifies data retention and verification requirements for public companies,requires CEOs and CFOs to certify financial statements,and makes it a crime to tamper with financial records.

____ locks forbid any other user from accessing the data in any way.

The hardware,software,and database for the users is called the ____________________ system.