FAT Lab Quiz

1. 1. Which is the correct SELECT statement to display all records with all columns of a table?

• SELECT * FROM table_name

•    SELECT ALL COLS FROM table_name

• SELECT FROM table_name

2. 2. Which is the correct SELECT statement to display all records with selected columns of a table?

• SELECT * FROM table_name

• SELECT column1,column2,... FROM table_name

•   SELECT FROM table_name

3. 3. Which is the correct SELECT statement to display selected records (based on the condition) with all columns of a table?

• SELECT column1,

  column2,... FROM 

  table name
   WHERE condition

• SELECT FROM table_name
   WHERE condition

• SELECT ALL FROM table_name
   WHERE condition

• SELECT * FROM table_name
   WHERE condition

4. 4. Which is the correct syntax for BETWEEN operator?

• WHERE column_name BETWEEN (value1 AND value2)

•   WHERE column_name BETWEEN value1 AND value2

• WHERE column_name BETWEEN (value1, value2)

• WHERE BETWEEN column_name value1 AND value2

5. 5. Which is the correct syntax for IN operator?

•   WHERE column_name IN (value1, value2, ...)

•   WHERE column_name IN value1 AND value2

• WHERE column_name IN (value1 AND value2, AND ...)

• WHERE IN column_name value1 AND value2 AND ...

6. 6. Which is the correct syntax for LIKE operator?

•   WHERE column_name IS LIKE pattern_string

• WHERE column_name IS LIKE ='pattern_string'

• WHERE column_name LIKE pattern_string

• WHERE column_name LIKE 'pattern_string'

7. 7. Which is the correct syntax for SELECT statement with TOP keyword to return TOP N records with all columns?

• SELECT * FROM TOP n table_name

• SELECT TOP n * FROM table_name

• SELECT * FROM table_name TOP n

8. 8. Which is the correct syntax for ORDER BY keyword?

•   SELECT * FROM table_name
   ORDER BY column_name ASC|DESC

• SELECT * FROM table_name
   ORDER BY ASC|DESC column_name

• SELECT * FROM table_name
   column_name ORDER BY ASC|DESC

• SELECT * FROM table_name
   ASC|DESC column_name ORDER BY

9. 9. Which is the correct syntax to sort returned record set in Ascending Order by Column1 and Descending Order by Column2?

• SELECT * FROM table_name
   ORDER BY ASC (column1), DESC (column2)

• SELECT * FROM table_name
   ORDER BY ASC column1, DESC column2

• SELECT * FROM table_name
   ORDER BY column1 ASC, column2 DESC

• SELECT * FROM table_name
   column1 ASC, column2 DESC ORDER BY

10. 10. Which is the correct syntax for INSERT INTO statement without specifying column names?

• INSERT INTO table_name
   VALUES( value1, value2, ...)

•   INSERT INTO VALUES( value1, value2, ...)
   table_name

•   INSERT INTO
   VALUES( value1, value2, ...) IN table_name

•   INSERT * INTO table_name
   VALUES( value1, value2, ...)