Question 1

By default,Access and other DBMSs create indexes automatically for the ____ keys.​

Accepted Answer

A)   ​primary and minor
B)   ​alternate and foreign
C)   ​secondary and alternate
D)   ​primary and foreignE) None of the above
F) A) and D)

Question 2

In order to develop new programs,the programmers need access to the information in the DBMS.They are given access to the ____.​

Accepted Answer

A)   ​production system
B)   ​test system
C)   ​live system
D)   ​documentation systemE) None of the above
F) A) and B)

Question 3

SQL is an example of a nonprocedural language.​

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The first exception is when problems occ...

Question 5

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

Accepted Answer

The answer of When the primary key cannot be null,this...

Question 6

The ____ is responsible for providing training in the use of the DBMS.​

Accepted Answer

A)   programmer​
B)   ​analyst
C)   ​DBA
D)   ​CEOE) All of the above
F) B) and C)

Question 7

The hardware,software,and database for the users is called the ____________________ system.​

Accepted Answer

production
live
live...

Question 8

The _________________________ strictly controls the production system.​

Accepted Answer

DBA
DBA (database ad...

Question 9

QBE is an example of a procedural language.​

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)   ​Shared
B)   ​Exclusive
C)   ​Limited
D)   ​ConcurrentE) B) and C)
F) None of the above

Question 11

Tables with indexes allow faster searches,but slow performance on ____.​

Accepted Answer

A)   ​insertions
B)   ​deletions
C)   ​updates
D)   ​selectsE) B) and C)
F) All of the above

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

​If a DBMS lacks essential security features,the _________________________ might create or purchase special security programs that provide the missing features.

Accepted Answer

DBA
DBA (database ad...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The DBA determines the access privileges...

Question 18

A configuration of several computers connected together that allow users to share a variety of hardware and software resources is known as a(n)_________________________.​

Accepted Answer

LAN
LAN (local area ...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 8: Database Administration

A configuration of several computers connected together that allow users to share a variety of hardware and software resources is known as a(n)_________________________.​

Correct AnswerverifiedLANLAN (local area ...View AnswerShow Answer

In order to develop new programs,the programmers need access to the information in the DBMS.They are given access to the ____.​

Correct AnswerverifiedShow Answer

​If a DBMS lacks essential security features,the _________________________ might create or purchase special security programs that provide the missing features.

Correct AnswerverifiedDBADBA (database ad...View AnswerShow Answer

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

Correct AnswerverifiedThe DBA determines the access privileges...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

The _________________________ strictly controls the production system.​

Correct AnswerverifiedDBADBA (database ad...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

By default,Access and other DBMSs create indexes automatically for the ____ keys.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The hardware,software,and database for the users is called the ____________________ system.​

Correct Answerverifiedproductionlivelive...View AnswerShow Answer

The ____ is responsible for providing training in the use of the DBMS.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe first exception is when problems occ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Tables with indexes allow faster searches,but slow performance on ____.​

Correct AnswerverifiedShow Answer

SQL is an example of a nonprocedural language.​

Correct AnswerverifiedShow Answer

QBE is an example of a procedural language.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A configuration of several computers connected together that allow users to share a variety of hardware and software resources is known as a(n)_________________________.

Correct Answer
verified
LAN
LAN (local area ...
View Answer

In order to develop new programs,the programmers need access to the information in the DBMS.They are given access to the ____.

Correct Answer
verified

If a DBMS lacks essential security features,the _________________________ might create or purchase special security programs that provide the missing features.

Correct Answer
verified
DBA
DBA (database ad...
View Answer

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

Correct Answer
verified
The DBA determines the access privileges...
View Answer

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

Correct Answer
verified

The _________________________ strictly controls the production system.

Correct Answer
verified
DBA
DBA (database ad...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

By default,Access and other DBMSs create indexes automatically for the ____ keys.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The hardware,software,and database for the users is called the ____________________ system.

Correct Answer
verified
production
live
live...
View Answer

The ____ is responsible for providing training in the use of the DBMS.

Correct Answer
verified

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

Correct Answer
verified
The first exception is when problems occ...
View Answer

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

Correct Answer
verified

Tables with indexes allow faster searches,but slow performance on ____.

Correct Answer
verified

SQL is an example of a nonprocedural language.

Correct Answer
verified

QBE is an example of a procedural language.

Correct Answer
verified

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

Correct Answer
verified