WorksheetsDatabase Concepts - Third
Total questions: 10
Worksheet time: 5mins
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
