SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 383 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. What default value gets stored in columns of the table? A. NULL B. 1 C. -1 D. o 3 / 15 3. Which of these is also known as a virtual table? A. SCHEMA B. DATABASE C. JOIN D. VIEW 4 / 15 4. Command that comes under DCL is/are – A. GRANT B. REVOKE C. Both A. and B. D. None of the above 5 / 15 5. SQL DELETE can be used to delete, A. Rows B. Database C. View D. All of the above 6 / 15 6. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN 7 / 15 7. Select the correct syntax of SELECT TOP clause? A. SELECT TOP name B. SELECT TOP column C. SELECT TOP FROM D. SELECT TOP Number 8 / 15 8. 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 9 / 15 9. 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; 10 / 15 10. Commands that come under TCL is/are – A. COMMIT B. ROLLBACK C. SAVEPOINT D. All of the above 11 / 15 11. Select the correct statement. A. With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration. B. With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration. C. With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration. D. With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration. 12 / 15 12. 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 13 / 15 13. 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 14 / 15 14. In SQL SELECT COUNT, one needs to specify the – A. Column Name B. Row Name C. Table Name D. None of the above 15 / 15 15. UPDATE statement is a DML statement. What does DML stand for? A. Data Manipulation Language B. Data Manipulation Level C. Data Markup Language D. Data Markup Level Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz
