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.

SQL is a record level language.

  True

  False

 

2.

The data type of a column is declared as CHAR(5). Can the column contain a string of four characters?

  Yes

  No

 

3.

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.

  Embedded

  Real - time

  Dynamic

  PL

  Half-n-half Clue
 

4.

Which of the following symbolic constant yields the current date?

  NOW

  PRESENT_DATE

  TODAY

  CURRENT_DATE

  Half-n-half Clue
 

5.

The size of SQL data types differ across platforms.

  True

  False

 

6.

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

  CLOB

  VARCHAR

  NCHAR

  VCHAR

  Half-n-half Clue
 

7.

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

  Real - time

  Embedded

  PL

  Dynamic

  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
-