Computer Science MCQs » DBMS MCQs
A rotational database consists of …….?

A) Tables
B) Fields
C) Records
D) Keys

The term …… is used to refer to a row?

A) Attribute
B) Tuple
C) Field
D) Instance

The term attribute refers to a ……. of a table?

A) Record
B) Column
C) Tuple
D) Key

Which of the following is a tuple-generating dependency?

A) Functional dependency
B) Equality-generating dependencies
C) Multi-valued dependencies
D) Non-functional dependency

The main task carried out in the ……. is to remove repeating attributes to separate tables?

A) First Normal Form
B) Second Normal Form
C) Third Normal Form
D) Fourth Normal Form

Which of the following has each related entity set its own schema and there is an additional schema for the relationship set?

A) A many-to-many relationship set
B) A multi-valued attribute of an entity set
C) A one-to-many relationship set
D) Both A & B

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set?

A) A many-to-many relationship set
B) A multi-valued attribute of an entity set
C) A one-to-many relationship set
D) Both A & B