Syvum Home Page

Home > Quiz Games > Information Technology & Computer Programming > DBMS Training & SQL Tutorial >

DBMS Training & SQL Tutorial :
Creating Database Objects


Answer the following multiple-choice questions on creating database objects.

Formats Info Page/Theory Quiz Review
Multiple choice

Your Performance  

1.

What are the two types of tables that can be created in a RDBMS?

  Local and Global

  Static and Dynamic

  Permanent and Temporary

  Half-n-half Clue
 

2.

What are the type of temporary tables that can be created in a RDBMS?

  Static and Dynamic

  Local and Global

  Persistent and Non-Persistent

  No sub-types of temporary tables exist

  Half-n-half Clue
 

3.

The ON COMMIT clause can be applied to _______ tables.

  permanent

  temporary

  both temporary and permanent

  Half-n-half Clue
 

4.

Which of the following are valid column constraints:
A. NULL
B. DISTINCT
C. CHECK
D. FOREIGN KEY

  A

  C

  C, D

  All of the above

  Half-n-half Clue
 

5.

Which of the following are valid table constraints:

A. PRIMARY KEY
B. UNIQUE
C. CHECK
D. FOREIGN KEY

  A and D

  B and C

  A, C and D

  All of the above

  Half-n-half Clue
 

6.

Table constraints can be applied to individual columns and groups of columns.

  True

  False

 

7.

Which of the following are valid referential integrity constraint optional clauses for ON DELETE:
A. NO ACTION
B. CASCADE
C. SET NULL
D. SET DEFAULT

  A and B

  A, B and C

  A, B and D

  All of the above

  Half-n-half Clue
 


 
7 more pages in DBMS Training & SQL Tutorial


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