This set of Database Questions and Answers focuses 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: Semantic query optimization is a technique used in database systems where the rewriter module optimizes queries by using semantic knowledge of the data. This involves transforming a given query into an equivalent but more efficient query based on constraints and integrity rules present in the database. This optimization is different from global query optimization, which focuses on execution plans and query evaluation strategies.
5. Database security helps organizations to protect data from _____
a) Internal users
b) External users
c) Non-external users
d) Non internal users
View Answer
Explanation: External users are the people who do not involve in the processing of the database.
6. Copying files to secondary or specific devices is known as ______
a) Retrieve
b) Backup
c) Recovery
d) Deadlock
View Answer
Explanation: Backup is required to take all the data.
7. How many types of recovery control techniques:
a) 2
b) 3
c) 4
d) 5
View Answer
Explanation: Recovery means to take the backup data while there is a crash.
8. Which are types of recovery control techniques:
a) Deferred update
b) Immediate update
c) All of the Mentioned
d) None of the Mentioned
View Answer
Explanation: Recovery means to take the backup data while there is a crash.
9. 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
View Answer
Explanation: Indexing reduces the difficulty in searching the data.
Sanfoundry Global Education & Learning Series – Database Management System.
- Practice Programming MCQs
- Check Programming Books
- Apply for Computer Science Internship
- Check Computer Science Books
- Practice RDBMS MCQ