SELECT for querying data.INSERT for adding data.UPDATE for modifying data.DELETE for removing data.DROP, ALTER, and CREATE are DDL (Data Definition Language) commands, not DML. Thus, the correct DML command in the options is DELETE.


On a relation named Loan of a bank: 
On a relation named Loan of a bank: 
The following SQL query is executed:
SELECT L1.loannumber FROM Loan L1 WHERE L1.amount \(>\) (SELECT MAX(L2.amount) FROM Loan L2 WHERE L2.branchname = 'SR Nagar');