One of the module in the database management system which is responsib – McqOptions

MCQOPTIONS

1.	One of the module in the database management system which is responsible for choosing efficient execution plan considering queries is considered as
A.	index and glossary optimization
B.	query processing and optimization
C.	structural optimization
D.	content optimization
Answer» C. structural optimization

Discussion

No Comment Found

Related MCQs

Consider the following relational schemes for a library database:Assume {Author, Title} is the key for both schemes. Which of the following statements is true?
Which of the following fixed database roles can add or remove user IDs?
A view whose contents are computed and stored is called as _______
The process of replacing a nested query with a query with a join is known as _________
The size of a _____ is simply V(A,r) where r is the relation and A is a distinct value
By default sql server has ___________ isolation level
Which of the following operations is associative
State true or false: Estimation of the size of the result of a join is not possible
Ensuring isolation property is the responsibility of the
_______________ is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.