1. What is generally done if an error occurs during the transaction?

2. Command that comes under DML is/are –

3. UPDATE statement is a DML statement. What does DML stand for?

4. Which datatype can store unstructured data in a column?

5. Full form of DML is –

6. The join where all possible row combinations are produced is called _________

7. Which clause is used to retrieve a unique element from the table?

8. Which among the following is the correct syntax for modifying the definition of an existing table?

9. SQL DELETE can be used to delete,

10. Full form of TCL is –

11. Which operator is used to compare a value to a specified list of values?

12. In the following SQL query, what does “person” stands for? INSERT INTO person
(person_id, fname, lname)
VALUES (1,’S’,’P’);

13. What is x in the following MySQL statement? DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

14. In SQL SELECT COUNT, one needs to specify the –

15. Which one is not the OPTIONAL Clause in SELECT statement?