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 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 2 / 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' 3 / 10 Which is not a Join type in SQL? Half Join Inner Join Left Join Full Join 4 / 10 Which is not a Relational DBMS in below list? SQLite Snowflake MariaDB MongoDB 5 / 10 In MySQL, which is not a valid statement to get current date & time? SELECT SYSDATETIME() SELECT CURRENT_TIMESTAMP() SELECT LOCALTIME() SELECT SYSDATE() 6 / 10 Which one is a SET operator in SQL? UNION / UNION ALL INTERSECT MINUS / EXCEPT All the above 7 / 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 8 / 10 Fill in the blanks. A ____________ subquery is a subquery that uses values from the outer query. Materialized Correlated Non correlated Temporary 9 / 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 10 / 10 Which is a correct statement about Foreign Key? Can contain Null values Can contain Duplicate values Is not mandatory All the above Your score is LinkedIn Facebook Twitter Retake quiz Exit
I'm still an SQL expert?
excellent quiz