SQL Questions

0 votes, 0 avg
410

SQL Questions

1 / 15

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

2 / 15

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

3 / 15

3. In order to sort the records according to the columns, which clause is used?

4 / 15

4. Full form of DML is –

5 / 15

5. Full form of TCL is –

6 / 15

6. In which join all the rows from the left table appear in the output irrespective of the content of the other table?

7 / 15

7. What is joining a table to itself called?

8 / 15

8. SQL INSERT is used to insert a –

9 / 15

9. Full form of DDL is –

10 / 15

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

11 / 15

11. Which of the following is not Constraint in SQL?

12 / 15

12. A multiple-table delete can apply any join.

13 / 15

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

14 / 15

14. The clause that filters JOIN results is called _________

15 / 15

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

Your score is

The average score is 58%

0%

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.