SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 355 123456789101112131415 SQL Questions 1 / 15 1. A view can be deleted using the command __________ A. REMOVE B. DELETE C. CLEAR D. DROP 2 / 15 2. 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. 3 / 15 3. 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 4 / 15 4. Which of the following is not Constraint in SQL? A. Primary Key B. Not Null C. Check D. Union 5 / 15 5. What is joining a table to itself called? A. COMPLETE B. SELF C. OBSOLETE D. CROSS 6 / 15 6. 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 7 / 15 7. Which data manipulation command is used to combines the records from one or more tables? A. SELECT B. PROJECT C. JOIN D. PRODUCT 8 / 15 8. Full form of TCL is – A. Transaction Common Language B. Transaction Commit Language C. Transaction Concatenate Language D. Transaction Control Language 9 / 15 9. Which feature is used for the automatic increment of the column? A. AUTO_INCREMENT B. AUTO C. INCREMENT D. All of the mentioned 10 / 15 10. SQL DELETE can be used to delete, A. Rows B. Database C. View D. All of the above 11 / 15 11. SQL Views are also known as A. Simple tables B. Virtual tables C. Complex tables D. Actual Tables 12 / 15 12. The comma operator can also be used to join tables. A. true B. false 13 / 15 13. Will the following SQL command produce any error? INSERT INTO person (person_id, fname,lname) VALUES (1,’S’,’U’), VALUES (1,’T’,’U’); /* where person_id is a primary key */ A. Error B. No Error C. Depends D. None of the mentioned 14 / 15 14. 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 15 / 15 15. Which statement can be used for modifying the definition for an existing table? A. ALTER B. Modified C. SELECT D. FROM Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz
