Miscellaneous Test 3 - Online Test

Test Difficulty Level: Easy

Syllabus of Test

Covering all general topics of SQL.

Sample Question from this online test:

Question: Consider the following code, then choose the most appropriate option.

CREATE TABLE CUSTOMER (
CUSTOMER_ID NUMBER (5),
CUSTOMER_NAME VARCHAR2 (40),
ZIP NUMBER (5)) AS
SELECT CUST_ID, NAME, ZIP_CODE
FROM CUSTOMERS

Option A: The code will create a table named CUSTOMER.

Option B: Column datatypes should not be specified when creating a table from another table.

Option C: ZIP is a reserved word and cannot be used as a column name.

Option D: When creating a new table from an existing table, you cannot specify a different column name.

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

Start this Test






Comments

Kevin Yang on 2010-12-21 22:31:28 wrote,

The correct answer of question 9 should be B, not A

gautam pradhan on 2011-06-25 15:12:23 wrote,

good question and explanation

Ankit choudhary on 2012-08-13 10:15:08 wrote,

wonderful explanation

Sandeep Kumar on 2013-05-15 05:45:35 wrote,

Great question set..