SQL Questions

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

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

3. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?

4. Which keyword is used to delete all the rows from the table?

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

6. Command that comes under DML is/are –

7. Views are not updatable.

8. Which of the following clause cannot be optional in SQL SELECT Statement?

9. In order to delete the database, which keyword is used?

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

11. A view can refer to multiple tables via __________

12. Commands that comes under DDL is/are –

13. Full form of DDL is –

14. What is joining a table to itself called?

15. Which keyword in the UPDATE statement is used to assign values to columns?