SQL MCQ Questions and answers – 02 Posted on June 16, 2020June 16, 2020 by admin 0 Created on June 16, 2020 By admin SQL MCQ Questions and answers - 02 1 / 10 1. Which SQL keyword is used to retrieve only unique values? A. DISTINCTIVE B. UNIQUE C. DISTINCT D. DIFFERENT 2 / 10 2. Which SQL keyword is used to retrieve a maximum value? A. TOP B. MOST C. UPPER D. MAX 3 / 10 3. What is a view? A. A view is a special stored procedure executed when certain event occurs. B. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. C. A view is a database diagram. D. None of these 4 / 10 4. Which of the following SQL commands is used to retrieve data? A. DELETE B. INSERT C. SELECT D. JOIN 5 / 10 5. Which of the following is a SQL aggregate function? A. LEFT B. AVG C. JOIN D. LEN 6 / 10 6. Which SQL statement is used to update data in a database? A. SAVE B. UPDATE C. SAVE AS D. MODIFY 7 / 10 7. Which SQL statement is used to delete data FROM a database? A. COLLAPSE B. REMOVE C. ALTER D. DELETE 8 / 10 8. Which SQL keyword is used to sort the result-set? A. SORT BY B. ORDER C. ORDER BY D. SORT 9 / 10 9. The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; A. 6789 B. 2345 C. 1234 D. 456789 10 / 10 10. Which of the following group functions ignore NULL values? A. MAX B. COUNT C. SUM D. All of the above Your score is The average score is 0% LinkedIn Facebook Twitter 0% Restart quiz