Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions

Question

Question 1 (a2) What is the reaction force Dx in [N]?

Answered: 1 week ago

Question

8. Describe how cultural spaces are formed.

Answered: 1 week ago