SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 399 123456789101112131415 SQL Questions 1 / 15 1. What is the difference between HAVING and WHERE clause? A. HAVING clause is used in column operation whereas WHERE clause is used in row operation. B. HAVING clause is post-filter whereas WHERE clause is pre-filter. C. HAVING clause filters the groups whereas WHERE clauses filter the single record of the table. D. All of the above 2 / 15 2. Which of the following is not Constraint in SQL? A. Primary Key B. Not Null C. Check D. Union 3 / 15 3. How many Primary keys can have in a table? A. Only 1 B. Only 2 C. Depends on no of Columns D. Depends on DBA 4 / 15 4. In order to sort the records according to the columns, which clause is used? A. HAVING B. GROUP BY C. ORDER BY D. None of the above 5 / 15 5. Is it necessary to insert the value in each column of the table? A. Yes B. No C. Depends on the server D. Depends on the usage of the table 6 / 15 6. Which data manipulation command is used to combines the records from one or more tables? A. SELECT B. PROJECT C. JOIN D. PRODUCT 7 / 15 7. Which of the following is not a valid aggregate function? A. COUNT B. COMPUTE C. SUM D. MAX 8 / 15 8. What default value gets stored in columns of the table? A. NULL B. 1 C. -1 D. o 9 / 15 9. Command that comes under DML is/are – A. ROLLBACK B. GRANT C. UPDATE D. All of the above 10 / 15 10. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 11 / 15 11. By default, sorting by ORDER BY clause is done in which order? A. Ascending B. Descending 12 / 15 12. Which keyword in the UPDATE statement is used to assign values to columns? A. ASSIGN B. SET C. MARK D. GET 13 / 15 13. What is joining a table to itself called? A. COMPLETE B. SELF C. OBSOLETE D. CROSS 14 / 15 14. Select the correct statement. A. With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration. B. With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration. C. With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration. D. With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration. 15 / 15 15. What operator tests column for absence of data A. NOT Operator B. Exists Operator C. IS NULL Operator D. None of the above Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz
