SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 27 123456789101112131415 SQL Questions 1 / 15 1. 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 2 / 15 2. Which Statement is used to insert the values in the table? A. INSERT INTO B. Insert C. INSERT D. None of the mentioned 3 / 15 3. 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 4 / 15 4. 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 5 / 15 5. Views are not updatable. A. true B. false 6 / 15 6. SQL Views are also known as A. Simple tables B. Virtual tables C. Complex tables D. Actual Tables 7 / 15 7. CREATE VIEW xyz (abc) AS SELECT a FROM t; A. row name B. column name C. view D. database 8 / 15 8. Which one is not the OPTIONAL Clause in SELECT statement? A. WHERE B. ORDER BY C. HAVE D. HAVING 9 / 15 9. 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 10 / 15 10. Which of the following is not a valid aggregate function? A. COUNT B. COMPUTE C. SUM D. MAX 11 / 15 11. 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 12 / 15 12. A view can be deleted using the command __________ A. REMOVE B. DELETE C. CLEAR D. DROP 13 / 15 13. What cannot be done on a view? A. display B. filter C. index D. drop 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. What is the meaning of “REFERENCES” in table definition? A. Primary key B. NULL C. Foreign Key D. A ”foreign Key” belong to this particular table Your score is The average score is 46% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Questions, Quiz