Which SQL keyword is placed immediately inside a SELECT statement or an aggregate function to eliminate duplicate rows from the output? MCQ with Answer and Explanation

Which SQL keyword is placed immediately inside a SELECT statement or an aggregate function to eliminate duplicate rows from the output?
A. DIFFERENT
B. DISTINCT
C. UNIQUE
D. SINGLE
Answer: Option B
Solution (By JKSSB Mock Tests)
The DISTINCT keyword is used to remove all duplicate values or records from the output of an SQL SELECT query.

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. Linker
B. Database Management System (DBMS)
C. Compiler
D. Operating System

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
Which of the following is a DCL (Data Control Language) command?
A. COMMIT
B. CREATE
C. SELECT
D. GRANT

Correct Answer: Option D


Explanation:
GRANT and REVOKE are DCL commands. COMMIT is TCL, SELECT is DML, CREATE is DDL.

This question belongs to: Computer Database Management System (DBMS)
Question #3
The total number of tuples (rows) contained within a relational database table is called its what?
A. Degree
B. Cardinality
C. Density
D. Dimension

Correct Answer: Option B


Explanation:
The number of tuples or rows in a relation is defined as the cardinality of that relation.

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