SQL Quiz 3 Posted on September 10, 2023April 2, 2024 by Vijay A. Verma SQL Quiz 3 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 What is a collection of database objects called? Index View Schema Trigger 2 / 10 In Database terminology, what is CRUD? Create, Read, Unique, Delete Create, Read, Update, Delete Constraint, Row, Unique, Data Common, Row, Union, Data 3 / 10 In MYSQL which is not a valid integer data type? INT INTEGER SMALLINT LARGEINT 4 / 10 What will you use to concat in MySQL? || & CONCAT + 5 / 10 Which constraint will you use to limit the values within a range in a column? FOREIGN KEY CHECK DEFAULT BETWEEN 6 / 10 Which is not a good recommendation to optimize SELECT SQL queries? Column names in SELECT, not * WHERE not HAVING, if possible Create Index on needed columns Always use SELECT DISTINCT 7 / 10 Which is one of the best ways to improve the performance of your SELECT query? Index Trigger Stored Procedure Function 8 / 10 To delete an index which command should be used? DELETE INDEX ALTER INDEX DROP INDEX REMOVE INDEX 9 / 10 Which is not a Windows function in SQL? BIN RANK LAG ROW_NUMBER 10 / 10 What will you use to select all names finishing with alphabet m in below query? SELECT * FROM persons WHERE name LIKE 'm%' LIKE 'm?' LIKE '?m' LIKE '%m' Your score is LinkedIn Facebook Twitter Retake quiz Exit
