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 way to make SQL Server return a stream making up an XML document or fragment






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






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






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






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






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






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






8. Defines the name and contents of a message.






9. Provides security to dialogs connecting to remote databases.






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






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






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






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






14. A word that is commonly used and adds no meaning to a search - such as a - an - and the; _________s in SQL Server 2008 provide similar functionality to noise words in SQL Server 2005.






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






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






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






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






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






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






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






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






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






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. The name given to the group of tasks within a Service Broker solution that require messages to be sent.






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






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






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






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






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






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






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






33. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.






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






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






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






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






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






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






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






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






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






43. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates






44. A variable that is passed to a stored procedure or function.






45. A query that is embedded within - and references columns from - an outer query






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






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






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






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






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







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests