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?

  NCHAR

  CLOB

  VCHAR

  VARCHAR

  Half-n-half Clue
 

2.

BINARY STRING data type is used to store images, audio, video and programs.

  True

  False

 

3.

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

  Rogers

  Roger's

  Roger s

  Roger''s

  Half-n-half Clue
 

4.

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

  ||

  &&

  &

  +

  Half-n-half Clue
 

5.

What is the POSITION function used for?

  To extract the row number of a particular record.

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

  None of the above

  Half-n-half Clue
 

6.

SQL is a record level language.

  True

  False

 

7.

Which of the following symbolic constant yields the current date?

  PRESENT_DATE

  CURRENT_DATE

  NOW

  TODAY

  Half-n-half Clue
 


 
7 more pages in DBMS Training & SQL Tutorial


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