Recent Lessons

Show all results for ""

Mastering Advanced Database Management Systems

Choose a study mode

Play Quiz

Study Flashcards

Spaced Repetition

Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Download our mobile app to listen on the go

Get App

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 (B)</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; (C)</p> Signup and view all the answers

Flashcards

What does 'UPDATE instructor SET salary = salary + (salary * 0.05)' do?

Used to give a 5% salary raise to all instructors.

What does 'UPDATE instructor SET salary = salary * 1.05 WHERE salary < (SELECT AVG(salary) FROM instructor)' do?

This gives a 5% salary raise to instructors whose salary is less than the average instructor salary.

What does 'UPDATE instructor SET salary = salary * 1.05 WHERE salary < 70000' do?

This gives a 5% salary raise to instructors who earn less than 70000.

How do you sort by FIRSTNAME, LASTNAME DESC, AGE DESC?

Sorts the 'Students' table by FIRSTNAME (ascending), LASTNAME (descending), and AGE (descending).

Signup and view all the flashcards

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.