The JOIN operation in SQL is used to: MCQ with Answer and Explanation

The JOIN operation in SQL is used to:
A. Create a new database
B. Delete rows
C. Sort data
D. Combine rows from two or more tables
Answer: Option D
Solution (By JKSSB Mock Tests)
JOIN combines data from multiple tables based on related columns.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which database anomaly describes the necessity to update the exact same data value in multiple independent rows, creating a risk of data inconsistency?
A. Selection Anomaly
B. Insertion Anomaly
C. Update Anomaly
D. Structural Anomaly

Correct Answer: Option C


Explanation:
An Update Anomaly occurs when data is redundantly duplicated across rows, requiring changes to be made to every copy, risking inconsistencies if any row is missed.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which software utility serves as an interface between an application program and the physical database files?
A. Compiler
B. Operating System
C. Linker
D. Database Management System (DBMS)

Correct Answer: Option D


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 #3
What is a column in a relational database table formally called?
A. Attribute
B. Tuple
C. Degree
D. Entity

Correct Answer: Option A


Explanation:
A column in a database table represents a property or characteristic of the entity and is formally known as an attribute.

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