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. Provides security to dialogs connecting to remote databases.
Unique constraint
Remote service binding
JOIN
Well-known text (WKT)
2. Is well formed; that is - it must have a root node.
Thesaurus
Materialized view
XML document
Table-valued function
3. 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
Unique constraint
Geography data type
Filter
Execution context
4. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.
XML fragment
Page
Consistency
Log Sequence Number (LSN)
5. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances
Primary key
Queue
Open Geospatial Consortium (OGC)
Distributed partitioned view
6. A TSQL operator that combines the result sets from multiple queries.
Thesaurus
UNION
XML
Nonclustered Index
7. A query that is embedded within - and references columns from - an outer query
Change tables
Correlated subquery
Geometry data type
Execution context
8. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.
Noncorrelated subquery
Conversation
Thesaurus
Well-known text (WKT)
9. A numeric value representing a physical location within a heap and page.
Row Identifier (RID)
Unique constraint
Execution context
Full-text Index
10. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates
Parameter
Stemmer
Recursive CTE
Geography data type
11. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
Token
Dialog
Upper bound
Atomicity
12. A ____ that includes only the rows that are in common in all tables referenced in the FROM clause
Well-known text (WKT)
INNER JOIN
Correlated subquery
Conversation priority
13. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Scalar function
Nondeterministic function
Durability
Well-known text (WKT)
14. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Materialized view
Module
Change tables
Filter
15. A constraint that is used to implement referential integrity between tables (or even within a single table)
Atomicity
XML
Foreign key constraInt
Stemmer
16. A virtual object that represents a group of full-text indexes
Full-text catalog
Heap
Cmdlets
DetermInistic function
17. A numeric value assigned to each connection to SQL Server.
Fllestream
Well-known binary (WKB)
System process ID (SPID)
Recursive CTE
18. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are
Atomicity
Full-text Index
Isolation
Execution context
19. The process of adding data to a full -text index either during creation or when the full-text index is built.
Materialized view
Atomicity
Population (crawl)
FOR XML
20. A deterministic view that has a unique - clustered _____ created against it
Nonclustered Index
XML
Impersonation
Indexed view
21. An international nonprofit organization that develops standards for geospatial and location-based services.
Open Geospatial Consortium (OGC)
Aggregate function
Geometry data type
Module
22. 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
Stoplist
Full-text catalog
Consistency
Gating role
23. A variable that is passed to a stored procedure or function.
Parameter
Word breaker
Materialized view
Remote service binding
24. A _________ that might return a different value each time it is called given the same input parameter.
Conversation priority
Row Identifier (RID)
Nondeterministic function
XML document
25. 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.
Primary key
Table-valued function
Clustered Index
Nondeterministic function
26. A query that is embedded within - but does not reference any columns from - an outer query.
Noncorrelated subquery
Well-known text (WKT)
Conversation group
Thesaurus
27. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted
Remote service binding
Conversation group
SQLCLR
Durability
28. A function that defines the values that divide a table or index into multiple ___________.
Partition function
Primary key
Index
Nonclustered Index
29. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.
Term
JOIN
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Conversation priority
30. A reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.
Gating role
Primary key
Spatial reference identifier (SRID)
Table-valued function
31. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.
Check constraint
Distributed partitioned view
Gating role
Materialized view
32. Used to store planar data based on Euclidean space such as points - lines - and polygons
Index
Geometry data type
Scalar function
Parameter
33. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process
Noncorrelated subquery
Cost
Filter daemon host process (Fdhost exe)
Nonclustered Index
34. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.
Stemmer
System process ID (SPID)
Module
FOR XML
35. 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.
SQLCLR
Noncorrelated subquery
JOIN
Gating role
36. 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
Full-text catalog
UNION
Indexed view
Full-Text Engine
37. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.
Noncorrelated subquery
Filter daemon host process (Fdhost exe)
Thesaurus
Route
38. 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
Open Geospatial Consortium (OGC)
Contract
Partition scheme
Token
39. A constraint that applies a Boolean expression to rows added or updated in tables to verify whether the update should be allowed
Consistency
Word breaker
Queue
Check constraint
40. Used to configure SQL Server to send and receive messages over TCP/IP connections.
Event group
Distributed partitioned view
Service Broker endpoint
Term
41. 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
Cost
Conversation
DetermInistic function
Function
42. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis
Conversation priority
Cost
Check constraint
Cursor
43. An option that is available for views and functions that ensures any dependent objects cannot be dropped unless the view or function is dropped first.
Schema binding
Row Identifier (RID)
Remote service binding
PartItioned view
44. A function that returns the same value every time it is executed given the same input parameters
Impersonation
Distributed partitioned view
DetermInistic function
Geometry data type
45. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.
Well-known text (WKT)
Methods
Upper bound
Row Identifier (RID)
46. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.
Log Sequence Number (LSN)
XML
Primary key
Well-known binary (WKB)
47. NET Framework applications that provide specialized functionality within SQL Server PowerShell
OUTER JOIN
Index
Cmdlets
Cost
48. 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.
Service
UNION
Stopword
Geography data type
49. The security credentials under which a code module is executed
Parameter
Execution context
Remote service binding
DetermInistic function
50. A collection of conversations that are related
Conversation group
Full-Text Engine
Log Sequence Number (LSN)
Well-known binary (WKB)