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 deterministic view that has a unique - clustered _____ created against it






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






29. A way to make SQL Server return a stream making up an XML document or fragment






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






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. Defines on which file group each ________ defined by a _______ function should be stored.






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






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






35. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.






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






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






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






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






40. Defines the name and contents of a message.






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






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






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






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






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






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






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






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






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






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







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