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 4 columns: ID, NAME, GRADE and DEGREE
* ID 9-character student ID (e.g. CIT081234).
* NAME max. up to 30-character student name.
* GRADE -number
* DEGREE 4-character program name (e.g. CSBP).
Based on the above database, please answer the following questions in the space provided:
Q.6. 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.7. When you run the above SQL statement in Q1, if STUDENT table does not exist, what is the result/response from Oracle system?

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!