Creating And Managing Tables Tables And Views - Online Test

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






Comments

Himansu Mallick on 2012-04-08 19:22:14 wrote,

just check out the answer of question no19....i think the answer will be option c.

keerthi kumarp on 2012-05-20 05:33:33 wrote,

for q19 answer is A not C

Ram Manoj Reddy Bala on 2012-07-04 05:33:35 wrote,

very tough....

praveen dubey on 2013-03-11 11:12:31 wrote,

no there is no drop option for columns..so it has to go with alter table drop column