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. At the end of a transaction - either a new and valid form of the data exists or the data is returned to its original state- Returning data to its original state is part of the rollback functionality provided by SOL






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






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






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






5. Provides security to dialogs connecting to remote databases.






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






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






8. An international nonprofit organization that develops standards for geospatial and location-based services.






9. A constraint that applies a Boolean expression to rows added or updated in tables to verify whether the update should be allowed






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






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






12. A property that can be applied to the varbinary(max) data type and that makes the actual data reside in a directory structure in the file system instead of inside the database's data file or files






13. A _________ that might return a different value each time it is called given the same input parameter.






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






15. A numeric value representing a physical location within a heap and page.






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






17. Tables within a database that store modified rows in a database with CDC enabled






18. A role specified when enabling CDC that is used to limit access to the change data






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






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






21. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume






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






23. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.






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






25. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are






26. A virtual object that represents a group of full-text indexes






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






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






29. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.






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






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






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






33. Actions an object can perform.






34. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.






35. A ____ that includes only the rows that are in common in all tables referenced in the FROM clause






36. A table without a clustered index; (A ____ can still have nonclustered indexes defined on it)






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






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






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






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






41. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.






42. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.






43. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.






44. A ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.






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






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






47. Defines the name and contents of a message.






48. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.






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






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