Home > Databases > Quizzes > Transact-SQL (T-SQL) Practice Test
Transact-SQL (T-SQL) Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 44% • Most missed: “In T-SQL which keyword is used to sort the data in ascending order?”

Transact-SQL is Microsoft's and Sybase's proprietary extension to the SQL used to interact with relational databases. It is a procedural language that is used by the SQL Server.

Transact-SQL (T-SQL) Practice Test
Time left 00:00
25 Questions

1. Which type of index is kept in one place and table data is stored in another place?
2. Which of the following ACID properties states that upon committing a transaction, the database will change state properly?
3. Which type of indexing creates a physical sorting order of rows?
4. In Transact SQL, ____are used to save time by avoiding writing the code repeatedly.
5. Which of the following types of joins selects all the rows from the right table if there are no matches found in the left table?
6. What will be the output of the below LIKE query?
WHERE SALARY LIKE '%9000%'
7. What is T-SQL?
8. In T-SQL which keyword is used to sort the data in descending order?
9. How many types of parameters are there in the stored procedure?
10. Is enclosing the query with parenthesis important while writing the subquery inside a query?
11. Which of the following commands is used to return a name on the transaction?
12. How many types of functions are there in T-SQL?
13. Which company owns T-SQL?
14. Which of the following ACID properties ensures that every transaction is unique and every operation works transparently?
15. Which company owns PL/SQL?
16. Which of the following commands is used to save the changes in the transaction?
17. What will be the output of the below LIKE query?
WHERE SALARY LIKE '9000%'
18. Which of the following keywords is used to initiate the transaction?
19. How many types of indexes does SQL provide?
20. In T-SQL Pivot and Unpivot are the ____.
21. Which of the following ACID properties ensures that committed transactions will be properly executed if the system fails?
22. What is the full form of PL/SQL?
23. Do indexes increase the database performance?
24. Which of the following commands is used if you want to delete the table?
25. What will be the output of the below LIKE query?
WHERE SALARY LIKE '_10%8'

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs MariaDB Practice Test
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.