Question 1

In the context of an organization's managerial structure, _____ decisions are short term and affect only daily operations; for example, deciding to change the price of a product to clear it from inventory.

Accepted Answer

The answer of In the context of an organization's managerial...

Question 2

A(n) _____ data dictionary is automatically updated by the DBMS with every database access.

Accepted Answer

The answer of A(n) _____ data dictionary is automatically updated...

Question 3

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.

Accepted Answer

The answer of In the context of the advancements in...

Question 4

In the context of data quality management tools, _____ software is one that gathers statistics, analyzes existing data sources and metadata to determine patterns, and compares the patterns against standards that the organization has defined.

Accepted Answer

The answer of In the context of data quality management...

Question 5

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

Accepted Answer

Information engineering (IE) focuses on understanding and structuring business needs and translating them into data models, processes, and systems that help achieve strategic goals.

Question 6

The _____ aspect of introducing a DBMS in an organization deals with hardware and software changes in the organization.

Accepted Answer

The answer of The _____ aspect of introducing a DBMS...

Question 7

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

Accepted Answer

A passive data dictionary requires manual updating or a batch process to reflect changes in the database schema, unlike an active data dictionary, which updates automatically.

Question 8

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

Accepted Answer

The answer of In the context of ensuring integrity of...

Question 9

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.

Accepted Answer

An information systems architecture provides a framework for developing a data administration strategy that includes computerized, automated, and integrated tools such as a DBMS and CASE tools. An access plan is a document that outlines the steps necessary to obtain access to a specific resource or system. An active data dictionary is a database component that stores metadata about data and database objects. A security policy outlines guidelines and procedures for ensuring the security of an organization's data and systems. While these can be components of a data administration strategy, they do not provide the comprehensive framework provided by an information systems architecture.

Question 10

In the context of database administration, _____ is the extent to which individuals and organizations have the right to determine the "who, what, when, where, and how" of data usage.

Accepted Answer

The answer of In the context of database administration, _____...

Question 11

_____ CASE tools provide support for the coding and implementation phases.

Accepted Answer

Back-end CASE tools are designed to assist in the coding and implementation phases of software development, focusing on tasks such as code generation, testing, and maintenance.

Question 12

The DSO's activities are often classified as _____ management, which includes all DBA activities designed to ensure data availability following a physical calamity or a database integrity failure.

Accepted Answer

The answer of The DSO's activities are often classified as...

Question 13

A(n) _____ is a logical storage area in Oracle.

Accepted Answer

A tablespace is a logical storage area in Oracle where data is stored in datafiles. A schema is a collection of database objects (tables, views, etc.) that belong to a user, while an audit log is a record of all the database activities performed by users.

Question 14

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

Accepted Answer

The answer of Based on the type of decision-making support...

Question 15

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.

Accepted Answer

The answer of The _____, also known as the information...

Question 16

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.

Accepted Answer

An audit log is a file that automatically records a brief description of the database operations performed by all users. It is a commonly used method for monitoring database usage and ensuring compliance with regulations and policies. The other options, change tracker, digital footprint, and paper trail, do not specifically refer to the recording of database operations performed by users.

Question 17

The _____ component of a CASE tool produces the information system's input/output formats.

Accepted Answer

The screen painter and report generator component of a CASE tool is responsible for producing the input/output formats of an information system such as screens and reports. The analysis component involves analyzing the requirements of the system, the graphics component involves designing the user interface, and the program document generator component involves generating documentation for the software code.

Question 18

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

Accepted Answer

Front-end CASE tools are designed to help with the early stages of software development, including planning, analysis, and design phases. They assist in creating high-level abstract solutions before the actual coding starts.

Question 19

In case a company installs several incompatible databases and assigns a DBA for each of them, the general coordinator of all such DBAs is known as the _____ administrator.

Accepted Answer

The answer of In case a company installs several incompatible...

Question 20

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

Accepted Answer

Initialization parameters are used to reserve the resources needed by the database to run. They define how much memory, disk space, and CPU resources will be allocated to the database processes. By setting these parameters, the database administrator can ensure that the database has the necessary resources to operate efficiently and avoid running out of memory or disk space. The security component, authorization manager, and administrator are all important functions provided by the database, but they are not directly responsible for resource reservation.

Quiz 16: Database Administration and Security