DBMS QUIZ

Which command is used to remove a specific record from a table in SQL?

• DELETE

• UPDATE

• INSERT

• SELECT

Which command undo all the updates performed by the SQL in the transaction?

• ROLLBACK

• COMMIT

• TRUNCATE

• DELETE

The FROM SQL clause is used to …

• specify what table we are selecting or deleting data FROM

• specify range for search condition

• specify search condition

• None of these

What SQL query is used to retrieve the average age of employees?

• SELECT AVG(Age) FROM Employees

• SELECT AVERAGE(Age) FROM Employees

• SELECT SUM(Age)/COUNT(*) FROM Employees

• SELECT AGE(AVG) FROM Employees

What do you mean by one-to-many relationships?

• One class may have many teachers

• One teacher can have many classes

• Many classes may have many teachers

• Many teachers may have many classes

A sample database table named "Employees" with columns "ID," "Name," "Age," and "Department" is created with some data inserted. What SQL query is used to retrieve all columns from the Employees table?

• SELECT * FROM Employees;

• SELECT Name, Age, Department FROM Employees;

• SELECT ID, Name, Age, Department FROM Employees;

• SELECT Employees;

Identify the error in "ALTER TABLE Students DROP COLUMN DateOfBirth date;"

• ALTER TABLE

• DROP COLUMN

• DateOfBirth

• date

How do you delete the employee with ID 5 from the Employees table?

• DELETE FROM Employees WHERE ID = 5;

• DELETE * FROM Employees WHERE ID = 5;

• REMOVE FROM Employees WHERE ID = 5;

• DROP FROM Employees WHERE ID = 5;

In "ALTER TABLE Students ADD COLUMN Email varchar(50), what is missing for this statement to be correct?

• ADD COLUMN

• Email

• varchar(50)

• All Correct

In the following Query, which of the following can be placed in the Query's blank portion to display the salary from highest to lowest amount, and sorting the employs name alphabetically?

• Ascending, Descending

• Asc, Desc

• Desc, Asc

• All of the above