Question 1

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

Accepted Answer

Middle management requires databases to deliver data necessary for tactical decisions and planning, as they are responsible for implementing strategies and ensuring operational efficiency.

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

Security breaches can either leave a database's integrity intact or can corrupt it by altering, deleting, or inserting data. A breach can compromise the confidentiality, availability, and/or integrity of a database.

Question 4

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

Accepted Answer

By placing limits on the use of DBMS's query and reporting tools, access to the database can be restricted and controlled. This can include limiting the type of queries that can be run, restricting access to certain tables or fields, and controlling who can run reports and how they can be distributed.

Question 5

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.

Accepted Answer

Introducing a database into an organization can have a cultural impact because it affects the way information is collected, stored, and accessed, and may change the way people work and interact with each other. This may require a change in the organization's culture and values to adapt to the new system.  Managerial, technical, and operational impacts are also possible, but cultural impact is the most likely.

Question 6

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

Accepted Answer

Authorization management controls who has access to certain data in the database, ensuring that only authorized users can view, modify, or delete data. This is a crucial aspect of data security and helps protect against unauthorized access, theft, and misuse of sensitive information.

Question 7

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

Accepted Answer

The operational activities involve managing the day-to-day running of the database, while maintenance activities involve managing the physical and logical health of the database. They are both interrelated and essential roles of a DBA.

Question 8

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

Accepted Answer

The database administrator (DBA) is responsible for the control of the centralized and shared database. They manage and monitor the database to ensure its performance, security, and integrity. The database analyst may assist with the design and implementation of the database, while the programmer and user may interact with the database but do not have overall control.

Question 9

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

Accepted Answer

Defining data views is an important aspect of database security and access control, as it allows the DBA to limit the scope of data that can be accessed by different users based on their roles and permissions. This helps ensure that sensitive data is not compromised or accessed by unauthorized users.

Question 10

A DBMS facilitates ____.

Accepted Answer

A DBMS (Database Management System) manages and organizes large quantities of data and facilitates the interpretation and presentation of data in useful formats for users. It does not involve destruction of data or automatic auditing of all data changes. It may monitor data usage for adequate periods of time, but this is not its primary purpose.

Question 11

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

Accepted Answer

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

Question 12

The ____ administrator is responsible for strategic planning.

Accepted Answer

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

Question 13

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 included in the DBA's responsibilities as they are responsible for ensuring the efficient and effective use of the database system.

Question 14

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

Accepted Answer

The allocation of storage resources is not determined when the DBMS is created. It can be modified as needed during the life of the database.

Question 15

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 important to ensure the reliability and quality of an application program before it can be used by the company. Without these procedures and standards, there is a risk of introducing bugs and errors that could cause harm or financial loss to the company. Therefore, it is necessary to establish these procedures and standards as part of the development and deployment process.

Question 16

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 are tasks that are directly related to the day-to-day operations of a DBMS and its applications. These activities include but are not limited to data backup and recovery, system performance monitoring, security management, and user support.

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

The DBA's managerial role is focused on personnel management and interactions with the end-user community. This includes tasks such as managing the database team, ensuring that user needs are met, and communicating with stakeholders about database-related issues. The other options are not as relevant to this specific focus of the DBA's role.

Question 19

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

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 20

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 can be used by the DBA to record the database operations performed by the users.

Quiz 15: Database Administration and Security