MCQ of Database Management System (DBMS) Set – 2

1. The candidate key is that you choose to identify each row uniquely is called ?????..;A) Alternet Key;B) Primary Key;C) Foreign Key;D) None of the above;2. ?????.. is used to determine whether of a table contains duplicate rows.;A) Unique predicate;B) Like Predicate;C) Null predicate;D) In predicate;3. To eliminate duplicate rows ?????? is used;A) NODUPLICATE;B) ELIMINATE;C) DISTINCT;D) None of these;4. State true or false;i) A candidate key is a minimal super key.;ii) A candidate key can also refer to as surrogate key.;A) i-true, ii-false;B) i-false, ii-true;C) i-true, ii-true;D) i-false, ii-false;5. DCL stands for;A) Data Control Language;B) Data Console Language;C) Data Console Level;D) Data Control Level;6. ???????? is the process of organizing data into related tables.;A) Normalization;B) Generalization;C) Specialization;D) None of the above;7. A ??????. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.;A) Weak entity;B) Strong entity;C) Non attributes entity;D) Dependent entity;8. ?????.. is the complex search criteria in the where clause.;A) Substring;B) Drop Table;C) Predict;D) Predicate;9. ??????? is preferred method for enforcing data integrity;A) Constraints;B) Stored Procedure;C) Triggers;D) Cursors;10. The number of tuples in a relation is called its ????. While the number of attributes in a relation is called it?s ??????..;A) Degree, Cardinality;B) Cardinality, Degree;C) Rows, Columns;D) Columns, Rows