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 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
Get step-by-step solutions from verified subject matter experts
