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.

_______ value is used to represent unknown or undefined values.

  ZERO

  Blank

  NULL

  Half-n-half Clue
 

2.

If our program generate SQL statements on-the-fly and sends it to the database as a text file, the SQL environment in use is known as _______ SQL.

  Dynamic

  Real - time

  PL

  Embedded

  Half-n-half Clue
 

3.

What is the POSITION function used for?

  To extract the row number of a particular record.

  None of the above

  To extract the starting position of a string in another string.

  Half-n-half Clue
 

4.

Which one of the following operators allow us to concatenate two strings?

  &&

  &

  +

  ||

  Half-n-half Clue
 

5.

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

  VARBIT(length)

  VARBIT2(length)

  BIT(length)

  BIT VARYING(length)

  Half-n-half Clue
 

6.

SQL is platform independent.

  True

  False

 

7.

What is the data type that is used to store large amounts of formatted text like objects?

  NCHAR

  CLOB

  VARCHAR

  VCHAR

  Half-n-half Clue
 


 
7 more pages in DBMS Training & SQL Tutorial


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