SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 356 123456789101112131415 SQL Questions 1 / 15 1. How many Primary keys can have in a table? A. Only 1 B. Only 2 C. Depends on no of Columns D. Depends on DBA 2 / 15 2. Full form of DDL is – A. Data Describe Language B. Definition Data Language C. Data Definition Language D. Data Distinct Language 3 / 15 3. 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 4 / 15 4. Which Statement is used to insert the values in the table? A. INSERT INTO B. Insert C. INSERT D. None of the mentioned 5 / 15 5. Views are not updatable. A. true B. false 6 / 15 6. Which of these is also known as a virtual table? A. SCHEMA B. DATABASE C. JOIN D. VIEW 7 / 15 7. 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. 8 / 15 8. Which datatype can store unstructured data in a column? A. CHAR B. RAW C. NUMERIC D. VARCHAR 9 / 15 9. SQL Views are also known as A. Simple tables B. Virtual tables C. Complex tables D. Actual Tables 10 / 15 10. Which of the following clause cannot be optional in SQL SELECT Statement? A. WHERE B. GROUP BY C. ORDER BY D. None of the above 11 / 15 11. What is xyz in the following SQL statement? DELETE FROM xyz WHERE abc = 5; A. database name B. column name C. table name D. row name 12 / 15 12. 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 13 / 15 13. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN 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. CREATE VIEW xyz (abc) AS SELECT a FROM t; A. row name B. column name C. view D. database Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz
