MCQ Bank
Which of the following SQL command will be used to delete a record of an employee named ALI form emp table?
- A) Insert
- B) Update
- C) Delete
- D) Truncate
Which of the following command will be used if you want to permanently save the changes made in database?
- A) Savepoint
- B) Rollback
- C) Commit
- D) Store
Which of the following SQL command will be used to change the salary of a particular Employee from 20000 to 25000 in EMPLOYEE table? (Salary is an attribute of EMPLOYEE table.)
- A) Commit
- B) Edit
- C) Insert
- D) Update
The Rollback statement is the transactional command used to save changes invoked by a transaction to the database.
- A) False
- B) True
- C)
- D)
______________ statement deletes the table but the structure remains un-deleted.
- A) Truncate
- B) Terminate
- C) Remove
- D) Drop
Insert, update and delete are the ______________ commands.
- A) DML
- B) DCL
- C) DLL
- D) DDL
_______________ command is used to restore the changes made in the database.
- A) Commit
- B) Truncate
- C) Delete
- D) Rollback