SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 347 123456789101112131415 SQL Questions 1 / 15 1. Command that comes under DCL is/are – A. GRANT B. REVOKE C. Both A. and B. D. None of the above 2 / 15 2. Which keyword is used to delete all the rows from the table? A. TRUNCATE B. REMOVE C. DELETE ALL D. CLEAR 3 / 15 3. Which data manipulation command is used to combines the records from one or more tables? A. SELECT B. PROJECT C. JOIN D. PRODUCT 4 / 15 4. Which statement can be used for modifying the definition for an existing table? A. ALTER B. Modified C. SELECT D. FROM 5 / 15 5. 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 6 / 15 6. Which of the following is not Constraint in SQL? A. Primary Key B. Not Null C. Check D. Union 7 / 15 7. 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 8 / 15 8. What is generally done if an error occurs during the transaction? A. delete B. rollback C. commit D. update 9 / 15 9. Which one is not the OPTIONAL Clause in SELECT statement? A. WHERE B. ORDER BY C. HAVE D. HAVING 10 / 15 10. A view can be deleted using the command __________ A. REMOVE B. DELETE C. CLEAR D. DROP 11 / 15 11. 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 12 / 15 12. The clause that filters JOIN results is called _________ A. WHERE B. SORT C. GROUP D. GROUP BY 13 / 15 13. 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 14 / 15 14. Commands that come under TCL is/are – A. COMMIT B. ROLLBACK C. SAVEPOINT D. All of the above 15 / 15 15. What is the keyword of the Ascending and Descending? A. ASCE, DESC B. ASC, DES C. ASCE, DES D. ASC, DESC Your score is The average score is 58% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Questions, Quiz
