Basic MySQL Query Questions

The SQL command to change the position of an employee with id_employee = 4 to 'Supervisor' is:

• MODIFY employee SET position = 'Supervisor' WHERE id_employee = 4;

• CHANGE employee SET position = 'Supervisor' WHERE id_employee = 4;

• UPDATE employee SET position = 'Supervisor' WHERE id_employee = 4;

• ALTER employee SET position = 'Supervisor' WHERE id_employee = 4;

How to increase the salary of all employees by 10%?

• UPDATE employee SET salary = salary + (salary * 0.1);

• MODIFY employee SET salary = salary + 10%;

• ALTER employee SET salary = salary * 1.1;

• CHANGE employee SET salary = salary + 0.1;

The command to update the department to 'HRD' for employees who have a salary greater than 7 million is:

• UPDATE employee SET department = 'HRD' WHERE salary > 7000000;

• MODIFY employee SET department = 'HRD' WHERE salary > 7000000;

• CHANGE employee SET department = 'HRD' WHERE salary > 7000000;

• ALTER employee SET department = 'HRD' WHERE salary > 7000000;

The SQL command to delete an employee with id_employee = 3 is:

• REMOVE FROM employee WHERE id_employee = 3;

• DELETE FROM employee WHERE id_employee = 3;

• DROP employee WHERE id_employee = 3;

• CLEAR FROM employee WHERE id_employee = 3;

How to delete all employees who have a salary less than 4 million?

• DELETE FROM employee WHERE salary < 4000000;

• REMOVE FROM employee WHERE salary < 4000000;

• DROP FROM employee WHERE salary < 4000000;

• CLEAR FROM employee WHERE salary < 4000000;

The SQL command to delete the entire employee table from the database is:

• DELETE TABLE employee;

• DROP TABLE employee;

• REMOVE TABLE employee;

• CLEAR TABLE employee;

What happens if we run DROP TABLE employee?

• Deletes all data in the table but the table structure remains.

• Deletes the entire table along with its structure from the database.

• Deletes only some columns from the table.

• Deletes a temporary table, but it can be restored with ROLLBACK.

The command to add an email column to the employee table is:

• ADD COLUMN email TO employee;

• ALTER TABLE employee ADD COLUMN email VARCHAR(50);

• MODIFY employee ADD COLUMN email VARCHAR(50);

• CHANGE employee ADD COLUMN email VARCHAR(50);

The command to change the data type of the salary column to DECIMAL(10,2) is:

• ALTER TABLE employee MODIFY salary DECIMAL(10,2);

• CHANGE employee SET salary DECIMAL(10,2);

• UPDATE employee SET salary DECIMAL(10,2);

• MODIFY employee SET salary DECIMAL(10,2);

How to delete the position column from the employee table?

• ALTER TABLE employee DROP COLUMN position;

• DELETE COLUMN position FROM employee;

• REMOVE COLUMN position FROM employee;

• MODIFY TABLE employee DELETE position;