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
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.