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.
Related Online Tests:
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,
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