Mysql-quiz 0 votes, 0 avg 384 123456789101112131415 SQL Questions 1 / 15 1. Select the correct syntax of SELECT TOP clause? A. SELECT TOP name B. SELECT TOP column C. SELECT TOP FROM D. SELECT TOP Number 2 / 15 2. 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 3 / 15 3. SQL DELETE can be used to delete, A. Rows B. Database C. View D. All of the above 4 / 15 4. UPDATE statement is a DML statement. What does DML stand for? A. Data Manipulation Language B. Data Manipulation Level C. Data Markup Language D. Data Markup Level 5 / 15 5. In inner join, result is produced by matching rows in one table with rows in another table. A. true B. false 6 / 15 6. Commands that comes under DDL is/are – A. CREATE B. DROP C. TRUNCATE D. All of the above 7 / 15 7. Which statement is TRUE about the ORDER BY Clause? A. In order to return the rows in a specific order, ORDER BY Clause is used. B. In order to group the rows, ORDER BY Clause is used. C. In order to select the defined groups, ORDER BY Clause is used. D. None of the above 8 / 15 8. Which of the following clause cannot be optional in SQL SELECT Statement? A. WHERE B. GROUP BY C. ORDER BY D. None of the above 9 / 15 9. What is generally done after the transactions are executed successfully? A. delete B. rollback C. commit D. update 10 / 15 10. The clause that filters JOIN results is called _________ A. WHERE B. SORT C. GROUP D. GROUP BY 11 / 15 11. Types of SQL Commands are – A. DDL B. DML C. DCL D. All of the above 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 one is not the OPTIONAL Clause in SELECT statement? A. WHERE B. ORDER BY C. HAVE D. HAVING 14 / 15 14. Which function combines the two different columns? A. ADD B. MERGE C. CONCAT D. None of the above 15 / 15 15. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________ A. CARTESIAN JOIN B. CROSS JOIN C. INNER JOIN D. RIGHT JOIN Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By Wordpress Quiz plugin
