MySQL Database Management System

Play an AI-generated podcast conversation about this lesson

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 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 Signup and view all the answers

What is the effect of the command DELETE FROM EMPLOYEE;

Deletes all rows from the EMPLOYEE table Signup and view all the answers

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

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

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

DROP TABLE EMPLOYEE; 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 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' Signup and view all the answers

MySQL Database Management System

Podcast Beta

Questions and Answers

What is the purpose of the UPDATE command in SQL?

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

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

What is the purpose of the DELETE command in SQL?

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

What is the effect of the command DELETE FROM EMPLOYEE;

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

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

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

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

More Quizzes Like This

Mastering MySQL

MySQL Quiz: Test Your Skills with SQL Questions

Inserting Data into MySQL Database with Python

Diferencias entre SQL y MySQL - Prueba tus conocimientos con este quiz

Upgrade to continue