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?

  Permanent and Temporary

  Static and Dynamic

  Local and Global

  Half-n-half Clue
 

2.

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

  No sub-types of temporary tables exist

  Local and Global

  Static and Dynamic

  Persistent and Non-Persistent

  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-2024 Syvum Technologies Inc. Privacy Policy Disclaimer and Copyright
Previous
-
Next
-