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.

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

  &

  ||

  +

  &&

  Half-n-half Clue
 

2.

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

  VARBIT2(length)

  BIT VARYING(length)

  VARBIT(length)

  BIT(length)

  Half-n-half Clue
 

3.

SQL is a _______ language.

  object-oriented

  procedural

  non-procedural

  Half-n-half Clue
 

4.

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
 

5.

SQL is platform independent.

  True

  False

 

6.

Which type of SQL environment provides more flexibility in the event of any change in database object names?

  PL

  Real - time

  Embedded

  Dynamic

  Half-n-half Clue
 

7.

SQL statements can be executed without a DBMS.

  True

  False

 


 
7 more pages in DBMS Training & SQL Tutorial


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