Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. For every relationship, how many possible types of actions are there when enforcingminimum cardinalities?
a. Two
b. Three
c. Four
d. Six
Q. In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
a. The line numbers reported match the line numbers you see in your text editor.
b. SQL*Plus will automatically show the errors to you.
c. To see the errors, enter SHOW ERRORS in SQL*Plus.
d. If there are no syntax errors, you will receive the message "NO ERRORS."
Q. Which of the following is not true about indexes?
a. Indexes are created to enforce uniqueness on columns.
b. Indexes are created to enable fast retrieval by column values.
c. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
d. Indexes are created with the ALTER TABLE comman
Q. In ……….. normal forms, any multivalued attributes have been removed.
a. First
b. Second
c. Third
d. Fourth
Q. A (n) …………….. is an attribute in a relation that serves as a primary key of another relation in the same.
a. Composite key
b. Foreign key
c. Identifier key
d. Primary key
Q. In the process of decomposition is called as
a. Normalization
b. Generalization
c. Aggregation
d. Specalization
Q. A relation between 2 set of attributes is called as
a. Join dependency
b. Association
c. Functional Dependency
d. Multivalued dependency
Q. Two or more attributes that can be a key are called :
a. determinants
b. primary key
c. Composite key
d. foreign key
Q. Cartesian product in relational algebra is
a. a Unary operator.
b. a Binary operator.
c. a Ternary operator
d. not defined
Q. In the relational modes, cardinality is termed as:
a. Number of tuples.
b. Number of attributes.
c. Number of tables.
d. Number of constraints.