General Transact-SQL (T-SQL) MCQs

1. Which answer is NOT a type of table index?

2. The keywords AND, IN, LIKE, and between all belong to a category called what?

3. What is an example of a DDL command in SQL?

4. You need to write a query that returns all Employees that have a LastName starting with the letter A. Which WHERE clause should you use to fill in the blank in this query?

5. Which query shows the first name, department, and team of all students with the two lowest points?

6. What is the result of this statement?

7. Which is the best approach to update the last name of the student Donette Figgins to Smith

8. Which of these data types is an approximate numeric?

9. You need to remove all data from a table name Products. Which query fully logs the removal of each record?

10. What is the result of this query? SELECT 1 / 2 AS Result;

11. Which data type will most efficiently store a person's age in years?

12. What is the result of this query? SELECT 'abc\ def' AS Result;

13. To select a random student from the table, which statement could you use?

14. Which statement creates a new database schema named Sales and establish Sharon as the owner?

15. The result of a CROSS JOIN between a table with 4 rows, and one with 5 rows, will give with _ rows.

16. You need to write a query that returns all products that have a SerialNumber ending with "10_3". Which WHERE clause should you use to fill in the blank in this query?SELECT ProductID, ProductName, SerialNumber FROM Products______ ;

17. When no join type between multiple tables in a query's FROM clause is specified, what type of join is assumed?

18. How many bytes of storage does the int data type consume?

19. What does a RIGHT JOIN ensure?

20. Given a table with the following structure, which query returns all student names with the highest grade? CREATE TABLE Students (StudentName varchar(50),Grade int );

21. What is the result of an INNER JOIN between table1 and table2?

22. To remove all of the content from the Students table but keep the schema, which statement should you use?

23. You would like to have a record added to a TableB every time a record is modified in TableA. What technique should you look at implementing?

24. What is the result of this query? SELECT 123+'123' AS Result;

25. To combine the results of two or more SELECT statements, removing duplicates, which keyword can you use?

26. Your database currently has a table called Inventory in the Warehouse schema. You need to move the table to the Products schema. Which query accomplishes this goal?

27. You need to create a simple database backup in the server's Z:\Backups directory. Which query should you use?

28. Though not currently a requirement, what will a future release of SQL Server require of all SQL statements?Though not currently a requirement, what will a future release of SQL Server require of all SQL statements?

29. Which is the best approach to update the last name and email address of a student with ID 56295?