You are to use Oracle database system to create the following database: STUDENT

ID: 3712524 • Letter: Y

Question

You are to use Oracle database system to create the following database:

STUDENT table contains 4 columns: ID, NAME, GRADE and DEGREE.

(hint: max. 3 digits, 2 valid digits, last digit is always ZERO and scale is NOT zero)

Based on the above database, please answer the following questions in the space provided:

ID NAME GRADE DEGREE

CIT080001 TONY NG 100 CSBP

CIT059876 ALI MOHAMED 80 ITBP

CBA061234 STEVE ADAMS 90 BABP

CSC075555 BILL GATES 50 ECBP

CEE042468 STEVE JOBS 60 EEBP

UAE000000 GREY MORE 0 BABP

After entering, write the SQL statement to display all records listed with the following new column title (match spelling):??????(5 marks)

1.) To diplay structure we use describe keyword as below.

DESC STUDENT;

2.) following response is given by oracle .

ORA-00942 Table or View Does Not Exist

3.) To delete table named STUDENT following command is exxecuted;

DROP TABLE STUDENT;

4.a)NO SUCH TABLES EXIST.

4.b) STUDENT dropped successfully;

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.