WorksheetsDatabase Concepts - Introduction
Total questions: 13
Worksheet time: 4mins
(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
Which model is used in MySQL?
Network Model
Hierarchical Model
Relational Model
Vertical subset of a table is known as .................
Fields
Records
Attributes
Tuple
Horizontal subset of a table is known as .....................
Records
Fields
Tuple
Rows
