Home / Engineering / Database Management System (DBMS) / Question

M

Mr. Dubey • 51.47K Points
Coach 

Q.) What is true about indexes?

(A) indexes enhance the performance even if the table is updated frequently
(B) it makes harder for sql server engines to work to work on index which have large keys
(C) it doesn’t make harder for sql server engines to work to work on index which have large keys
(D) none of the mentioned
Correct answer : Option (B) - it makes harder for sql server engines to work to work on index which have large keys

Share

Previous

Next

Discusssion

Login to discuss.

Related MCQs on Database Management System (DBMS)

Q. The data link layer takes the packets from _________ and encapsulates them into frames for transmission.

Q. The first type of streams is specially used to represent _________

Q. The result of 0*1 in binary is

Q. Which of the following are decidable ? 1. whether the intersection of two regular language is infinite. 2. whether a give context free language is regular 3. whether two push down automata accept the same language. 4. whether a given grammar is context free

Q. Which of the following device is used to connect two systems, especiallyif the systems use different protocols?

Q. Which of the following is an architectural conflict?

Q. In which of the following metaphor physical system is directly totally matches with virtual system

Q. To replace the relation section with some other relation the initial step to be carried out is

Q. An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.

Q. Which of the following is not an activity of Structured Analysis (SA) ?