Database Administration and Security_Quiz 2

Backups must be clearly identified through detailed descriptions and date information, assuring that the correct backup is used to recover the database.

• True
• False

The DBA must supervise the installation of all software and hardware designated to support the data administration strategy.

• True
• False

The DBA function provides data modeling and design services to the end-user community, often through coordination with an application development group within the data-processing department.

• True
• False

At the level of middle management, the database must be able to         

• provide a framework for defining and enforcing organizational policies
• provide the data necessary for tactical decisions and planning
• provide feedback to monitor whether a company is achieving its goals
• provide access to external and internal data to identify growth opportunities

The   ___administrator is responsible for strategic planning.

• system
• data
• database
• program

Which of the following is a reason why a DBMS's daily operations must be clearly documented?

• Documentation of the daily operations help a company set its long-term goals.
• Documentation of the daily operations help manage the manual data resources of a company.
• Documentation of the daily operations help pinpoint causes and solutions of database problems.
• Documentation of the daily operations help free the DBA from many lower-level technology-oriented tasks.

In the context of database usage monitoring, a(n) _______ is a file that automatically records a brief description of the database operations performed by all users.

• change tracker
• digital footprint
• paper trail
• audit log

In the context of developing a data administration strategy, a(n)  ____provides a framework that includes computerized, automated, and integrated tools such as a DBMS and CASE tools.

• access plan
• active data dictionary
• information systems architecture
• security policy

A(n)  ______is a logical storage area in Oracle.

• audit log
• datafile
• schema
• tablespace

In the context of the Oracle Enterprise Manager, a(n)  ____is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.

• license
• role
• profile
• quota