Mysql-quiz

1. Which command is used for the table definition in Mysql?

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

3. Full form of DCL is -

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

5. What is generally done after the transactions are executed successfully?

6. Which among the following is the correct syntax for defining “Constraint Check” in Mysql?

7. Command that comes under DML is/are –

8. A view can be deleted using the command __________

9. By default, sorting by ORDER BY clause is done in which order?

10. SQL DELETE can be used to delete,

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

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

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

14. What is xyz in the following MySQL statement?CREATE VIEW xyz AS SELECT a, b FROM t;

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