Question: Name CU_ID CUS NAME CUS_ZIP Make updates to below table structure. Custmer_T_StudentID Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) 1- Create table with above structure (Screen

Name CU_ID CUS NAME CUS_ZIP Make updates to below table structure. Custmer_T_StudentID

 

Name CU_ID CUS NAME CUS_ZIP Make updates to below table structure. Custmer_T_StudentID Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) 1- Create table with above structure (Screen Prints Required) 2- Change table name to Customer_T_StudentID 3- Change CU_ID (column name) to CUS_ID 4- Change CUS_Name data_type VARCHAR2 25 to 255 5- Change CUS_ZIP data_type from Number(10) to Varchar2(10) 6- Add Constraint Primary Key to CUS_ID (column). 7- Add a Column CUS_STATES with Check constraint (MD, VA, DE, PA, NY) (Screen Prints Required) 8- Create a sequence / Insert record into the table 9- Modify CUS_Name in of recorded inserted in step 7. 10-Delete table data / Delete table structure

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!