Database Interview Questions and Answers for Experienced people on ” Querying database part – 5″.
1. Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:
a) Concurrency
b) Deadlock
c) Backup
d) Recovery
Answer: b
Clarification: Deadlock will stop further processing.
2. Which is a duplicate copy of a file program that is stored on a different storage media than the original location:
a) Concurrency
b) Deadlock
c) Backup
d) Recovery
Answer: c
Clarification: Backup is required to take all the data.
3. Which is the duplication of computer operations and routine backups to combat any unforeseen problems:
a) Concurrency
b) Deadlock
c) Backup
d) Recovery
Answer: d
Clarification: Recovery means to take the backup data while there is a crash.
4. 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: a
Clarification: SQL-99 is the most recent version of standard SQL prescribed by the ANSI.
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: a
Clarification: SQL-99 is the most recent version of standard SQL prescribed by the ANSI.
6. Database security helps organizations to protect data from _____
a) Internal users
b) External users
c) Non-external users
d) Non internal users
Answer: b
Clarification: External users are the people who do not involve in the processing of the database.
7. Copying files to secondary or specific devices is known as ______
a) Retrieve
b) Backup
c) Recovery
d) Deadlock
Answer: b
Clarification: Backup is required to take all the data.
8. How many types of recovery control techniques:
a) 2
b) 3
c) 4
d) 5
Answer: a
Clarification: Recovery means to take the backup data while there is a crash.
9. Which are types of recovery control techniques:
a) Deferred update
b) Immediate update
c) All of the Mentioned
d) None of the Mentioned
Answer: c
Clarification: Recovery means to take the backup data while there is a crash.
10. Which server can join the indexes when only multiple indexes combined can cover the query:
a) SQL
b) DBMS
c) RDBMS
d) All of the mentioned
Answer: a
Clarification: Indexing reduces the difficulty in searching the data.