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.

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

  CLOB

  VCHAR

  NCHAR

  VARCHAR

  Half-n-half Clue
 

2.

SQL is a record level language.

  True

  False

 

3.

_______ value is used to represent unknown or undefined values.

  Blank

  NULL

  ZERO

  Half-n-half Clue
 

4.

SQL is platform independent.

  True

  False

 

5.

What is the POSITION function used for?

  None of the above

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

  To extract the row number of a particular record.

  Half-n-half Clue
 

6.

If we write a program in a programming language and switch to SQL when we require to use the database, then the SQL environment in use is know as _______ SQL.

  Dynamic

  Embedded

  PL

  Real - time

  Half-n-half Clue
 

7.

SQL is used for:
A. creating, managing and deleting tables and manage the relationships among the stored date.
B. generating queries, organizing, managing and retrieving data stored in a database.
C. maintaining data integrity and coordinate data sharing.

  A and B

  B and C

  All of the above

  None of the above

  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
-