SQL QUIZ 1 min read /10 SQL Quiz SQL quiz helps us to increase our knowledge 1 / 10 Identify the correct SQL statement. SELECT name, sal FROM Tab SELECT name & sal FROM Tab SELECT name and sal FROM Tab None 2 / 10 Choose the command to delete all records and clear logs from table ? DELETE TRUNCATE DROP CLEAR 3 / 10 The SQL command used to add new rows to a table is: INSERT ADD UPDATE MODIFY 4 / 10 Which of the following are TCL commands? SELECT and INSERT COMMIT and ROLLBACK GRANT and REVOKE UPDATE and TRUNCATE 5 / 10 What type of database is Microsoft SQL Server? Relational database Network database NoSQL Database Hierarchical database 6 / 10 Which of the following is not a valid aggregate function? COUNT SUM MAX COMPUTE 7 / 10 In SQL, what does the term “NULL” represent? A missing or unknown value An empty string zero Placeholder for future 8 / 10 In SQL, the primary key is used to: 𝐏𝐞𝐫𝐟𝐨𝐫𝐦 𝐦𝐚𝐭𝐡𝐞𝐦𝐚𝐭𝐢𝐜𝐚𝐥 𝐜𝐚𝐥𝐜𝐮𝐥𝐚𝐭𝐢𝐨𝐧𝐬 𝐄𝐧𝐬𝐮𝐫𝐞 𝐝𝐚𝐭𝐚 𝐢𝐧𝐭𝐞𝐠𝐫𝐢𝐭𝐲 𝐚𝐧𝐝 𝐮𝐧𝐢𝐪𝐮𝐞𝐧𝐞𝐬𝐬 𝐢𝐧 𝐚 𝐭𝐚𝐛𝐥𝐞 𝐑𝐞𝐭𝐫𝐢𝐞𝐯𝐞 𝐝𝐚𝐭𝐚 𝐟𝐫𝐨𝐦 𝐦𝐮𝐥𝐭𝐢𝐩𝐥𝐞 𝐭𝐚𝐛𝐥𝐞𝐬 𝐃𝐞𝐟𝐢𝐧𝐞 𝐭𝐡𝐞 𝐝𝐚𝐭𝐚 𝐭𝐲𝐩𝐞 𝐨𝐟 𝐚 𝐜𝐨𝐥𝐮𝐦𝐧 9 / 10 Which SQL clause is used to combine rows from two or more tables based on a related column? MERGE GROUP BY UNION JOIN 10 / 10 Guess the output of below SQL syntax. Select 5 + NULL NULL 0 5 6 Your score is 0% Restart quiz