Question: You are to use Oracle database system to create the following database: STUDENT table contains 4 columns: ID , NAME, GRADE and DEGREE * ID
You are to use Oracle database system to create the following database:
STUDENT table contains columns: ID NAME, GRADE and DEGREE
ID character student ID eg CIT
NAME max. up to character student name.
GRADE number
DEGREE character program name eg CSBP
Based on the above database, please answer the following questions in the space provided:
Q It is a common practice to delete an old existing database table before you create a new one with the same name. Please write the SQL statement to delete a table named STUDENT
Q When you run the above SQL statement in Q if STUDENT table does not exist, what is the resultresponse from Oracle system?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
