Syvum Home Page

Home > Quiz Games > Information Technology & Computer Programming > DBMS Training & SQL Tutorial >

DBMS Training & SQL Tutorial :
SQL Basics and SQL Data Types


Answer the following multiple-choice questions about introductory concepts of SQL and SQL data types.

Formats Info Page/Theory Quiz Review
Multiple choice

Your Performance  

1.

The string constant 'Roger''s' will be stored as _______.

  Roger''s

  Roger s

  Roger's

  Rogers

  Half-n-half Clue
 

2.

The data type used to store variable length bit strings is _______.

  BIT VARYING(length)

  BIT(length)

  VARBIT2(length)

  VARBIT(length)

  Half-n-half Clue
 

3.

SQL is platform independent.

  True

  False

 

4.

To represent a national character set literal, it has to be preceded by _______.

  NC

  C

  CN

  N

  Half-n-half Clue
 

5.

SQL stands for _______.

  Structural Query Language

  Structured Query Language

  Structured Question Language

  Systematic Query Language

  Half-n-half Clue
 

6.

Which of the following symbolic constant yields the current date?

  PRESENT_DATE

  CURRENT_DATE

  NOW

  TODAY

  Half-n-half Clue
 

7.

_______ value is used to represent unknown or undefined values.

  NULL

  Blank

  ZERO

  Half-n-half Clue
 


 
7 more pages in DBMS Training & SQL Tutorial


Contact Info © 1999-2020 Syvum Technologies Inc. Privacy Policy Disclaimer and Copyright
Previous
-
Next
-