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 1

Multiple Choice

Review LaterAdd Note

Review Later

____ are written instructions that describe a series of steps to be followed during the performance of a given activity.

A) Policies
B) Standards
C) Documentation
D) Procedures

E) B) and C)
F) A) and C)

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

One of the important functions provided by the database ____ is to reserve the resources that must be used by the database at run time.

A) security component
B) authorization manager
C) initialization parameters
D) administrator

E) A) and B)
F) B) and D)

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

____ CASE tools provide support for the planning,analysis,and design phases.

Physical protection of hardware and software must be accomplished by the use of open installations with restricted area access.

Current data distribution philosophy makes it easy for ____ end users to access the database.

____ allows for the translation of the company's strategic goals into the data and applications that will help the company achieve those goals.

A(n) ____ is a logical storage space in Oracle.

A DBMS facilitates ____.

The DBA must review the database application design to ensure that transactions are ____________________,meaning that they do not overload the DBMS.

The DBA's function includes educating the ____________________ in the services provided and how those services enhance data stewardship and data security.

The allocation of storage resources is determined when the DBMS is created.

The DBA must supervise the installation of all software and hardware designated to support the data administration strategy,must have a thorough understanding of the components being installed,and must be familiar with the installation,configuration,and startup procedures of such components.

Training people to use the DBMS and its tools is not included in the DBA's technical activities.

The DBA interacts with the end user by providing data and information support services to the organization's departments.

The person responsible for the control of the centralized and shared database is the database ____.

The end user's role requires a broad understanding of DBMS functions,configuration,programming languages,data modeling and design methodologies,and so on.

The DBA's ____ role is focused on personnel management and on interactions with the end-user community.

Placing the DBA function in a(n)____________________ position often creates a consulting environment in which the DBA is able to devise the data administration strategy but does not have the authority to enforce it or to resolve possible conflicts.

A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.

A(n)____________________ physically stores the database's data.