1. What cannot be done on a view?

2. Commands that come under TCL is/are –

3. Which statement is TRUE about the ORDER BY Clause?

4. What is the difference between HAVING and WHERE clause?

5. Types of SQL Commands are –

6. Full form of TCL is –

7. . A View can be used to select a subset of the table columns.

8. Which statement can be used for modifying the definition for an existing table?

9. The comma operator can also be used to join tables.

10. In inner join, result is produced by matching rows in one table with rows in another table.

11. What is the meaning of “REFERENCES” in table definition?

12. Which function combines the two different columns?

13. Command that comes under DCL is/are –

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

15. CREATE VIEW xyz (abc) AS SELECT a FROM t;