Home > Databases > Quizzes > SQL Server Vocab
SQL Server Vocab
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 10% • Most missed: “NET Framework applications that provide specialized functionality within SQL Ser…”
SQL Server Vocab
Time left 00:00
25 Questions

1. A trigger that executes in response to a DDL event

2. Used to store planar data based on Euclidean space such as points - lines - and polygons

3. A module of code that is stored within a database that provides an API that applications can use to abstract the database structure from application code.

4. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.

5. A named SQL statement programming object that can be called in either a SELECT or FROM clause that returns a single {scalar} value or a value with a table data type - but is not allowed to modify the state of a database or the instance

6. A constraint that is used to implement referential integrity between tables (or even within a single table)

7. A function created as TSQL or as Common Language Runtime (CLR) code; TSQL ____s include scalar - multi statement table valued - and inline table-valued functions.

8. A numeric value assigned to each connection to SQL Server.

9. A collection of properties and methods that provide a defined functionality.

10. Defines on which file group each ________ defined by a _______ function should be stored.

11. The process of adding data to a full -text index either during creation or when the full-text index is built.

12. A built-in or user-defined function that provides a calculation on a set of rows or values

13. A collection of conversations that are related

14. A rule applied to a column{s} within a table that is used to validate changes and ensure that data within a table does not violate business rules

15. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis

16. A deterministic view that has a unique - clustered _____ created against it

17. A function that returns the same value every time it is executed given the same input parameters

18. Defines the name and contents of a message.

19. Sets the relative precedence for Service Broker conversations

20. XML files that define synonyms for terms in a specific language.

21. A _________ that is set on one or more columns in a table that ensures the data in each row is unique within the table for that column or combination of columns; A unique _________ allows NULL values and therefore cannot be used to uniquely identify

22. An object that is used to store a scalar value for use within a function - trigger - or stored procedure.

23. A function that returns the results as a table data type.

24. A reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.

25. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test 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.