SQL Quiz 1 Posted on November 30, 2022December 9, 2022 by Vijay A. Verma SQL Quiz 1 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 Which is a correct statement about Foreign Key? Can contain Null values Can contain Duplicate values Is not mandatory All the above 2 / 10 Complete the below query to fetch all records from emptbl having id in range of 3 and 5 where id is of INT data type? SELECT * from emptbl WHERE id IN (3,4,5) WHERE id BETWEEN 3 AND 5 WHERE id>=3 AND id<=5 All the above 3 / 10 Which is the correct SQL order of execution? SELECT-FROM-WHERE- GROUP BY-ORDER BY-HAVING ORDER BY-GROUP BY-HAVING GROUP BY-HAVING-ORDER BY ORDER BY-HAVING-GROUP BY 4 / 10 Which is not a Join type in SQL? Half Join Inner Join Left Join Full Join 5 / 10 Fill in the blanks. A ____________ subquery is a subquery that uses values from the outer query. Materialized Correlated Non correlated Temporary 6 / 10 In MySQL, which is not a valid statement to get current date & time? SELECT SYSDATETIME() SELECT CURRENT_TIMESTAMP() SELECT LOCALTIME() SELECT SYSDATE() 7 / 10 Which one is a SET operator in SQL? UNION / UNION ALL INTERSECT MINUS / EXCEPT All the above 8 / 10 Which is not a Relational DBMS in below list? SQLite Snowflake MariaDB MongoDB 9 / 10 Complete the SQL statement to select employee names which end with t SELECT * from emp WHERE empname NOT LIKE '^%t LIKE 't%' LIKE '%t' LIKE '_t' 10 / 10 How will you delete a column named c from table named t? ALTER TABLE t DROP COLUMN c DROP COLUMN c FROM TABLE t ALTER TABLE t DELETE COLUMN c DELETE COLUMN c FROM TABLE t Your score is LinkedIn Facebook Twitter Retake quiz Exit
I'm still an SQL expert?
excellent quiz