Test your basic knowledge |

SQL Server Vocab

Subject : it-skills
Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.






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






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






4. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker






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






6. The security credentials under which a code module is executed






7. 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






8. A database object that is used to manage stopwords; There is a system-defined stoplist and you can also create your own stoplists.






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






10. The word - phrase - or character string included as input in the full -text query.






11. Is well formed; that is - it must have a root node.






12. 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






13. A physical structure implemented as a balanced tree that is used to speed up query operations






14. The name given to the group of tasks within a Service Broker solution that require messages to be sent.






15. A hidden table where Service Broker messages are stored until they are processed.






16. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted






17. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.






18. A constraint that is set on one column or a combination of columns in a table that must uniquely identify a row in the table; By definition - the __________ cannot contain NULL values.






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






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






21. A number assigned to entries within a transaction log to aid with recovery; lower bound Defines a starting ________ to define a valid range of rows within a change table.






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






23. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery






24. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process






25. The process by which a user assumes the security credentials of another user






26. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.






27. A function that defines the values that divide a table or index into multiple ___________.






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






29. _______ designed to work with geometry and geography data types.






30. A process that finds word boundaries (tokenizes words) based on the linguistic rules for the data language specified; You can specify the language of the data in the column when creating a full-text index on a table.






31. 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.






32. 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.






33. During a transaction (before it is committed or rolled back) the data must remain in an isolated state and not be accessible to other transactions; In SQL Server - the isolation level can be controlled for each transaction






34. A word or character string defined by a word breaker.






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






36. A trigger that executes in response to a DML event






37. NET Framework applications that provide specialized functionality within SQL Server PowerShell






38. 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






39. One column per table can be defined as its identity; The __________ property automatically generates a new increased or decreased number for the column when rows are inserted into the table






40. Is not well-formed; that is - it does not have a root node.






41. An agreement between two services that defines the message types the services send to accomplish certain tasks- It also defines what participants can send which message types






42. A query that is embedded within - but does not reference any columns from - an outer query.






43. The process of producing a particular instance of an object based on the object's properties and methods






44. A TSQL operator that combines multiple related tables to define the result set; The _______ syntax defines a column or columns which are common between the tables that are used to correlate the data.






45. A part of the SQL Server process that manages full-text administrative tasks - handles full-text query execution - and manages the filter daemon host process






46. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.






47. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.






48. A component that processes a document to extract the textual information from documents stored in a varbinary(max) or image column and then sends that information to the word breaker






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






50. An object that contains significant words and their locations within the columns included in the index