WorksheetsDatabase Relations Quiz
Total questions: 12
Worksheet time: 4mins
What is a Relation in a database?
A two-dimensional structure composed of rows and columns
A one-dimensional list of values
A hierarchical tree of data
A collection of unorganized data
Which of the following is another name for a Relation?
File
Record
Table
Attribute
In a relation, what does a Column represent?
An entire dataset
A specific property of an entity
A single instance of an entity
A group of tuples
Which of the following terms refers to a Column?
Tuple
Row
Field / Attribute
Record
A Tuple in a relation refers to:
A column in a table
A two-dimensional table
A single row in a table
A key in a database
Which term is synonymous with Tuple?
Field
Record
Attribute
Relation
What do Keys in a relation represent?
Columns that describe entities
One or more attributes that determine other attributes
A set of rows with similar data
The entire relation
Which key uniquely identifies each row in a table?
Foreign Key
Primary Key
Composite Key
Candidate Key
Which key is used to establish relationships between two tables?
Candidate Key
Foreign Key
Primary Key
Super Key
If a table has multiple candidate keys, which one is chosen as the main identifier?
Composite Key
Super Key
Primary Key
Alternate Key
What is the purpose of a Foreign Key in a database?
To uniquely identify a record in a table
To establish a link between two tables
To store multiple values in a single column
To define the structure of a table
Which of the following describes a Composite Key?
A key that consists of multiple attributes
A key that is automatically generated by the database
A key that is used to enforce uniqueness in a single column
A key that is not used in any relationships
