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 table without a clustered index; (A ____ can still have nonclustered indexes defined on it)
OUTER JOIN
Conversation priority
Heap
Module
2. The security credentials under which a code module is executed
XML data type
Execution context
Foreign key constraInt
SQLCLR
3. A reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.
Dialog
Spatial reference identifier (SRID)
Conversation
OGC Extended Methods
4. A hidden table where Service Broker messages are stored until they are processed.
Full-text catalog
Queue
Instantiation
XML fragment
5. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
Dialog
Nonclustered Index
Noncorrelated subquery
Remote service binding
6. A function that defines the values that divide a table or index into multiple ___________.
Spatial reference identifier (SRID)
Partition function
Stored procedure
Dialog
7. 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
Gating role
Fllestream
Parameter
Upper bound
8. XML files that define synonyms for terms in a specific language.
Thesaurus
Queue
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Index
9. A function that returns the results as a table data type.
Full-text Index
Table-valued function
Aggregate function
PartItioned view
10. A way to make SQL Server return a stream making up an XML document or fragment
DetermInistic function
Impersonation
FOR XML
Constraint
11. The process by which a user assumes the security credentials of another user
OUTER JOIN
Queue
Impersonation
Log Sequence Number (LSN)
12. An object that is used to store a scalar value for use within a function - trigger - or stored procedure.
Filter
Service Broker endpoint
Partition function
Variable
13. Used to store planar data based on Euclidean space such as points - lines - and polygons
Instantiation
Geometry data type
Word breaker
INNER JOIN
14. 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
System process ID (SPID)
Unique constraint
XML document
15. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates
Geography data type
Partition function
Remote service binding
Cmdlets
16. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.
Conversation
Well-known binary (WKB)
OGC Extended Methods
XML fragment
17. The word - phrase - or character string included as input in the full -text query.
Stored procedure
Token
Partition function
Term
18. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.
Stemmer
Well-known text (WKT)
Module
Service
19. 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.
XML document
Recursive CTE
Stopword
DDL trigger
20. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Gating role
Scalar function
Filter daemon host process (Fdhost exe)
Event group
21. NET Framework applications that provide specialized functionality within SQL Server PowerShell
Impersonation
Consistency
Cmdlets
Stored procedure
22. 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
Heap
Noncorrelated subquery
Module
23. 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
Primary key
Full-text Index
Consistency
PartItioned view
24. 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
Service
JOIN
Filter
XML
25. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
Change tables
Check constraint
Cost
Well-known binary (WKB)
26. 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
DDL trigger
Contract
Durability
Log Sequence Number (LSN)
27. A numeric value representing a physical location within a heap and page.
PartItioned view
JOIN
Row Identifier (RID)
Contract
28. A deterministic view that has a unique - clustered _____ created against it
Indexed view
Row Identifier (RID)
OUTER JOIN
Fllestream
29. A constraint that is used to implement referential integrity between tables (or even within a single table)
Stoplist
Nondeterministic function
Foreign key constraInt
Noncorrelated subquery
30. 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.
Change tables
Check constraint
Partition function
Schema binding
31. 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
PartItioned view
Partition function
Page
Recursive CTE
32. A set of DDL events within the DDL event hierarchy
XML
Route
Noncorrelated subquery
Event group
33. A virtual object that represents a group of full-text indexes
Page
UNION
Spatial reference identifier (SRID)
Full-text catalog
34. 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
Conversation priority
Function
SQLCLR
OUTER JOIN
35. A query that is embedded within - and references columns from - an outer query
Durability
System process ID (SPID)
Correlated subquery
User-defined function (UDF)
36. The process of producing a particular instance of an object based on the object's properties and methods
Queue
Index
Instantiation
Partition function
37. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process
Filter daemon host process (Fdhost exe)
Primary key
OGC Extended Methods
Conversation priority
38. A ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.
Stoplist
OUTER JOIN
Clustered Index
Variable
39. Actions an object can perform.
Contract
Conversation group
Methods
Nonclustered Index
40. 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
Unique constraint
Index
Correlated subquery
Message type
41. A variable that is passed to a stored procedure or function.
Filter daemon host process (Fdhost exe)
Parameter
Row Identifier (RID)
XML
42. An international nonprofit organization that develops standards for geospatial and location-based services.
Open Geospatial Consortium (OGC)
Nonclustered Index
Correlated subquery
DetermInistic function
43. A collection of properties and methods that provide a defined functionality.
Object
XML fragment
Indexed view
Durability
44. A ____ that includes only the rows that are in common in all tables referenced in the FROM clause
Module
FOR XML
Distributed partitioned view
INNER JOIN
45. 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.
Token
XML
Stored procedure
XML fragment
46. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis
Page
XML document
Methods
Cursor
47. Sets the relative precedence for Service Broker conversations
XML document
Fllestream
SQLCLR
Conversation priority
48. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.
Unique constraint
OUTER JOIN
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
XML data type
49. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.
Page
Change tables
XML data type
Row Identifier (RID)
50. Used to configure SQL Server to send and receive messages over TCP/IP connections.
Nonclustered Index
Service Broker endpoint
Queue
Index