Chapter 3-Hands-On Assignments-Arshak Markhoyan.txt -...

This preview shows page 1 - 2 out of 2 pages.

Student Name: Arshak MarkhoyanChapter 2 Lab AssignmentHANDS-ON Exercises:Answer to Question 1CREATE TABLE CATEGORY(CatCode CHAR(2),CatDesc VARCHAR(10));--Result: Table CATEGORY created.Answer to Question 2CREATE TABLE EMPLOYEES(Emp# NUMBER(5),Lastname VARCHAR2(15),Firstname VARCHAR2(12),Job_class VARCHAR(4));--Result: Table EMPLOYEES created.Answer to Question 3ALTER TABLE EMPLOYEESADD (EmpDate DATE DEFAULT SysDate,EndDate DATE);--Result: Table EMPLOYEES altered.Answer to Question 4ALTER TABLE employeesMODIFY job_class VARCHAR2(2);Answer to Question 5
End of preview. Want to read all 2 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Dr Muhammad Afzal
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture