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 service that starts Fdhost:exe processes when the Full-Text Engine requires them.






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






3. Used to configure SQL Server to send and receive messages over TCP/IP connections.






4. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table






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






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






7. Actions an object can perform.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






44. A TSQL operator that combines the result sets from multiple queries.






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






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






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






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






49. Defines the name and contents of a message.






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







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