SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
SQL Server Vocab
Start Test
Study First
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 long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
Upper bound
Methods
Conversation
INNER JOIN
2. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances
Heap
Distributed partitioned view
Stored procedure
Well-known binary (WKB)
3. NET Framework applications that provide specialized functionality within SQL Server PowerShell
Stemmer
Object
Cmdlets
Indexed view
4. A numeric value representing a physical location within a heap and page.
Module
INNER JOIN
Row Identifier (RID)
XML fragment
5. 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.
Identlty
JOIN
Conversation priority
Term
6. Actions an object can perform.
Methods
UNION
Nondeterministic function
Service
7. An object that is used to store a scalar value for use within a function - trigger - or stored procedure.
Partition function
Gating role
Variable
Geography data type
8. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.
Nondeterministic function
Stemmer
UNION
Correlated subquery
9. 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
Constraint
Token
DDL trigger
Atomicity
10. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.
Scalar function
XML data type
Spatial reference identifier (SRID)
Consistency
11. 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
Partition function
Geography data type
Identlty
Nondeterministic function
12. Is not well-formed; that is - it does not have a root node.
Materialized view
Variable
XML fragment
Partition function
13. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
Message type
Parameter
OGC Extended Methods
Dialog
14. Provides security to dialogs connecting to remote databases.
Clustered Index
Remote service binding
Well-known binary (WKB)
Route
15. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are
Cmdlets
Atomicity
Route
Spatial reference identifier (SRID)
16. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.
Filter daemon host process (Fdhost exe)
PartItioned view
XML
Cmdlets
17. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates
Check constraint
Object
Geography data type
Geometry data type
18. 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.
Well-known text (WKT)
Log Sequence Number (LSN)
Module
Fllestream
19. A built-in or user-defined function that provides a calculation on a set of rows or values
Message type
Event group
Aggregate function
Change tables
20. A collection of properties and methods that provide a defined functionality.
Table-valued function
Partition scheme
Well-known binary (WKB)
Object
21. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis
Queue
Partition function
Stored procedure
Cursor
22. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted
Aggregate function
INNER JOIN
Durability
Identlty
23. A set of DDL events within the DDL event hierarchy
Full-text Index
Stored procedure
Event group
Remote service binding
24. Tables within a database that store modified rows in a database with CDC enabled
Cost
Well-known text (WKT)
Geometry data type
Change tables
25. A trigger that executes in response to a DDL event
Row Identifier (RID)
DDL trigger
Thesaurus
Clustered Index
26. A virtual object that represents a group of full-text indexes
Full-text catalog
Full-Text Engine
Page
Instantiation
27. An index that contains one or more columns in a table that are used to improve query efficiency; If the table has a ______ index - the root level of the _______ index points back to the clustering key - otherwise - the root level points to a row in
Stopword
Conversation group
Nonclustered Index
Unique constraint
28. A physical structure implemented as a balanced tree that is used to speed up query operations
Index
Geometry data type
Correlated subquery
DetermInistic function
29. A hidden table where Service Broker messages are stored until they are processed.
Atomicity
Stored procedure
Queue
Index
30. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.
DML trigger
Event group
Constraint
Well-known text (WKT)
31. A reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.
Spatial reference identifier (SRID)
XML
Row Identifier (RID)
Partition function
32. A table without a clustered index; (A ____ can still have nonclustered indexes defined on it)
Heap
Term
Parameter
Upper bound
33. XML files that define synonyms for terms in a specific language.
Thesaurus
XML
Index
Row Identifier (RID)
34. Used to configure SQL Server to send and receive messages over TCP/IP connections.
Foreign key constraInt
Indexed view
Service Broker endpoint
Route
35. An object that contains significant words and their locations within the columns included in the index
DML trigger
Isolation
Cost
Full-text Index
36. A special type of __________ that has an anchor query - which is the source of the recursion - along with a UNION ALL statement and a second query - which recurses across the anchor query - and an outer query - which references the _____ and specifie
Isolation
Recursive CTE
Table-valued function
OGC Extended Methods
37. A TSQL operator that combines the result sets from multiple queries.
UNION
DetermInistic function
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Full-text catalog
38. 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
Service Broker endpoint
Full-Text Engine
Clustered Index
UNION
39. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process
Conversation
Parameter
XML
Filter daemon host process (Fdhost exe)
40. The process of adding data to a full -text index either during creation or when the full-text index is built.
Change tables
Upper bound
Page
Population (crawl)
41. A function that defines the values that divide a table or index into multiple ___________.
XML document
Partition function
Row Identifier (RID)
Dialog
42. _______ designed to work with geometry and geography data types.
Module
OGC Extended Methods
XML document
Full-text catalog
43. A role specified when enabling CDC that is used to limit access to the change data
JOIN
Gating role
Foreign key constraInt
Parameter
44. A ____ that includes only the rows that are in common in all tables referenced in the FROM clause
Geography data type
Instantiation
INNER JOIN
Contract
45. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Log Sequence Number (LSN)
Module
OUTER JOIN
Cmdlets
46. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.
User-defined function (UDF)
Primary key
Scalar function
Route
47. 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.
User-defined function (UDF)
Conversation priority
Change tables
Stopword
48. Defines on which file group each ________ defined by a _______ function should be stored.
Stemmer
Queue
Partition scheme
Conversation priority
49. The security credentials under which a code module is executed
Distributed partitioned view
Identlty
Execution context
Recursive CTE
50. A word or character string defined by a word breaker.
Token
Contract
Population (crawl)
Fllestream