SQL Basic Aptitude Questions and Answers | Set 4

List of SQL Basic Aptitude Questions

16) Which command is used to submit (apply) all changes?
  1. COMMIT
  2. DONE
  3. SUBMIT
  4. APPLY

17) Which command is used to provide permissions to the database user?
  1. GIVE
  2. PROVIDE
  3. GRT
  4. GRANT

18) Which operator(s) is/are used to check more than one conditions with WHERE clause?
  1. AND
  2. OR
  3. BOTH AND, OR
  4. None of these

19) Which statement is used to extract different values from a table?
  1. SELECT DISTINCT
  2. SELECT RANDOM
  3. SELECT DIFFERENT
  4. SELECT DIFF

20 Which keyword is used with ORDER BY clause to display record set in descending order?
  1. DESCENDING
  2. DESC
  3. REVERSE
  4. REV





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.