Exam 15: Database Administration and Security

In large organizations,the DSO's activities are often classified as ____________________ management.

A(n)____ data dictionary is not updated automatically and usually requires a batch process to be run.

The maintenance activities of the DBA are an extension of the operational activities.

By default,Oracle automatically creates ____________________ and SYS user IDs that have administrative privileges with every new database you create.

Explain conflict and problem resolution as part of the DBA's end-user support services.

User-access management is a subset of ____.

Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.

In the Oracle Enterprise Manager,a ____ is basically any object created by end users; for example,tables,views,indexes,stored procedures,and triggers.

Explain user requirements gathering as part of the DBA's end-user support services.

One CASE tool,____________________ Data Modeler by Computer Associates,produces fully documented ER diagrams that can be displayed at different abstraction levels.

The requirement that a password must have a maximum of 12 characters is an example of a(n)____________________.

Describe the DBA's managerial role.

The DBA is responsible for ensuring that the data are distributed to the right persons,at the right time,and in the right format.

____ management is designed to limit access to the database.

A security ____________________ is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.

In today's Internet environment,the DBA must also work with ____________________ administrators to implement efficient and secure Web-to-database connectivity.

A full backup,or database dump,produces a complete copy of the entire database.

The DBA works with managers to ensure the quality and integrity of database design and transactions.

The ____ is responsible for ensuring database security and integrity.

A(n)________________________________________ provides a framework that includes the use of computerized,automated,and integrated tools such as a DBMS and CASE tools.