Database Management System (DBMS) MCQs | Page - 99

Q. 981) Which server can join the indexes when only multiple indexes combined can cover the query:

Q. 982) In concurrency control policy the lock is obtained on

Q. 983) A concurrency-control policy such as this one leads to              performance since it forces transactions to wait for preceding transactions to finish before they can start.

Q. 984)                      are used to ensure that transactions access each data item in order of the transactions’          if their accesses conflict.

Q. 985) In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

Q. 986) Which statement is true regarding external tables?

Q. 987) SNAPSHOT is used for (DBA)

Q. 988) Isolation of the transactions is ensured by

Q. 989) Which of the following statements is/are not true for SQL profiler?

Q. 990) Which of the following is the original purpose of SQL?