Database MCQs


Which of the normal form is based on the multivalued dependencies?
A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form

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 is a tuple generating dependency?
A. Functional dependency
B. Equality-generating dependencies
C. Multivalued dependencies
D. Non-functional dependencies

For each attribute of relation, there is a set of permitted values, called the___ of that attribute.
A. Domain
B. Relation
C. Set
D. Schema

The term attribute refers to a ____ of a table.
A. Record
B. Column
C. Tuple
D. Key

The ____ term is used to refer to a row.
A. Attribute
B. Tuple
C. Field
D. Instance

A ____ in a table represents a relationship among a set of values.
A. Column
B. Key
C. Row
D. Entity

A relational database consists of a collection of:
A. Tables
B. Fields
C. Records

Which of the following is a NoSQL database type?
A. SQL
B. Document database
C. JSON

Which of the following is not a NoSQL database?
A. SQL Server
B. Mongo DB
C. Cassandra
D. None of these