Deck 8: Database Administration

Question 1

The command 'REVOKE REFERENCES ON Customer to bsmith' prevents the bsmith user from using the ALTER TABLE statement to change a table definition.

Answer 1

False

Question 2

The ability of a DBMS to allow multiple computers to share access to data and software by running multiple instances of a single, shared database is called a serial database system.

Answer 2

False

Question 3

QBE is an example of a procedural language.

Answer 3

False

Question 4

All database users need full access to all tables and fields in the database.

Question 5

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

Question 6

Which DBA role organizes metadata, and acts as a liaison between the database administrator and the rest of the database staff?

A) data architect
B) database programmer
C) data administrator
D) data operations manager

Question 7

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

Question 8

When selecting a DBMS and evaluating the data definitions category, you should ask if the DBMS supports views.

Question 9

Which DBA role manages or supervises the construction of large and comprehensive databases?

A) data architect
B) database programmer
C) data administrator
D) data operations manager

Question 10

When selecting a DBMS and evaluating the concurrent update category, you should determine whether the DBMS resolves deadlock.

Question 11

When selecting a DBMS, the only database model choice available to the DBA is the relational model.

Question 12

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

Question 13

The DBA determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog.

Question 14

Programmers monitor database usage to detect potential security violations.

Question 15

Which DBA role makes sure the data gets from one place to another with integrity and security?

A) data architect
B) database programmer
C) data administrator
D) data operations manager

Question 16

To manage problems that arise from using a DBMS, companies appoint a DBA to manage both the database and the use of the DBMS.

Question 17

If a user is granted the use of the SELECT statement on a table, the user is also authorized to use UPDATE statements even if the user was not specifically granted that permission.

Question 18

The data architect designs, builds, and deploys databases.

Question 19

What type of locks forbid any other user from accessing the data in any way?

A) Shared
B) Exclusive
C) Limited
D) Concurrent

Question 20

The data architect sets data-handling policies and assigns data entry.

Question 21

What is it called when a 2-step identity verification procedure is used to grant users access to the system?

A) smart card authorization
B) multilayer security
C) security in depth
D) two-factor authentication

Question 22

If performance testing shows that queries based on frequently accessed fields are taking a long time to complete, what can the DBA do that might improve performance?

A) increase the number of columns
B) delete foreign keys
C) add indexes
D) add alternate keys

Question 23

The ____________________ recovery plan specifies the ongoing and emergency actions and procedures required to ensure data availability if a disaster occurs.

Question 24

DBAs should have an understanding of information legislation such as the Data ____________________ Act.

Question 25

The database ____________________ manager is concerned with the ongoing maintenance of established databases.

Question 26

Which of the following DBMS evaluation categories does the following question relate to: How many files can you open at the same time?

A) Concurrent update
B) Security
C) Integrity
D) Limitations

Question 27

After the database designers complete the information-level design, what design level does the DBA do next?

A) physical
B) information
C) logical
D) graphical

Question 28

When evaluating and selecting a DBMS, in which category is the DBA most concerned with benchmarks?

A) Cost
B) Security
C) Integrity
D) Performance

Question 29

What is it called when a database is divided into segments and the segments are stored on different computers?

A) converged database
B) centralized database
C) distributed database
D) virtual database

Question 30

What type of environment do database programmers use to develop new programs and modify existing programs?

A) live
B) sandbox
C) production
D) virtual

Question 31

Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS allow partial copies and how does the DBMS handle updates to the same data from two or more replicas?

A) Backup and recovery
B) Security
C) Integrity
D) Replication and distributed databases

Question 32

If users access only certain fields in a table, how can you improve performance?

A) by splitting the table into two or more tables and removing the primary key
B) by combining the table with another table that performs better
C) by splitting the table into two or more tables that each has the same primary key as the original
D) by adding indexes to each column and deleting the primary and alternate keys

Question 33

Which process converts a table that is in third normal form to a table no longer in third normal form?

A) conversion
B) denormalizing
C) normalization
D) replication

Question 34

A(n) ____________________ site is a backup site that an organization can switch to in minutes or hours because the site is completely equipped with duplicate hardware, software, and data.

Question 35

Which of the following DBMS evaluation categories does the following question relate to: What types of files can you import or export?

A) Cost
B) Future plans
C) Portability
D) Performance

Question 36

What can organizations use in their computer systems that allow the system to continue to process database transactions after a hard drive failure?

A) UPS
B) backup
C) RAID
D) surge suppressor

Question 37

Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS support encryption, password support, and authorization rules?

A) Concurrent update
B) Security
C) Integrity
D) Limitations

Question 38

A(n) ____________________ site is a backup site that is equipped with duplicate hardware and software but not data.

Question 39

Which group performs additional testing of the database program after the programmers complete their testing?

A) customers
B) accounting
C) users
D) quality assurance

Question 40

Which of the following is a log of all database maintenance, with dates, license keys, issues or updates, involved personnel, and resolutions?

A) system journal
B) run-book
C) system catalog
D) DBMS log

Question 41

When the primary key cannot be null, this is known as ____________________.

Question 42

What is the DBA's role with regard to access privileges?

Question 43

The data ____________________ is the catalog, but it often contains a wider range of information, including information about tables, fields, indexes, programs, and users.

Question 44

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

Question 45

Database ____________________ deals with the ability of the production system to serve users in a timely and responsive manner.

Question 46

Discuss the steps that organizations take to protect their data against hard drive failures and electrical power interruptions or outages.

Question 47

In a LAN, support for ____________________ update is very important because many users might be updating the database at the same time.

Question 48

What can the DBA do if the organization has no additional money for its production system but needs further performance improvements?

Question 49

With just two exceptions, the DBA grants access and update privileges to the production system only to authorized users. What are the exceptions?

Question 50

Describe a parallel database system.