Question 1

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 2

The DBA must review the database application design to ensure that transactions are , meaning that they mirror real-world events.

Accepted Answer

The answer of The DBA must review the database application...

Question 3

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

Accepted Answer

The answer of The requirement that a password must have...

Question 4

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 5

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 6

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, is...

Question 7

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

Accepted Answer

In Oracle Enterprise Manager, a role 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 refers to the legal authorization to use a software product. A profile is a group of attributes that applies to a user, limiting the account's amount of database resources or fine-tuning a user's session. A quota is a limit on the amount of disk space or other resources that a user is allowed to consume.

Question 8

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 9

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

Accepted Answer

The answer of A security is a weakness in a...

Question 10

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 11

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 12

Within the data security framework, is concerned with keeping data consistent and free of errors or anomalies.

Accepted Answer

The answer of Within the data security framework, is concerned...

Question 13

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 14

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

Accepted Answer

Initialization parameters define the configuration settings for a database, including resource management. They determine the amount of resources allocated to different database features and operations, such as buffer cache size, shared pool size, and maximum number of concurrent connections. By configuring these parameters appropriately, administrators can ensure that the database has enough resources to perform optimally under expected workloads.

Question 15

A(n) is a logical storage area in Oracle.
A) audit log
B) datafile
C) schema
D) tablespace

Accepted Answer

A tablespace is a logical storage area in Oracle where data is stored. It consists of one or more datafiles, which are physical files on disk that contain the actual data. Each tablespace can contain one or more tables or indexes.

Question 16

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 in...

Question 17

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.
A) license
B) role
C) profile
D) constraint

Accepted Answer

In Oracle Enterprise Manager, a profile is a named collection of settings that control how much of the database resource a given user can use. Profiles are used to enforce resource limits on database users. Additionally, profiles control how the database handles sessions for users assigned to the profile, including password expiration and the maximum number of concurrent sessions allowed.

Question 18

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 19

In the context of the Oracle Enterprise Manager, a(n) is a uniquely identifiable object that allows a given person to log on to the database.
A) user
B) role
C) profile
D) client

Accepted Answer

A user is a uniquely identifiable object that allows a given person to log on to the database. A role defines a set of privileges that can be assigned to users or other roles. A profile controls resources available to a user or role, such as CPU and memory usage limits. A client is a software program or device that accesses the database.

Question 20

Performance monitoring and activities are designed to ensure that the DBMS, utilities, and applications maintain satisfactory performance levels.

Accepted Answer

The answer of Performance monitoring and activities are designed to...

Quiz 15: Database Administration and Security