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 51

Multiple Choice

Review LaterAdd Note

Review Later

A ____ is a uniquely identifiable object that allows a given person to log on to the database.

A) user
B) role
C) profile
D) manager

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

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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

A) audit log
B) datafile
C) schema
D) tablespace

E) None of the above
F) All of the above

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

____________________ deals with the rights of individuals and the organization to determine the "who,what,when,where,and how" of data usage.

Testing procedures and standards must already be in place before any application program can be approved for use in the company.

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

The introduction of a DBMS represents a big change and challenge,and is likely to have a profound impact throughout the organization.

An access ____________________ describes the type of authorized access.

The DBA's ____ role covers activities involving the use of the DBMS.

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

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

When introducing a database into an organization,a(n) ____ impact is likely because the database approach creates a more controlled and structured information flow and thus affects people,functions,and interactions.

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

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

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

The DBMS must provide tools that give each level of management a different view of the data and support the required level of decision-making.

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

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 overlap some.

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

The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.

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.