Database Concepts - Third

A relational database consists of a collection of ..............

• tables

• fields

• records

• keys

............ is a field in a database table (or a combination of fields) that has a unique value.

• a foreign key

• a primary key

• metadata

• an alternate key

A field in a database table whose values are the same as the primary key of another table is called .......

• a foreign key

• a primary key

• metadata

• an alternate key

A group of columns serving as a primary key are known as ............ key

• candidate

• composite

• alternate

• foreign

Pool of values from where a column draws the value is called .............

• table

• attribute

• dataset

• domain

The column which has unique values in all the rows but is not a primary key is called ............. key.

• candidate

• alternate

• composite

• foreign

A .................... key may store NULL values in it.

• primary key

• foreign key

• composite key

• none of these

Data redundancy may lead to data inconsistency.

• True

• False

All candidate keys are primary keys.

• True

• False

Alternate keys are not primary keys.

• True

• False