Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ou are to use Oracle database system to create the following database: STUDENT table contains 4 columns: ID, NAME, GRADE and DEGREE. ID - 9-character

image text in transcribed

ou 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 - must be any of these: 0, 10, 20, 30, 40, 50, 60, 70, 80, 90 and 100. (hint: max. 3 digits, 2 valid digits, last digit is always ZERO and scale is NOT zero) DEGREE 4-character program name (e.g. CSBP) Based on the above database, please answer the following questions in the space provided:| 1. To check if a database table exists or not, one way is to display its structure. What is the SQL statement to display the structure of STUDENT table? (1 mark) 2. When you run the above SQL statement in Q1, if STUDENT table does not exist, what is the (0.5 marks) result/response from Oracle system? 3. 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 (1 mark) 4. When you run the above SQL statement in Q3, what is the result/response from Oracle system if: a. STUDENT table does not exist already? (0.5 marks) b. STUDENT table exists? (0.5 marks)

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_2

Step: 3

blur-text-image_3

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

Repairing And Querying Databases Under Aggregate Constraints

Authors: Sergio Flesca ,Filippo Furfaro ,Francesco Parisi

2011th Edition

146141640X, 978-1461416401

More Books

Students also viewed these Databases questions