SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 112 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 inner join, result is produced by matching rows in one table with rows in another table. A. true B. false 3 / 15 3. A view can refer to multiple tables via __________ A. UNION B. JOIN C. GROUP D. SELECT 4 / 15 4. The join where all possible row combinations are produced is called _________ A. INNER JOIN B. OUTER C. NATURAL D. CARTESIAN 5 / 15 5. 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 6 / 15 6. Which keyword is used to delete all the rows from the table? A. TRUNCATE B. REMOVE C. DELETE ALL D. CLEAR 7 / 15 7. What is generally done if an error occurs during the transaction? A. delete B. rollback C. commit D. update 8 / 15 8. Which feature is used for the automatic increment of the column? A. AUTO_INCREMENT B. AUTO C. INCREMENT D. All of the mentioned 9 / 15 9. Full form of DDL is – A. Data Describe Language B. Definition Data Language C. Data Definition Language D. Data Distinct Language 10 / 15 10. Which of the following is not a valid aggregate function? A. COUNT B. COMPUTE C. SUM D. MAX 11 / 15 11. 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 12 / 15 12. Which among the following is the correct syntax for modifying the definition of an existing table? A. ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT; B. ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT; C. ALTER TABLE person MODIFY person_id ; D. ALTER TABLE person 13 / 15 13. What is generally done after the transactions are executed successfully? A. delete B. rollback C. commit D. update 14 / 15 14. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN 15 / 15 15. The comma operator can also be used to join tables. A. true B. false Your score is The average score is 52% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Questions, Quiz