What is a super key in a relational database? MCQ with Answer and Explanation

Question

Share Report Error

What is a super key in a relational database?

A. A key that has extra attributes beyond a candidate key

B. A set of attributes that uniquely identifies a row

C. Both A and B

D. A key that includes the primary key

Answer: Option C

Solution (By JKSSB Mock Tests)

A super key is a set of one or more attributes that uniquely identifies a row. A candidate key is a minimal super key.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Which software utility serves as an interface between an application program and the physical database files?

A. Compiler

B. Database Management System (DBMS)

C. Linker

D. Operating System

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Database Management System (DBMS) acts as an interface between application software and the underlying physical database, managing data storage, retrieval, and updates.

This question belongs to: Computer Database Management System (DBMS)

Question #2

What is the purpose of the SQL 'JOIN' clause?

A. To combine rows from two or more tables based on a related column

B. To delete records from a table

C. To create a new table

D. To combine columns from multiple tables into a single table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
JOIN is used to combine rows from different tables based on a common column, allowing querying across related tables.

This question belongs to: Computer Database Management System (DBMS)

Question #3

In the context of databases, what is a 'tuple'?

A. A table itself

B. A column of a table

C. A row of a table

D. A key constraint

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In relational databases, a tuple is a single row or record of a table.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs