SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 5 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. In order to insert a row directly in the table, which command is used? A. INSERT IN B. INSERT INSIDE C. INSERT UNDER D. INSERT INTO 3 / 15 3. Which of the following is not a valid aggregate function? A. COUNT B. COMPUTE C. SUM D. MAX 4 / 15 4. Commands that comes under DDL is/are – A. CREATE B. DROP C. TRUNCATE D. All of the above 5 / 15 5. The join where all possible row combinations are produced is called _________ A. INNER JOIN B. OUTER C. NATURAL D. CARTESIAN 6 / 15 6. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional? A. select_list B. table_list C. row_constraint D. grouping_columns 7 / 15 7. What is x in the following MySQL statement? DELETE FROM x USING x LEFT JOIN y ON x.col = y.col; A. column name B. table name C. server name D. database name 8 / 15 8. 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 9 / 15 9. In order to delete the database, which keyword is used? A. DROP B. DELETE C. ALTER D. None of the above 10 / 15 10. Which data manipulation command is used to combines the records from one or more tables? A. SELECT B. PROJECT C. JOIN D. PRODUCT 11 / 15 11. Full form of DCL is – A. Data Control Language B. Data Commit Language C. Data Common Language D. Data Concatenate Language 12 / 15 12. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 13 / 15 13. Which keyword is used to delete all the rows from the table? A. TRUNCATE B. REMOVE C. DELETE ALL D. CLEAR 14 / 15 14. Which of these is also known as a virtual table? A. SCHEMA B. DATABASE C. JOIN D. VIEW 15 / 15 15. What is joining a table to itself called? A. COMPLETE B. SELF C. OBSOLETE D. CROSS Your score is The average score is 50% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Questions, Quiz
