Querying Database - 4 - DBMS Questions and Answers

1.

E.F.Codd developed the normalization process in the which early:

   A.) 1969
   B.) 1970
   C.) 1971
   D.) 1972

Answer: Option 'C'

Normalization helps in improving the quality of the data.

2.

Which formal method that locates and analyses relation schemas on the basis of their primary, candidate keys, and the FD’s that are present among the attributes of these schemas:

   A.) Functional dependency
   B.) Database modeling
   C.) Normalization
   D.) Decomposition

Answer: Option 'C'

Normalization

3.

Which s essential a business problem not a data problem:

   A.) Data
   B.) Database
   C.) Database design
   D.) All of the mentioned

Answer: Option 'C'

SQL-99 is the most recent version of standard SQL prescribed by the ANSI.

4.

Which is a bottom-up approach to database design that design by examining the relationship between attributes:

   A.) Functional dependency
   B.) Database modeling
   C.) Normalization
   D.) Decomposition

Answer: Option 'C'

Normalization

5.

How many types of insertion anomalies:

   A.) 1
   B.) 2
   C.) 3
   D.) 4

Answer: Option 'B'

2

Querying Database - 4 - DBMS Questions and Answers Download Pdf