Question 1

Describe the DBA's managerial role.

Accepted Answer

The answer of Describe the DBA's managerial role....

Question 2

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 3

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 4

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 5

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

Question 6

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 7

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

Accepted Answer

The answer of Explain user requirements gathering as part of...

Question 8

The testing and evaluation of a database application cover all aspects of the system-from the simple collection and creation of data to its use and retirement.What is covered by the evaluation process?

Accepted Answer

The answer of The testing and evaluation of a database...

Question 9

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

Question 10

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 11

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

Accepted Answer

The answer of A(n)_____ physically stores the database's data....

Question 12

Explain conflict and problem resolution as part of the DBA's end­user support services.

Accepted Answer

The answer of Explain conflict and problem resolution as part...

Question 13

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

Question 14

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

Question 15

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 16

Describe the need for convenient and safe backup storage.

Accepted Answer

The answer of Describe the need for convenient and safe...

Question 17

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 18

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 19

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 20

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

Quiz 16: Database Administration and Security

Describe the DBA's managerial role.

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

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.

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.

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.

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.

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

The testing and evaluation of a database application cover all aspects of the system-from the simple collection and creation of data to its use and retirement.What is covered by the evaluation process?

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

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

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

Explain conflict and problem resolution as part of the DBA's enduser support services.

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

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.

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

Describe the need for convenient and safe backup storage.

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.

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.

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

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

Quiz 16: Database Administration and Security

Describe the DBA's managerial role.

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

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.

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.

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.

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.

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

The testing and evaluation of a database application cover all aspects of the system-from the simple collection and creation of data to its use and retirement.What is covered by the evaluation process?

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

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

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

Explain conflict and problem resolution as part of the DBA's end­user support services.

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

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.

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

Describe the need for convenient and safe backup storage.

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.

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.

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

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

Explain conflict and problem resolution as part of the DBA's enduser support services.