Question 1

What is a recovery log?

Accepted Answer

A recovery log is a file recorded to the...

Question 2

The TCL commands are used by the business end users of a database system.

Accepted Answer

A) True 
 B)False

Question 3

What is update failure?

Accepted Answer

Update failure is th...

Question 4

The data manipulation DBMS component is used:

Accepted Answer

A)  By end users,directly only
B)  By end users,via front-end applications only
C)  By end users,either directly or via front-end applications
D)  By no end usersE) B) and D)
F) B) and C)

Question 5

What is data backup?

Accepted Answer

Data backup refers to the prac...

Question 6

What is a complete mirrored backup?

Accepted Answer

A complete mirrored backup is ...

Question 7

What is a data dictionary?

Accepted Answer

A data dictionary is a repository of the...

Question 8

Which of the following is NOT a data administration task?

Accepted Answer

A)  Monitoring and maintaining the database system
B)  Securing the database against unauthorized access
C)  Creating a conceptual database model
D)  Providing database backup and recoveryE) B) and D)
F) C) and D)

Question 9

What is a query hint?

Accepted Answer

A query hint is a suggestion f...

Question 10

The data manipulation component is a part of every DBMS package.

Accepted Answer

A) True 
 B)False

Question 11

What is a multiuser DBMS?

Accepted Answer

In a multiuser DBMS,the data m...

Question 12

In a role-based access control system,users can be assigned several database roles.

Accepted Answer

A) True 
 B)False

Question 13

If,during the use of the database system,it becomes apparent that a new relation needs to be added to the database,the decision to add the new relation to the database will rest with the:

Accepted Answer

A)  Database developer
B)  DBA
C)  End user
D)  DBMS software developerE) None of the above
F) All of the above

Question 14

What is view materialization?

Accepted Answer

View materialization refers to saving a ...

Question 15

What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database?
GRANT SELECT,INSERT,ALTER,UPDATE ON client TO shannon;
REVOKE INSERT ON client FROM shannon;

Accepted Answer

A)  Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT,insert data in CLIENT
B)  Shannon can read data from CLIENT,change data in CLIENT,insert data in CLIENT
C)  Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT
D)  Shannon can insert data in CLIENTE) A) and C)
F) A) and B)

Question 16

What is the query cost?

Accepted Answer

The query cost is th...

Question 17

What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database?
CREATE ROLE supervisor;
GRANT SELECT,INSERT,UPDATE ON client TO supervisor;
GRANT SUPERVISOR TO shannon;

Accepted Answer

A)  Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT,insert data in CLIENT
B)  Shannon can read data from CLIENT,change data in CLIENT,insert data in CLIENT
C)  Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT
D)  Shannon can change the metadata of CLIENTE) B) and D)
F) B) and C)

Question 18

The data manipulation DBMS component uses the SQL commands from the DCL category.

Accepted Answer

A) True 
 B)False

Question 19

What is database recovery?

Accepted Answer

Database recovery re...

Question 20

What is a query optimizer?

Accepted Answer

A query optimizer is a feature...

Exam 10: Overview of Dbms Functionalities and Database Administration

The data manipulation component is a part of every DBMS package.

Correct AnswerverifiedShow Answer

What is a multiuser DBMS?

Correct AnswerverifiedIn a multiuser DBMS,the data m...View AnswerShow Answer

What is data backup?

Correct AnswerverifiedData backup refers to the prac...View AnswerShow Answer

Which of the following is NOT a data administration task?

Correct AnswerverifiedShow Answer

What is a recovery log?

Correct AnswerverifiedA recovery log is a file recorded to the...View AnswerShow Answer

What is a data dictionary?

Correct AnswerverifiedA data dictionary is a repository of the...View AnswerShow Answer

What is view materialization?

Correct AnswerverifiedView materialization refers to saving a ...View AnswerShow Answer

If,during the use of the database system,it becomes apparent that a new relation needs to be added to the database,the decision to add the new relation to the database will rest with the:

Correct AnswerverifiedShow Answer

What is a complete mirrored backup?

Correct AnswerverifiedA complete mirrored backup is ...View AnswerShow Answer

What is update failure?

Correct AnswerverifiedUpdate failure is th...View AnswerShow Answer

What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database? GRANT SELECT,INSERT,ALTER,UPDATE ON client TO shannon; REVOKE INSERT ON client FROM shannon;

Correct AnswerverifiedShow Answer

What is the query cost?

Correct AnswerverifiedThe query cost is th...View AnswerShow Answer

What is database recovery?

Correct AnswerverifiedDatabase recovery re...View AnswerShow Answer

The data manipulation DBMS component is used:

Correct AnswerverifiedShow Answer

What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database? CREATE ROLE supervisor; GRANT SELECT,INSERT,UPDATE ON client TO supervisor; GRANT SUPERVISOR TO shannon;

Correct AnswerverifiedShow Answer

What is a query optimizer?

Correct AnswerverifiedA query optimizer is a feature...View AnswerShow Answer

In a role-based access control system,users can be assigned several database roles.

Correct AnswerverifiedShow Answer

The TCL commands are used by the business end users of a database system.

Correct AnswerverifiedShow Answer

What is a query hint?

Correct AnswerverifiedA query hint is a suggestion f...View AnswerShow Answer

The data manipulation DBMS component uses the SQL commands from the DCL category.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
In a multiuser DBMS,the data m...
View Answer

Correct Answer
verified
Data backup refers to the prac...
View Answer

Correct Answer
verified

Correct Answer
verified
A recovery log is a file recorded to the...
View Answer

Correct Answer
verified
A data dictionary is a repository of the...
View Answer

Correct Answer
verified
View materialization refers to saving a ...
View Answer

Correct Answer
verified

Correct Answer
verified
A complete mirrored backup is ...
View Answer

Correct Answer
verified
Update failure is th...
View Answer

Correct Answer
verified

Correct Answer
verified
The query cost is th...
View Answer

Correct Answer
verified
Database recovery re...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A query optimizer is a feature...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A query hint is a suggestion f...
View Answer

Correct Answer
verified