Mastering Advanced Database Management Systems
5 Questions
9 Views

Mastering Advanced Database Management Systems

Created by
@DauntlessBlessing

Podcast Beta

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which of the following activities is NOT included in the outline of the Advanced Database Management Systems class?

  • Join
  • Query (correct)
  • PLSQL
  • Relational Algebra

    • What is the purpose of the SQL query 'UPDATE instructor SET salary = salary + (salary * 0.05)'?

  • To give a 10% salary raise to all instructors
  • To give a 5% salary raise to instructors who earn less than 70000
  • To give a 5% salary raise to all instructors (correct)
  • 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 < (SELECT AVG(salary) FROM instructor)'?

  • To give a 5% salary raise to instructors whose salary is less than average (correct)
  • To give a 10% salary raise to all instructors
  • To give a 5% salary raise to instructors who earn less than 70000
  • 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 < 70000'?

    <p>To give a 5% salary raise to instructors who earn less than 70000</p> Signup and view all the answers

    Which SQL query is used to sort the 'Students' table by FIRSTNAME, LASTNAME in descending order, and AGE in descending order?

    <p>SELECT * FROM Students ORDER BY FIRSTNAME, LASTNAME DESC, AGE DESC;</p> Signup and view all the answers

    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)

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

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

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser