Querying database part 5 - DBMS Questions and Answers

1.

Which is the duplication of computer operations and routine backups to combat any unforeseen problems:

   A.) Concurrency
   B.) Deadlock
   C.) Recovery
   D.) Backup

Answer: Option 'C'

Recovery means to take the backup data while there is a crash.

2.

Database security helps organizations to protect data from _____

   A.) Internal users
   B.) External users
   C.) Non-external users
   D.) Non internal users

Answer: Option 'B'

External users are the people who do not involve in the processing of the database.

3.

Optimization that is basically related to the rewriter module is termed as__________

   A.) Semantic query optimization
   B.) Global query optimization
   C.) All of the Mentioned
   D.) None of the Mentioned

Answer: Option 'A'

SQL-99 is the most recent version of standard SQL prescribed by the ANSI.

4.

How many types of recovery control techniques:

   A.) 2
   B.) 3
   C.) 4
   D.) 5

Answer: Option 'A'

Recovery means to take the backup data while there is a crash.

5.

Optimization basically related to the Rewrite module is termed as _______

   A.) Semantic query optimization
   B.) Global query optimization
   C.) All of the Mentioned
   D.) None of the Mentioned

Answer: Option 'A'

SQL-99 is the most recent version of standard SQL prescribed by the ANSI.

Querying database part 5 - DBMS Questions and Answers Download Pdf