SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 405 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. A view can refer to multiple tables via __________ A. UNION B. JOIN C. GROUP D. SELECT 3 / 15 3. 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 4 / 15 4. 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 5 / 15 5. . A View can be used to select a subset of the table columns. A. true B. false 6 / 15 6. Views are not updatable. A. true B. false 7 / 15 7. What is generally done after the transactions are executed successfully? A. delete B. rollback C. commit D. update 8 / 15 8. Which of the following is not Constraint in SQL? A. Primary Key B. Not Null C. Check D. Union 9 / 15 9. What is xyz in the following MySQL statement?CREATE VIEW xyz AS SELECT a, b FROM t; A. table B. column C. view D. database 10 / 15 10. In SQL SELECT COUNT, one needs to specify the – A. Column Name B. Row Name C. Table Name D. None of the above 11 / 15 11. Which keyword in the UPDATE statement is used to assign values to columns? A. ASSIGN B. SET C. MARK D. GET 12 / 15 12. Which command is used for the table definition in Mysql? A. DESC table_name; B. DESC table_name C. DESC D. None of the mentioned 13 / 15 13. Command that comes under DML is/are – A. ROLLBACK B. GRANT C. UPDATE D. All of the above 14 / 15 14. Which among the following are the correct definitions for “NULL” in Mysql? A. Absence of value B. Unknown C. Empty set D. All of the mentioned 15 / 15 15. The clause that filters JOIN results is called _________ A. WHERE B. SORT C. GROUP D. GROUP BY Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz
