SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 367 123456789101112131415 SQL Questions 1 / 15 1. 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 2 / 15 2. Types of SQL Commands are – A. DDL B. DML C. DCL D. All of the above 3 / 15 3. 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. 4 / 15 4. Which among the following is the correct syntax for defining “Constraint Check” in Mysql? A. gender char(1) check( gender IN (‘M’, ‘F’)), B. gender char (1) check, C. gender char (1) check ( gender ), D. none of the mentioned 5 / 15 5. 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 6 / 15 6. What is generally done if an error occurs during the transaction? A. delete B. rollback C. commit D. update 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. 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. Which Statement is used to insert the values in the table? A. INSERT INTO B. Insert C. INSERT D. None of the mentioned 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. What is the meaning of “REFERENCES” in table definition? A. Primary key B. NULL C. Foreign Key D. A ”foreign Key” belong to this particular table 12 / 15 12. 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 13 / 15 13. What cannot be done on a view? A. display B. filter C. index D. drop 14 / 15 14. 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 15 / 15 15. In which join all the rows from the left table appear in the output irrespective of the content of the other table? A. RIGHT JOIN B. LEFT JOIN C. INNER JOIN D. OUTER JOIN Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz
