Sams Teach Yourself SQL in 24 Hours, Second Edition

Hour 5, "Manipulating Data"

Quiz Answers

1:

Use the EMPLOYEE_TBL with the following structure: COLUMN DATA TYPE (NOT)NULL LAST_NAME VARCHAR2(20) NOT NULL FIRST_NAME VARCHAR2(20) NOT NULL SSN CHAR(9) NOT NULL PHONE NUMBER NULL LAST_NAME FIRST_NAME SSN PHONE SMITH JOHN 312456788 3174549923 ROBERTS LISA 232118857 3175452321 SMITH SUE 443221989 3178398712 PIERCE BILLY 310239856 317676390 What would happen if the following statements were run: insert into employee_tbl ('JACKSON', 'STEVE', '313546078', '3178523443'); insert into employee_tbl values ('JACKSON', 'STEVE', '313546078', '3178523443'); insert into employee_tbl values ('MILLER', 'DANIEL', '230980012', NULL); insert into employee_tbl values ('TAYLOR', NULL, '445761212', '3179221331'); delete from employee_tbl; delete ...