IncludeHelp_logo
Skip Navigation Links

Home » Aptitude Questions & Answers » DBMS Aptitude Questions

SQL Query Syntaxes Aptitude Questions and Answers | Set 1

SQL Query Syntaxes Aptitude Questions and Answers - This section contains Aptitude Questions and Answers on SQL Query Syntaxes.

List of SQL Query Syntaxes Aptitude Questions and Answers

1) Which is the correct SELECT statement to display all records with all columns of a table?
  1. SELECT * FROM table_name
  2. SELECT ALL COLS FROM table_name
  3. SELECT FROM table_name
  4. None of these
Answer

2) Which is the correct SELECT statement to display all records with selected columns of a table?
  1. SELECT * FROM table_name
  2. SELECT column1,column2,... FROM table_name
  3. SELECT FROM table_name
  4. None of these
Answer

3) Which is the correct SELECT statement to display selected records (based on the condition) with all columns of a table?
  1. SELECT column1,column2,... FROM table_name
     WHERE condition
  2. SELECT FROM table_name
     WHERE condition
  3. SELECT ALL FROM table_name
     WHERE condition
  4. SELECT * FROM table_name
     WHERE condition
Answer

4) Which is the correct syntax for BETWEEN operator?
  1. WHERE column_name BETWEEN (value1 AND value2)
  2. WHERE column_name BETWEEN value1 AND value2
  3. WHERE column_name BETWEEN (value1, value2)
  4. WHERE BETWEEN column_name value1 AND value2
Answer

5) Which is the correct syntax for IN operator?
  1. WHERE column_name IN (value1, value2, ...)
  2. WHERE column_name IN value1 AND value2
  3. WHERE column_name IN (value1 AND value2, AND ...)
  4. WHERE IN column_name value1 AND value2 AND ...
Answer

SQL Basic Aptitude Questions | Set 5
SQL Query Syntaxes Aptitude Questions | Set 2



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.