In this article I will show Set 01 of 10 SQL Telephone Interview questions for beginners and that should take less than 10 minutes!
SQL Telephone Interview Questions
This test covers basics of SQL and are based on SQL Server.
Is SQL Having clause before or after WHERE?
Which T-SQL function is used to return today's date and time?
When using T-SQL wildcard which symbol is used to represent any character?
What type of function is MAX Function?
Which date function would use to compare two dates?
You have 5 values that you need to find in a specified field. Which SQL operator would you use that can accept all 5 values at once?
Does UNION ALL returns UNIQUE ROWS?
You need to show customers without orders. You need to use a join to return the result. What type of join would you use?
Which SQL clause would you use to show only customers that bought something more than once?
You have SQL query that uses COUNT(ProductID) on sales tables. How would you modify it to count only unique ProductIDs?
I hope that helps