FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 16: Database Administration and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) license
B) role
C) profile
D) quota

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

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

In the context of the advancements in DBMS technology,the use of data services can free the DBA from many lower-level technology-oriented tasks.

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

The use of cloud-based data services alters and expands the typical DBA's role in both technical and managerial dimensions.What is the DBA's role in this environment?

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.

Based on the type of decision-making support required,database users may be classified into: operational,tactical,or _____.

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

The ,also known as the information resource manager (IRM),usually reports directly to top management and is given a higher degree of responsibility and authority than the DBA,although the two roles can overlap.

An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations.

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.

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

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

Describe the DBA's managerial role.

A(n) plan is a set of instructions generated at application compilation time that predetermines how the application will connect to and communicate with the database at run time.

In the context of ensuring integrity of a database,a(n)transaction is one that does not overload the DBMS.

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

CASE tools provide support for the coding and implementation phases.

Security breaches can yield a database whose integrity is either preserved or corrupted.

In the context of the Oracle Enterprise Manager,a is a named collection of settings that control how much of the database resource a given user can use.

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

Concurrent backups take place while the user is working on the database.