Test Difficulty Level: Easy

Syllabus of Test

Managing Tables - Naming Conventions, Creating from Another Table, Modifying Table Defenitions, Dropping/Renaming Tables. Managing Views. Creating a View. Retriving Data. Inserting, Updating and Deleting Data. Dropping a View.

Sample Question from this online test:

Question: The table STATE is defined as in the following table.
If you execute the statement that follows, how many constraints will the STATE_COPY table have ?

CREATE TABLE STATE_COPY AS SELECT * FROM STATE

Option A: 4

Option B: 1

Option C: 0

Option D: 2

To answer, click the "Start This Test" button below.

Start this Test