Recent Lessons

Show all results for ""

Feature Overview

Ace your exams with our all-in-one platform for creating and sharing quizzes and tests.

Quizzes

Create quizzes and tests automatically from your content using AI.

Flashcards

Automatically turn your notes into digital flashcards.

Share, Export & Embed

Share with classmates or export to Excel and your learning management system.

Stats & Reporting

Auto-grading quizzes and tests with detailed stats and reports.

Mobile Apps

The smarter way to study – wherever you are.

Pricing

Search...

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 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