Mastering Advanced Database Management Systems

DauntlessBlessing avatar
DauntlessBlessing
·
·
Download

Start Quiz

Study Flashcards

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;

Study Notes

Advanced Database Management Systems Class

  • The class outline does not include a specific activity (to be determined)

SQL Queries

  • The query 'UPDATE instructor SET salary = salary + (salary * 0.05)' increases the salary of all instructors by 5%
  • The query 'UPDATE instructor SET salary = salary * 1.05 WHERE salary < (SELECT AVG(salary) FROM instructor)' increases the salary of instructors who earn less than the average salary by 5%
  • The query 'UPDATE instructor SET salary = salary * 1.05 WHERE salary < 70000' increases the salary of instructors who earn less than $70,000 by 5%

Sorting Queries

  • The SQL query to sort the 'Students' table by FIRSTNAME, LASTNAME in descending order, and AGE in descending order is (query not provided)

Advanced Database Management Systems Quiz: Join, Relational Algebra, and PLSQL

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.

Use Quizgecko on...
Browser
Browser