Question 1

A shared lock permits other users to read the data in the database.​

Accepted Answer

A shared lock allows multiple users to read the data in the database, but only one user can hold a write lock and modify the data at a time.

Question 2

To protect an organization's data against physical damage,the DBA creates a disaster recovery plan.​

Accepted Answer

A disaster recovery plan is designed to protect an organization's data against physical damage by outlining procedures and protocols for responding to natural disasters, cyber attacks, and other threats that could compromise the integrity of the data. The plan typically includes backup and recovery strategies, alternate communication methods, and emergency response procedures. A DBA is responsible for creating and implementing a disaster recovery plan to ensure that the organization's data is protected and can be restored in the event of a disaster.

Question 3

​Management approval is not required before the security policies and procedures can be implemented.

Accepted Answer

Management approval is necessary before implementing security policies and procedures. This is because security policies and procedures affect the entire organization and its operations, and management should review and approve them to ensure they align with the organization's objectives and comply with applicable laws and regulations.

Question 4

A ____ is a place where a record of certain corporate data is kept.​
A) ​depository
B) ​data archive
C) ​storage
D) ​data bank

Accepted Answer

The answer of A ____ is a place where a...

Question 5

Damage to a database can occur through a physical incident such as an abnormally terminated program.​

Accepted Answer

A physical incident such as an abnormally terminated program can cause damage to a database.

Question 6

Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may be locked and are exclusive locks the only ones permitted?​
A) ​Concurrent update
B) ​Data recovery
C) ​Data dictionary
D) ​Security

Accepted Answer

The question is about locking, which is related to concurrent update category.

Question 7

Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content,such as information about programs and the various data items these programs access?​
A) ​Backup and recovery
B) ​Data dictionary
C) ​Security
D) ​Integrity

Accepted Answer

The question is referring to the functionality of a data dictionary, which is used to store metadata about a database, including information about programs and data items. The other options (backup and recovery, security, integrity) do not relate to this specific question.

Question 8

The DBA is responsible for DBMS maintenance,data dictionary management,and training.​

Accepted Answer

The DBA (Database Administrator) is responsible for the maintenance and administration of the DBMS (Database Management System), which includes tasks such as database backup and recovery, database security and user management, performance tuning, and data dictionary management. The DBA may also be responsible for providing training to end-users or other IT staff on how to use the database system effectively.

Question 9

The CEO of the company determines the database access privileges for all users.​

Accepted Answer

While the CEO may have ultimate administrative control over the database, it is typically the responsibility of a designated database administrator or IT team to manage user access privileges.

Question 10

QBE is an example of a procedural language.​

Accepted Answer

QBE (Query By Example) is a non-procedural language used for database querying, manipulation and management. It is a declarative language where users specify desired results rather than specifying how to do the task.

Question 11

The DBA creates security policies and procedures.​

Accepted Answer

The answer of The DBA creates security policies and procedures.​...

Question 12

When a company decides to purchase a new DBMS,the CEO leads the DBMS evaluation and selection effort.​

Accepted Answer

While the CEO may be involved in the decision-making process, the responsibility of leading the DBMS evaluation and selection effort typically falls on the IT department or a dedicated project team.

Question 13

To implement and enforce security,the DBA uses such features as encryption and views.​

Accepted Answer

Encryption and Views are both commonly used by DBAs to implement and enforce security measures in databases. Encryption helps protect sensitive information from unauthorized access, while views provide a way to control access to specific tables or data subsets. Other security features commonly used by DBAs include authentication, access controls, auditing, and backup and recovery processes.

Question 14

An internal company network that uses software tools typically used on the Internet and World Wide Web is called an extranet.​

Accepted Answer

An internal company network that uses Internet and World Wide Web technologies is called an intranet, not an extranet. An extranet extends access to external partners.

Question 15

Another term for production system is the test system.​

Accepted Answer

A production system and a test system are two different things. A production system is the system that is used to actually run a business or organization, while a test system is used to test new software or changes to an existing system before they are deployed to the production system.

Question 16

​____ locks forbid any other user from accessing the data in any way.
A) ​Shared
B) ​Exclusive
C) ​Limited
D) ​Concurrent

Accepted Answer

Exclusive locks restrict access to the data to only one user at a time, preventing others from reading or modifying it. Shared locks, on the other hand, allow multiple users to access the same data concurrently but restrict write access. Limited and Concurrent locks are not standard terms in the context of database locking.

Question 17

SQL is an example of a nonprocedural language.​

Accepted Answer

The answer of SQL is an example of a nonprocedural...

Question 18

In most cases,access to every table and field in a database is a necessity for every user.​

Accepted Answer

In most cases, not every user needs access to every table and field in a database. Access should be limited to only what is necessary for each user's job function and responsibilities. For example, a customer service representative may only need access to certain customer information, while a financial analyst may need access to different tables and fields related to financial data.

Question 19

Programmers monitor database usage to detect potential security violations.​

Accepted Answer

The answer of Programmers monitor database usage to detect potential...

Question 20

The ____ determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog to ensure that users access the database only in ways in which they are entitled to do so.​
A) CEO​
B) ​programmer
C) ​DBA
D) ​IT manager

Accepted Answer

The DBA (Database Administrator) is responsible for determining the access privileges for users and entering the appropriate authorization rules in the DBMS catalog to ensure that users access the database only in ways in which they are entitled to do so. The CEO, programmer, and IT manager may have input or involvement in the process, but the DBA is ultimately responsible.

Quiz 8: Database Administration

A shared lock permits other users to read the data in the database.​

To protect an organization's data against physical damage,the DBA creates a disaster recovery plan.​

​Management approval is not required before the security policies and procedures can be implemented.

A ____ is a place where a record of certain corporate data is kept.​

Damage to a database can occur through a physical incident such as an abnormally terminated program.​

Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may be locked and are exclusive locks the only ones permitted?​

Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content,such as information about programs and the various data items these programs access?​

The DBA is responsible for DBMS maintenance,data dictionary management,and training.​

The CEO of the company determines the database access privileges for all users.​

QBE is an example of a procedural language.​

The DBA creates security policies and procedures.​

When a company decides to purchase a new DBMS,the CEO leads the DBMS evaluation and selection effort.​

To implement and enforce security,the DBA uses such features as encryption and views.​

An internal company network that uses software tools typically used on the Internet and World Wide Web is called an extranet.​

Another term for production system is the test system.​

​____ locks forbid any other user from accessing the data in any way.

SQL is an example of a nonprocedural language.​

In most cases,access to every table and field in a database is a necessity for every user.​

Programmers monitor database usage to detect potential security violations.​

The ____ determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog to ensure that users access the database only in ways in which they are entitled to do so.​

A shared lock permits other users to read the data in the database.

To protect an organization's data against physical damage,the DBA creates a disaster recovery plan.

Management approval is not required before the security policies and procedures can be implemented.

A ____ is a place where a record of certain corporate data is kept.

Damage to a database can occur through a physical incident such as an abnormally terminated program.

Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may be locked and are exclusive locks the only ones permitted?

Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content,such as information about programs and the various data items these programs access?

The DBA is responsible for DBMS maintenance,data dictionary management,and training.

The CEO of the company determines the database access privileges for all users.

QBE is an example of a procedural language.

The DBA creates security policies and procedures.

When a company decides to purchase a new DBMS,the CEO leads the DBMS evaluation and selection effort.

To implement and enforce security,the DBA uses such features as encryption and views.

An internal company network that uses software tools typically used on the Internet and World Wide Web is called an extranet.

Another term for production system is the test system.

____ locks forbid any other user from accessing the data in any way.

SQL is an example of a nonprocedural language.

In most cases,access to every table and field in a database is a necessity for every user.

Programmers monitor database usage to detect potential security violations.

The ____ determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog to ensure that users access the database only in ways in which they are entitled to do so.