Mysql-quiz 0 votes, 0 avg 89 123456789101112131415 SQL Questions 1 / 15 1. Which keyword is used to delete all the rows from the table? A. TRUNCATE B. REMOVE C. DELETE ALL D. CLEAR 2 / 15 2. 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 3 / 15 3. What is the keyword of the Ascending and Descending? A. ASCE, DESC B. ASC, DES C. ASCE, DES D. ASC, DESC 4 / 15 4. What default value gets stored in columns of the table? A. NULL B. 1 C. -1 D. o 5 / 15 5. Which data manipulation command is used to combines the records from one or more tables? A. SELECT B. PROJECT C. JOIN D. PRODUCT 6 / 15 6. Which statement is TRUE about the WHERE Clause? A. In order to retrieve rows, WHERE Clause is used. B. In order to group the rows, WHERE Clause is used. C. In order to select the defined groups, WHERE Clause is used. D. In order to return the rows, WHERE Clause is used. 7 / 15 7. 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 8 / 15 8. SQL Views are also known as A. Simple tables B. Virtual tables C. Complex tables D. Actual Tables 9 / 15 9. 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 10 / 15 10. 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 11 / 15 11. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN 12 / 15 12. Which statement is TRUE about the GROUP BY Clause? A. In order to retrieve rows, GROUP BY Clause is used. B. In order to group the rows that share the same property, GROUP BY Clause is used. C. In order to select the defined groups, GROUP BY Clause is used. D. In order to return the rows, GROUP BY Clause is used. 13 / 15 13. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 14 / 15 14. 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 15 / 15 15. 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 Your score is The average score is 54% LinkedIn Facebook Twitter VKontakte 0% Restart quiz