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