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

Question
Which SQL keyword is placed immediately inside a SELECT statement or an aggregate function to eliminate duplicate rows from the output?
A. SINGLE
B. DIFFERENT
C. UNIQUE
D. DISTINCT
Answer: Option D
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.
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 of the following commands is a part of Transaction Control Language (TCL) in SQL?
A. DELETE
B. GRANT
C. ALTER
D. COMMIT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
COMMIT is a TCL command used to permanently save all modifications made during the current transaction into the database.
This question belongs to: Computer Database Management System (DBMS)
Question #2
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
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
JOIN combines data from multiple tables based on related columns.
This question belongs to: Computer Database Management System (DBMS)
Question #3
In an Entity-Relationship (ER) diagram, what geometric shape is used to represent an entity type?
A. Rectangle
B. Triangle
C. Diamond
D. Ellipse
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In standard ER modeling notation, rectangles are used to represent entity sets or entity types.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Abbreviations 369 Computer Hardware 430 Cyber Security 269 Memory and Storage Devices 438 Internet and Web Technologies 461
Explore Subjects
Reasoning 1111 Accountancy and Statistics 3179 Maths 5575 Static General Knowledge 6362 Science 4430
Practice Mix
Which type of soil is generally found in regions receiving rainfall greater than 200 cm annually?
That which cannot be touched
Which of the following states receives the highest rainfall during the Northeast Monsoon?
S1: Direct taxes are levied on income and wealth. S2: Direct taxes can be shifted to others. Which statement(s) is/are correct?
She identifies ___ the character.