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 trigger that executes in response to a DML event
DML trigger
Foreign key constraInt
Conversation
Schema binding
2. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
Partition function
Well-known binary (WKB)
Nonclustered Index
Conversation
3. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.
Impersonation
Page
OUTER JOIN
Durability
4. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.
Well-known text (WKT)
Conversation priority
Noncorrelated subquery
PartItioned view
5. 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
Nonclustered Index
Partition scheme
XML fragment
DDL trigger
6. A TSQL operator that combines the result sets from multiple queries.
Thesaurus
OGC Extended Methods
UNION
Upper bound
7. The name given to the group of tasks within a Service Broker solution that require messages to be sent.
Service
Change tables
Indexed view
Row Identifier (RID)
8. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.
Route
Table-valued function
DetermInistic function
JOIN
9. A virtual object that represents a group of full-text indexes
Stoplist
Thesaurus
Full-text catalog
Nondeterministic function
10. A constraint that is used to implement referential integrity between tables (or even within a single table)
Full-text Index
Foreign key constraInt
Filter
DetermInistic function
11. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
Row Identifier (RID)
Nondeterministic function
Consistency
Cost
12. A way to make SQL Server return a stream making up an XML document or fragment
Stoplist
Service Broker endpoint
Materialized view
FOR XML
13. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted
Distributed partitioned view
Durability
Stored procedure
Instantiation
14. 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
Durability
Constraint
Full-Text Engine
Recursive CTE
15. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process
Identlty
Stemmer
Clustered Index
Filter daemon host process (Fdhost exe)
16. NET Framework applications that provide specialized functionality within SQL Server PowerShell
Event group
Isolation
Cmdlets
Filter
17. A hidden table where Service Broker messages are stored until they are processed.
Conversation
Change tables
PartItioned view
Queue
18. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.
XML document
Stemmer
XML fragment
Instantiation
19. 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
Cost
Token
Filter
Conversation priority
20. A query that is embedded within - and references columns from - an outer query
OGC Extended Methods
FOR XML
Correlated subquery
Dialog
21. A collection of conversations that are related
Aggregate function
Conversation group
Consistency
DDL trigger
22. Defines the name and contents of a message.
Indexed view
Message type
Term
XML
23. 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.
Word breaker
Contract
Conversation
Isolation
24. _______ designed to work with geometry and geography data types.
XML fragment
OGC Extended Methods
Nondeterministic function
User-defined function (UDF)
25. A ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.
Log Sequence Number (LSN)
OUTER JOIN
XML document
Remote service binding
26. 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
Filter daemon host process (Fdhost exe)
Consistency
Full-text catalog
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
27. A _________ that might return a different value each time it is called given the same input parameter.
Fllestream
Cursor
Nondeterministic function
Message type
28. 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.
Route
User-defined function (UDF)
Correlated subquery
SQLCLR
29. Provides security to dialogs connecting to remote databases.
Remote service binding
Parameter
Instantiation
Identlty
30. The process of producing a particular instance of an object based on the object's properties and methods
Population (crawl)
Variable
DDL trigger
Instantiation
31. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.
Schema binding
UNION
Conversation priority
Upper bound
32. Is well formed; that is - it must have a root node.
XML document
Durability
Impersonation
Nondeterministic function
33. 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
XML
XML document
Fllestream
Heap
34. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.
Full-text Index
Term
Materialized view
Full-Text Engine
35. A role specified when enabling CDC that is used to limit access to the change data
Full-text Index
Indexed view
Gating role
Filter daemon host process (Fdhost exe)
36. The word - phrase - or character string included as input in the full -text query.
Full-text Index
Term
Recursive CTE
Materialized view
37. 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
SQLCLR
Contract
Full-text Index
Check constraint
38. A physical structure implemented as a balanced tree that is used to speed up query operations
Clustered Index
Geometry data type
Methods
Index
39. Actions an object can perform.
Module
Methods
Filter
Correlated subquery
40. 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.
Event group
Cursor
Stored procedure
XML document
41. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.
Isolation
XML
Identlty
Execution context
42. A ____ that includes only the rows that are in common in all tables referenced in the FROM clause
INNER JOIN
Stored procedure
FOR XML
Token
43. A constraint that is set on one column or a combination of columns in a table that must uniquely identify a row in the table; By definition - the __________ cannot contain NULL values.
Cmdlets
Primary key
DDL trigger
Geometry data type
44. 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
Methods
OUTER JOIN
Well-known binary (WKB)
Isolation
45. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.
Conversation
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Methods
JOIN
46. An object that contains significant words and their locations within the columns included in the index
Full-text Index
Change tables
Check constraint
Filter
47. A variable that is passed to a stored procedure or function.
Consistency
Conversation group
Methods
Parameter
48. A reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.
SQLCLR
Well-known binary (WKB)
Object
Spatial reference identifier (SRID)
49. 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.
XML data type
Row Identifier (RID)
Log Sequence Number (LSN)
Population (crawl)
50. The security credentials under which a code module is executed
INNER JOIN
Recursive CTE
Execution context
Scalar function