SQL Questions

0 votes, 0 avg
5

SQL Questions

1 / 15

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

2 / 15

2. In order to insert a row directly in the table, which command is used?

3 / 15

3. Which of the following is not a valid aggregate function?

4 / 15

4. Commands that comes under DDL is/are –

5 / 15

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

6 / 15

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

7 / 15

7. What is x in the following MySQL statement? DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

8 / 15

8. How many Primary keys can have in a table?

9 / 15

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

10 / 15

10. Which data manipulation command is used to combines the records from one or more tables?

11 / 15

11. Full form of DCL is –

12 / 15

12. CROSS JOIN and JOIN are similar to __________

13 / 15

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

14 / 15

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

15 / 15

15. What is joining a table to itself called?

Your score is

The average score is 50%

0%