Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

dictionary

Question 3

Describe a parallel database system.

Accepted Answer

A system may allow multiple computers to share access to data, software, or peripheral devices by running multiple instances of a single, shared database. A parallel database system takes advantage of this architecture to improve performance through parallelization of operations, such as storing data, indexing, and querying. In addition to balancing the workload among CPUs, the parallel database provides for concurrent access to data while protecting data integrity.

Question 4

Programmers monitor database usage to detect potential security violations.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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?

Accepted Answer

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

Question 7

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

Accepted Answer

The answer of A(n) ____________________ site is a backup site...

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

The answer of The database ____________________ manager is concerned with...

Question 10

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

Accepted Answer

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

Question 11

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.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

The answer of The ____________________ recovery plan specifies the ongoing...

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

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.

Accepted Answer

A) True 
 B)False

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

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

Describe a parallel database system.

Programmers monitor database usage to detect potential security violations.

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

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(n) ____________________ site is a backup site that is equipped with duplicate hardware and software but not data.

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

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

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

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.

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

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

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

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

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

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

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

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

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.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Management Approaches

Filters

Exam 8: Database Administration

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

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

Describe a parallel database system.

Programmers monitor database usage to detect potential security violations.

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

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(n) ____________________ site is a backup site that is equipped with duplicate hardware and software but not data.

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

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

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

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.

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

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

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

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

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

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

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

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

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.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Management Approaches

Filters