- Tutorials
- Courses
- Tracks
Relations & Tuples Basics Quiz
Question 1
Which of the following uniquely identifies a tuple in a relation?
Super Key
Candidate Key
Primary Key
Foreign Key
Question 2
What does Cardinality of a relation refer to?
Number of attributes
Number of relations
Number of keys
Number of tuples
Question 4
What does Referential Integrity ensure?
All data in a column is unique
Every table has a primary key
Foreign key values match primary keys in the referenced table
No attribute has NULL value
Question 5
What is a tuple in a DBMS?
A column in a table
A database schema
A single row or record in a table
A type of query
Question 6
In a relational database, what does each column in a tuple represent?
A row
A primary key
An attribute or field
A tuple
Question 7
How are tuples used in normalization?
To delete data
To increase redundancy
To organize data and reduce redundancy
To replicate data
Question 8
What does a query return in a relational database?
Columns only
Tables only
A set of tuples that match criteria
Attributes only
Question 9
What is the role of a Logical Tuple in DBMS?
Stores backup data
Temporarily represents data in memory
Creates the schema
Deletes duplicate data
Question 10
In the CUSTOMER table, which of the following is most likely a tuple?
customer_id
first_name
1, John, Smith, [email protected]
email
There are 10 questions to complete.