Which SQL keyword is used to retrieve only unique values?
A. DISTINCTIVE
B. UNIQUE
C. DISTINCT
D. DIFFERENT
Answer: Option C
Solution(By Examveda Team)
This command is used to select the distinct rows.
For Example: If we want to select all distinct department names from employee table, the query would be:
SELECT DISTINCT dept FROM employee;
Join The Discussion
Comments ( 1 )
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of these
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None
Which operator performs pattern matching?
A. BETWEEN operator
B. LIKE operator
C. EXISTS operator
D. None of these
What operator tests column for the absence of data?
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these
What is the result of the ROUND(7.384, 1) function in Oracle SQL ?