Mysql-quiz 0 votes, 0 avg 404 123456789101112131415 SQL Questions 1 / 15 1. The clause that filters JOIN results is called _________ A. WHERE B. SORT C. GROUP D. GROUP BY 2 / 15 2. 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. 3 / 15 3. 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 4 / 15 4. What default value gets stored in columns of the table? A. NULL B. 1 C. -1 D. o 5 / 15 5. A view can be deleted using the command __________ A. REMOVE B. DELETE C. CLEAR D. DROP 6 / 15 6. What is xyz in the following SQL statement? DELETE FROM xyz WHERE abc = 5; A. database name B. column name C. table name D. row name 7 / 15 7. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 8 / 15 8. Views are not updatable. A. true B. false 9 / 15 9. Full form of DCL is - A. Data Control Language B. Data Commit Language C. Data Common Language D. Data Concatenate Language 10 / 15 10. What is the keyword of the Ascending and Descending? A. ASCE, DESC B. ASC, DES C. ASCE, DES D. ASC, DESC 11 / 15 11. 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 12 / 15 12. What is the clause to delete all rows from the table? A. SQL DELETE ALL ROWS Table_Name; B. SQL DELETE ROWS Table_Name; C. DELETE FROM ALL ROWS Table_Name; D. DELETE FROM Table_Name; 13 / 15 13. What is the functionality of SQL COUNT? A. It returns the no of record of table B. It returns the no of record of database C. It returns the no of record of row D. It returns the no of record of column 14 / 15 14. Types of SQL Commands are – A. DDL B. DML C. DCL D. All of the above 15 / 15 15. What is the role of “CONSTRAINS” in defining a table in Mysql? A. Declaring primary key B. Declaring Foreign Key C. Restrictions on columns D. All of the mentioned Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By Wordpress Quiz plugin
