Question: Create a table with the following information (2 Marks) Table Name Quiz Product firstname Column Name Length 13 30 Constraint Primary key PRID P_NAME P_PRICE

 Create a table with the following information (2 Marks) Table Name

Create a table with the following information (2 Marks) Table Name Quiz Product firstname Column Name Length 13 30 Constraint Primary key PRID P_NAME P_PRICE _EXPIRY P_MAN Data Type Varchar2 Char Number Date Date 4 - 1. In the table Quiz Product firstname to change the column P_NAME, Datatype is varchar2 and length is 25 (1 Mark) 2. Enter any two sample records of the table Quiz Product firstname (0.5 Mark) 3. Drop the column P_MAN from the table Quiz Product firstname, (0.5 Mark) 4 Remove all the rows and release the storage space from the table Quiz Product firstname. (1 Mark) Di Facu w Address

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!