Mysql-quiz

1. Full form of DML is –

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

3. What operator tests column for absence of data

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

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

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

7. What is the keyword of the Ascending and Descending?

8. Full form of DDL is –

9. A view can be deleted using the command __________

10. Views are not updatable.

11. Which of these is also known as a virtual table?

12. Select the correct syntax of SELECT TOP clause?

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

14. Which Statement is used to insert the values in the table?

15. A view can refer to multiple tables via __________