Home »
Aptitude Questions & Answers »
DBMS Aptitude Questions
SQL Basic Aptitude Questions and Answers | Set 4
List of SQL Basic Aptitude Questions
16)
Which command is used to submit (apply) all changes?
- COMMIT
- DONE
- SUBMIT
- APPLY
Correct Answer - 1
COMMIT
17)
Which command is used to provide permissions to the database user?
- GIVE
- PROVIDE
- GRT
- GRANT
18)
Which operator(s) is/are used to check more than one conditions with WHERE clause?
- AND
- OR
- BOTH AND, OR
- None of these
Correct Answer - 3
BOTH AND, OR
19)
Which statement is used to extract different values from a table?
- SELECT DISTINCT
- SELECT RANDOM
- SELECT DIFFERENT
- SELECT DIFF
Correct Answer - 1
SELECT DISTINCT
20
Which keyword is used with ORDER BY clause to display record set in descending order?
- DESCENDING
- DESC
- REVERSE
- REV