Employee Management System Quiz

What SQL keyword is used to add new rows to a table in the Employee Management System?

• MODIFY

• ADD

• CREATE

• INSERT

What is the purpose of the 'DepartmentID' column in the Employee Management System?

• To store the employee's phone number.

• To identify each employee uniquely within the system.

• To specify the department to which the employee belongs.

• To store the employee's salary.

Which SQL statement is used to change the datatype of a column in a table?

• MODIFYCOLUMN

• ALTERCOLUMN

• CHANGECOLUMN

• UPDATECOLUMN

What SQL command is used to remove a table from the database?

• DELETETABLE

• REMOVETABLE

• DROPTABLE

• REMOVEFROM

What is the purpose of the 'Salary' column in the Employee Management System?

• To store the employee's job title.

• To identify each employee uniquely within the system.

• To store the employee's monthly income.

• To determine the employee's working hours.

An employee needs to update their address details. What SQL statement is appropriate for this operation?

• MODIFYTABLE

• ALTERTABLE

• UPDATETABLE

• CHANGETABLE

In the Employee Management System, what does the 'Position' column typically represent?

• The employee's address.

• The employee's job title or role.

• The employee's date of birth.

• The employee's department.

Which SQL command is used to delete all rows from a table in the Employee Management System?

• REMOVE

• DELETE ALL

• TRUNCATE

• DROP

An HR manager wants to view the total number of employees in each department. What SQL clause is suitable for this query?

• ORDER BY

• GROUP BY

• HAVING

• DISTINCT

An HR manager wants to see a list of employees who joined the company after January 1st, 2020. Which SQL clause should be used?

• WHERE

• GROUP BY

• HAVING

• ORDER BY