SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 384 123456789101112131415 SQL Questions 1 / 15 1. The comma operator can also be used to join tables. A. true B. false 2 / 15 2. 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 3 / 15 3. In the following SQL query, what does “person” stands for? INSERT INTO person (person_id, fname, lname) VALUES (1,’S’,’P’); A. Composite attributes B. Multivalued attributes C. Table name D. None of the mentioned 4 / 15 4. Command that comes under DML is/are – A. ROLLBACK B. GRANT C. UPDATE D. All of the above 5 / 15 5. CREATE VIEW xyz (abc) AS SELECT a FROM t; A. row name B. column name C. view D. database 6 / 15 6. Full form of DML is – A. Data Multiplication Language B. Data Manipulation Language C. Data Modify Language D. Data Mapping Language 7 / 15 7. 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 8 / 15 8. Full form of DCL is – A. Data Control Language B. Data Commit Language C. Data Common Language D. Data Concatenate Language 9 / 15 9. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN 10 / 15 10. 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. 11 / 15 11. By default, sorting by ORDER BY clause is done in which order? A. Ascending B. Descending 12 / 15 12. In inner join, result is produced by matching rows in one table with rows in another table. A. true B. false 13 / 15 13. 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 14 / 15 14. 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 15 / 15 15. 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. Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz