Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started