MCQ of Database Management System (DBMS) Set – 5

1. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ?????????.;A) Fields;B) Records;C) Relations;D) Keys;2. ??????.. contains information that defines valid values that are stored in a column or data type.;A) View;B) Rule;C) Index;D) Default;3. Which of the syntax is correct for insert statement?;i) insert into values;ii) insert into (column list) values;A) i-only;B) ii-only;C) Both of them;D) None of them;4. ??????. First proposed the process of normalization.;A) Edgar. W;B) Edgar F. Codd;C) Edward Stephen;D) Edward Codd;5. For using a specific database ????? command is used.;A) use database;B) databasename use;C) Both A &B;D) None of them;6. Which of the following is not comparison operator?;A) ;B);C) = =;7. An outstanding functionality of SQL is its support for automatic ???? to the target data.;A) programming;B) functioning;C) navigation;D) notification;8. ??????? is a special type of integrity constraint that relates two relations & maintains consistency across the relations.;A) Entity Integrity Constraints;B) Referential Integrity Constraints;C) Domain Integrity Constraints;D) Domain Constraints;D) Key Constraints;9. ?????..specifies a search condition for a group or an aggregate.;A) GROUP BY Clause;B) HAVING Clause;C) FROM Clause;D) WHERE Clause;10. Drop Table cannot be used to drop a table referenced by a ????? constraint.;A) Local Key;B) Primary Key;C) Composite Key;D) Foreign Key