5 Questions
Which of the following activities is NOT included in the outline of the Advanced Database Management Systems class?
Query
What is the purpose of the SQL query 'UPDATE instructor SET salary = salary + (salary * 0.05)'?
To give a 5% salary raise to all instructors
What is the purpose of the SQL query 'UPDATE instructor SET salary = salary * 1.05 WHERE salary < (SELECT AVG(salary) FROM instructor)'?
To give a 5% salary raise to instructors whose salary is less than average
What is the purpose of the SQL query 'UPDATE instructor SET salary = salary * 1.05 WHERE salary < 70000'?
To give a 5% salary raise to instructors who earn less than 70000
Which SQL query is used to sort the 'Students' table by FIRSTNAME, LASTNAME in descending order, and AGE in descending order?
SELECT * FROM Students ORDER BY FIRSTNAME, LASTNAME DESC, AGE DESC;
Advanced Database Management Systems Quiz: Join, Relational Algebra, and PLSQL
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free