IncludeHelp_logo
Skip Navigation Links

Home » Aptitude Questions & Answers » DBMS Aptitude Questions

SQL Basic Aptitude Questions and Answers | Set 5

List of SQL Basic Aptitude Questions

21) If you do not use ASC or DESC keyword with ORDER BY clause, what will happen?
  1. Records will be displayed in Descending Order.
  2. Records will be displayed in Random Order.
  3. Records will be displayed in Ascending Order.
  4. Command will not be executed.
Answer

22) Which operator will be used, if you want to print all names of a table starts with 'A'?
  1. LIKE
  2. PATTERN
  3. SIMILAR
  4. =
Answer

23) Which operator can be used to check a range?
  1. RANGE
  2. FROM TO
  3. BETWEEN
  4. All of the above
Answer

24) Which operator allows you to specify multiple values in WHERE clause?
  1. LIKE
  2. IN
  3. BETWEEN
  4. RANGE
Answer

25 _______ are used to temporarily rename a table or column heading?
  1. RENAME
  2. ALTER
  3. RENAME
  4. SQL ALIAS (AS)
Answer

SQL Basic Aptitude Questions | Set 4
SQL Query Syntaxes Aptitude Questions | Set 1



Comments and Discussions!

Load comments ↻



Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

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