Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6. What is the result/response from Oracle system if the STUDENT table created successfully? (0.5 marks) 7. Now enter the following records into the STUDENT

image text in transcribed

6. What is the result/response from Oracle system if the STUDENT table created successfully? (0.5 marks) 7. Now enter the following records into the STUDENT table: NAME TONY NG ALI MOHAMED ID CIT080001 CITO59876 CBA061234 CSCO75555 CEE042468 UAE000000 GRADE 100 80 90 50 60 DEGREE CSBP ITBP BABP ???? ???? BABP STEVE JOBS GREY MORE After entering, write the SQL statement to display all records listed with the following new column title (match spelling): (5 marks) NAME as Std-Name GRADE as Std-Grade DEGREE as Program 8. What is the SQL statement to display only the name of the student(s) with grade > 80? (2 marks) 9. When you run the above SQL statement in Q8, what is the result/response from Oracle systema (1 mark) 10. What is the result/response from Oracle system when you run the SQL statement to display only the ID column with query on DEGREE by descending order

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

Data Management Databases And Organizations

Authors: Richard T. Watson

2nd Edition

0471180742, 978-0471180746

More Books

Students also viewed these Databases questions

Question

5. Who should facilitate the focus group?

Answered: 1 week ago