Question 1

The person responsible for the control of the centralized and shared database is the database ____.
A) analyst
B) administrator
C) programmer
D) user

Accepted Answer

The database administrator (DBA) is responsible for the control of the centralized and shared database. They manage and maintain the database, ensuring that it is secure, scalable, and performs efficiently. The database analyst, programmer, and user may have roles in utilizing the database, but they do not have the same level of control and responsibility as the DBA.

Question 2

A DBMS facilitates ____.
A) interpretation and presentation of data in useful formats
B) destruction of data and information to the right people at the right time
C) data presentation and data usage monitoring for adequate periods of time
D) automatic auditing of all data changes

Accepted Answer

A DBMS (database management system) is designed to facilitate the organization, storage, retrieval, modification, and interpretation of data. One of the key benefits of a DBMS is its ability to present data in useful formats, such as reports or charts, to make it easier for users to understand and analyze. While a DBMS can also provide security and auditing features to track data changes, it is not specifically designed for destruction or data usage monitoring.

Question 3

System support activities cover all tasks directly related to the day-to-day operations of a DBMS and its applications.

Accepted Answer

System support activities include tasks such as backup and recovery, performance monitoring, security management, user support, and system maintenance. These tasks are essential for ensuring the smooth functioning of a DBMS and its applications on a daily basis.

Question 4

As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.
A) control and planning
B) conflict and problem-resolution
C) policies and standards
D) security and privacy

Accepted Answer

While all of the dimensions listed are important for a DBA to consider, control and planning are likely the most essential. A DBA's role is to ensure that the database is functioning properly and efficiently, and to plan for future growth and development. This requires careful monitoring and management of resources, as well as a strategic approach to problem-solving and decision-making. Policies, standards, security, and privacy are certainly important as well, but they are secondary to the larger goals of maintaining control and planning for the database's future.

Question 5

Database access can be controlled by placing limits on the use of the DBMS's query and reporting tools.

Accepted Answer

Access to the database can be restricted by limiting the use of query and reporting tools provided by the DBMS. This is normally done by assigning appropriate user privileges and permissions.

Question 6

At the level of middle management, the database must be able to ____.
A) represent and support the company operations as closely as possible
B) deliver the data necessary for tactical decisions and planning
C) produce query results within specified performance levels
D) provide access to external and internal data to identify growth opportunities and to chart the direction of such growth

Accepted Answer

Middle management is responsible for making tactical decisions and planning, so the database must provide the necessary data for this level of decision making. Option A may be more applicable for senior management, while option D may be more important for strategic planning rather than tactical decisions. Option C is important for all levels of the organization but specifically mentioned for middle management.

Question 7

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

Accepted Answer

The allocation of storage resources is determined when the database is created, not the DBMS. The database administrator will determine how much storage space should be allocated to each table and other database objects.

Question 8

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.
A) cultural
B) managerial
C) technical
D) operational

Accepted Answer

Introducing a database into an organization is likely to have a cultural impact because it affects the way people work and interact with each other. It requires a more structured and controlled approach to information flow, and this can be a significant change for individuals and teams who are used to working in a more informal manner. The introduction of a database may require training or a shift in mindset to ensure that all members of the organization are able to adapt to the new system.

Question 9

Protecting the data in the database is a function of authorization management.

Accepted Answer

Authorization management involves controlling access to database objects and determining who has the right to perform which actions on those objects. This includes protecting the data in the database from unauthorized access or modification.

Question 10

It is common practice to define the DBA function by dividing the DBA operations according to the ____ phases.
A) SLA
B) DBLC
C) SDLC
D) MRA

Accepted Answer

The answer of It is common practice to define the...

Question 11

Security breaches can yield a database whose integrity is either preserved or corrupted.

Accepted Answer

Security breaches can result in both scenarios, where a database's data can remain intact or compromised.

Question 12

Training people to use the DBMS and its tools is not included in the DBA's technical activities.

Accepted Answer

Training people to use the DBMS and its tools is often considered a responsibility of the DBA, as they are the experts on the system and can provide guidance on best practices for interacting with the database.

Question 13

The DBA's ____ role is focused on personnel management and on interactions with the end-user community.
A) administrative
B) arbitration
C) technical
D) managerial

Accepted Answer

The DBA's managerial role is focused on personnel management and interactions with the end-user community. The administrative role may involve tasks such as backup and recovery, security management, and performance tuning. The arbitration role involves resolving conflicts or negotiating agreements between different parties. The technical role involves tasks related to designing, implementing, and maintaining the databases and related technologies.

Question 14

The DBA's ____ role covers activities involving the use of the DBMS.
A) administrative
B) arbitration
C) technical
D) managerial

Accepted Answer

The answer of The DBA's ____ role covers activities involving...

Question 15

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

Accepted Answer

An audit log is a tool used by the DBA to record the activities of the users on the database. It automatically records a brief description of the operations performed by the users. This helps the DBA to monitor the activities of the users and detect any unauthorized access or suspicious activities on the database.

Question 16

There is a growing trend toward ____ in the data-management function.
A) cross-training
B) encapsulation
C) specialization
D) centralization

Accepted Answer

The answer of There is a growing trend toward ____...

Question 17

The DBA must define data views to protect and control the scope of the data that are accessible to an authorized user.

Accepted Answer

It is the responsibility of the DBA to define and implement data views to control the access and visibility of data for authorized users. This helps protect sensitive data and maintain data security.

Question 18

The maintenance activities of the DBA are an extension of the operational activities.

Accepted Answer

The DBA's maintenance activities, such as backups, tuning, and security management, are part of the operational activities required to ensure the smooth running and availability of the database system.

Question 19

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

Accepted Answer

Testing procedures and standards are necessary to ensure the quality and reliability of the application program. Without proper testing, there is a risk of bugs and errors that could cause problems for the company. Therefore, it is important to have testing procedures and standards in place before approving any application program for use.

Question 20

The ____ administrator is responsible for strategic planning.
A) system
B) data
C) database
D) program

Accepted Answer

The answer of The ____ administrator is responsible for strategic...

Quiz 12: Database Administration and Security

The person responsible for the control of the centralized and shared database is the database ____.

A DBMS facilitates ____.

System support activities cover all tasks directly related to the day-to-day operations of a DBMS and its applications.

As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.

Database access can be controlled by placing limits on the use of the DBMS's query and reporting tools.

At the level of middle management, the database must be able to ____.

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

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.

Protecting the data in the database is a function of authorization management.

It is common practice to define the DBA function by dividing the DBA operations according to the ____ phases.

Security breaches can yield a database whose integrity is either preserved or corrupted.

Training people to use the DBMS and its tools is not included in the DBA's technical activities.

The DBA's ____ role is focused on personnel management and on interactions with the end-user community.

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

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

There is a growing trend toward ____ in the data-management function.

The DBA must define data views to protect and control the scope of the data that are accessible to an authorized user.

The maintenance activities of the DBA are an extension of the operational activities.

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

The ____ administrator is responsible for strategic planning.