Recent Lessons

Show all results for ""

10 Questions

1 Views

MySQL Database Management System

Choose a study mode

Play Quiz

Study Flashcards

Spaced Repetition

Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the purpose of the UPDATE command in SQL?

To drop a table from the database
To create a new table in the database
To modify existing data in a table (correct)
To delete specific rows from a table

What is the syntax of the UPDATE command to change the salary of an employee to 55000 where the employee code is 1009?

UPDATE EMPLOYEE SET ECODE = 1009 WHERE GROSS = 55000;
UPDATE EMPLOYEE SET ECODE = 55000 WHERE GROSS = 1009;
UPDATE EMPLOYEE SET GROSS = 1009 WHERE ECODE = 55000;
UPDATE EMPLOYEE SET GROSS = 55000 WHERE ECODE = 1009; (correct)

What is the effect of the command UPDATE EMPLOYEE SET GROSS = GROSS + 1000;

Deletes the salary of each employee
Sets the salary of each employee to 1000
Decreases the salary of each employee by 1000
Increases the salary of each employee by 1000 (correct)

What is the purpose of the DELETE command in SQL?

To delete specific rows from a table (C) Signup and view all the answers

What is the effect of the command DELETE FROM EMPLOYEE WHERE GRADE = 'A1';

Deletes only the rows where the grade is 'A1' from the EMPLOYEE table (A) Signup and view all the answers

What is the effect of the command DELETE FROM EMPLOYEE;

Deletes all rows from the EMPLOYEE table (C) Signup and view all the answers

What is the purpose of the DROP TABLE command in SQL?

To drop a table from the database (D) Signup and view all the answers

What is the syntax of the DROP TABLE command to drop the EMPLOYEE table?

DROP TABLE EMPLOYEE; (A) Signup and view all the answers

What is the effect of the command UPDATE EMPLOYEE SET GROSS = 58000, GRADE='B2' WHERE ECODE = 1009;

Updates the salary to 58000 and grade to 'B2' for the employee with code 1009 (B) Signup and view all the answers

What is the effect of the command UPDATE EMPLOYEE SET GROSS = GROSS * 2 WHERE GRADE='A1' OR GRADE='A2';

Doubles the salary of employees with grade 'A1' or 'A2' (D) Signup and view all the answers