Question

Oracle certified professional

Create table University (u_id[primary key], u_name, u_city, u_grade, u_age). (20 entries all different) (Grade can be A, B, C) (u_age is how old the university is i.e. number data type) Go through the list of queries to be executed below and then create the table accordingly. 1. Update u_name to ‘Konnest’ where u_id = 3. Display all columns and rows using the Select statement. 2. Display distinct u_city for the u_name = ‘MITWPU’. 3. Display the information of universities and sort them according their u_age. 4. Display the columns u_name and u_city and group them by the total age of the university. 5. Display name of university have the highest age. 6. Display the columns and group them according to the grade each university has. (Think!)​

Answer 1

Answer:

Today as you woke up you got a message from schools office that your mathematics exam has been postponed on account of severe Cyclone. You were so tensed about the exam that you studied all night. Write a dairy entry expressing your feeling.

Answer 2

Answer:

Write the correct question