Database Management System (DBMS) MCQs | Page - 69

Q. 681) The term for information that describes what type of data is available in a database is:

Q. 682) A data type that creates unique numbers for key columns in Microsoft Access is:

Q. 683) A dependency exist between two columns when

Q. 684) In the                      normal form, a composite attribute is converted to individual attributes.

Q. 685) A table on the many side of a one to many or many to many relationship must:

Q. 686) Functional Dependencies are the types of constraints that are based on             

Q. 687) A relation is in                          if an attribute of a composite key is dependent on an attribute of other composite key.

Q. 688) What are the desirable properties of a decomposition

Q. 689) R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?

Q. 690) The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is