FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 15: Database Administration and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

The ____ is responsible for ensuring database security and integrity.

A) database programmer
B) systems analyst
C) data administrator
D) database security officer

E) All of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

____ management is designed to limit access to the database.

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

Describe the DBA's managerial role.

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

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

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

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

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

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

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

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

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

User-access management is a subset of ____.

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

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

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

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

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