Mysql-quiz 0 votes, 0 avg 133 123456789101112131415 SQL Questions 1 / 15 1. Types of SQL Commands are – A. DDL B. DML C. DCL D. All of the above 2 / 15 2. Which of the following is not a valid aggregate function? A. COUNT B. COMPUTE C. SUM D. MAX 3 / 15 3. 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 4 / 15 4. 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 5 / 15 5. SQL Views are also known as A. Simple tables B. Virtual tables C. Complex tables D. Actual Tables 6 / 15 6. The join where all possible row combinations are produced is called _________ A. INNER JOIN B. OUTER C. NATURAL D. CARTESIAN 7 / 15 7. In inner join, result is produced by matching rows in one table with rows in another table. A. true B. false 8 / 15 8. Which clause is used to retrieve a unique element from the table? A. SELECT B. SELECT DISTINCT C. Both A) and B) D. None of the above 9 / 15 9. SQL INSERT is used to insert a – A. Single or Multiple record B. Single or Multiple database C. Single or Multiple table D. None of the above 10 / 15 10. 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 11 / 15 11. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 12 / 15 12. Select the correct syntax of SELECT TOP clause? A. SELECT TOP name B. SELECT TOP column C. SELECT TOP FROM D. SELECT TOP Number 13 / 15 13. Which one is not the OPTIONAL Clause in SELECT statement? A. WHERE B. ORDER BY C. HAVE D. HAVING 14 / 15 14. By default, sorting by ORDER BY clause is done in which order? A. Ascending B. Descending 15 / 15 15. Commands that come under TCL is/are - A. COMMIT B. ROLLBACK C. SAVEPOINT D. All of the above Your score is The average score is 54% LinkedIn Facebook Twitter VKontakte 0% Restart quiz
