LAB2 - Chapter 3 Lab Assignment HANDS-ON Exercises. Answer...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Chapter 3 Lab Assignment HANDS-ON Exercises. Answer to Question 1 Err:510 SQL> edit 1 CREATE Table category 2 (catcode VARCHAR2(2), 3* catdesc VARCHAR(10)) SQL> / Table created. Answer to Question 2 Err:510 SQL> edit 1 CREATE Table employees 2 (job_class VARCHAR2(4), 3 lastname VARCHAR2(12), 4 firstname VARCHAR2(12), 5* emp# CHAR(5)) 12/06/10 Table created. Answer to Question 3 Err:510 SQL> edit 1 ALTER TABLE employees 2 ADD (empdate DATE DEFAULT SYSDATE, 3* enddate DATE) SQL> / Table altered. Answer to Question 4 Err:510
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Page 2 SQL> edit 1 ALTER TABLE employees 2* MODIFY job_class VARCHAR2(2) SQL> / Table altered. Answer to Question 5 Err:510 SQL> ALTER TABLE employees 2 DROP COLUMN enddate Table altered. Answer to Question 6 Err:510 SQL> RENAME employees TO jl_emps 12/02/10 Table renamed. Answer to Question 7 Err:510 SQL> edit 1 CREATE TABLE book_pricing 2 AS (SELECT isbn id, cost, retail, category 3* FROM books) SQL> / Table created. Answer to Question 8
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

LAB2 - Chapter 3 Lab Assignment HANDS-ON Exercises. Answer...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online