SQL Quiz 2 Posted on April 30, 2023August 18, 2023 by Vijay A. Verma SQL Quiz 2 This is a general quiz to test your SQL knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly. Please fill in your Name & Email to take the Quiz (Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass) 1 / 10 In MySQL what can you use to comment your code? \\ -- ** '' 2 / 10 Which one is not a Window function in SQL? DENSE_RANK ROWNUMBER LAG NTILE 3 / 10 What is the command to rename a table? ALTER TABLE RENAME TABLE CHANGE TABLE None of the above 4 / 10 What is out of place here in context of SQL? CTE DDL DCL DML 5 / 10 Which is not an Aggregate function in SQL? ROUND SUM COUNT MAX 6 / 10 What is not supported by SQL Server? Concatenation Regular Expressions CASE statements Constants 7 / 10 Which is not an SQL function? CAST LEFT CONVERT TODAY 8 / 10 Table A contains 12 rows and Table B contains 5 rows. A join creates 60 rows. Which type of join is this? Natural Join Inner Join Cross Join Self Join 9 / 10 MySQL table has 2 columns- name, gender with ENUM('M','F') What record will be inserted? INSERT INTO emp VALUES('Lisa', 'Z') Query will not run 'Lisa', NULL 'Lisa', 'F' NULL, NULL 10 / 10 Which operator is used to test for the existence of any record in a subquery? FROM EXISTS MINUS INTERSECT Your score is LinkedIn Facebook Twitter Retake quiz Exit
