Test: Final Exam - Database Programming with SQL

Test: Final Exam - Database Programming with SQL Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 8 Lesson 1 1. You are creating the EMPLOYEES table. This table should contain the COMMISSION_PCT column and use a value of 10 percent if no commission value is provided when a record is inserted. Which line should you include in the CREATE TABLE statement to accomplish this task? Mark for Review (1) Points commission_pct NUMBER(4,2) DEFAULT 0.10 (*) commission_pct NUMBER(4,2) DEFAULT = 0.10 commission_pct NUMBER(4,2) DEFAULT (0.10) commission_pct NUMBER(4,2) (DEFAULT, 0.10) Correct 2. Evaluate this CREATE TABLE statement: 1. CREATE TABLE customer#1 ( 2. cust_1 NUMBER(9), 3. sales$ NUMBER(9), 4. 2date DATE DEFAULT SYSDATE); Which line of this statement will cause an error? Mark for Review (1) Points 1 2 3 4 (*) Incorrect. Refer to Section 8 3. Which of the following SQL statements will create a table called Birthdays with three columns for storing employee number, name and birthdate? Mark for Review (1) Points CREATE table BIRTHDAYS (EMPNO, EMPNAME, BIRTHDATE); CREATE table BIRTHDAYS (employee number, name, date of birth); CREATE TABLE Birthdays (Empno NUMBER, Empname CHAR(20), Birthdate DATE); (*) CREATE TABLE Birthdays (Empno NUMBER, Empname CHAR(20), Date of Birth DATE); Correct 4. Which column name is valid? Mark for Review (1) Points 1NUMBER NUMBER NUMBER_1$ (*) 1_NUMBER# Correct 5. Evaluate this CREATE TABLE statement: CREATE TABLE line_item ( line_item_id NUMBER(9), order_id NUMBER(9), product_id NUMBER(9)); You are a member of the SYSDBA role, but are not logged in as SYSDBA. You issue this CREATE TABLE statement. Which statement is true? CONTINUES...