What is a self join? MCQ with Answer and Explanation

What is a self join?
A. Joining more than two tables
B. Joining two different tables
C. Joining tables without a common column
D. Joining a table with itself
Answer: Option D
Solution (By JKSSB Mock Tests)
A self join is a join where a table is joined with itself, often used to compare rows within the same table.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
The actual collection of data tuples stored in a table at any specific point in time is called a what?
A. Relation Domain
B. Relation Degree
C. Relation Schema
D. Relation Instance

Correct Answer: Option D


Explanation:
A Relation Instance is the specific collection of data rows (tuples) present in a table at a given moment. It changes frequently as data is modified.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which clause is used in SQL to sort the final query result set in ascending or descending order?
A. ORDER BY
B. GROUP BY
C. SORT BY
D. ARRANGE BY

Correct Answer: Option A


Explanation:
The ORDER BY clause is used to sort the result set of a query in either ascending (default) or descending (using DESC) order.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What happens when a database transaction triggers a 'COMMIT' statement?
A. The transaction pauses temporarily.
B. The transaction is aborted and wiped.
C. All changes made by the transaction are made permanent on disk storage.
D. The database structure is dropped.

Correct Answer: Option C


Explanation:
Executing a COMMIT statement instructs the database engine to save all data updates performed during the transaction permanently into physical storage.

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