Database Concepts - Introduction

(a)   is the degree of table Employee?

(a)   is the cardinality of table Employee.

The number of columns in a table is known as (a)   of a table.

The number of records in table is known as (a)   of a table.

Which all options are correct regarding a Primary key?

• Can have many primary keys in a table

• it can't be left blank

• it can't have duplicate values

Which one is correct?

• Alternate key – primary key = Candidate keys

• Candidate keys - Alternate key = primary key

• Candidate keys – primary key = Alternate key

Which key is used to maintain relationship between tables?

• Candidate key

• Foreign key

• Primary key

• Alternate key

In a table there can be many alternate keys.

• True

• False

In a table there can be many candidate keys.

• True

• False

All items in a column of a table should be .................

• heterogeneous

• homogeneous