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. _______ designed to work with geometry and geography data types.
OGC Extended Methods
Durability
Table-valued function
UNION
2. A physical structure implemented as a balanced tree that is used to speed up query operations
Route
Scalar function
Index
Consistency
3. An international nonprofit organization that develops standards for geospatial and location-based services.
Object
Open Geospatial Consortium (OGC)
System process ID (SPID)
Token
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
Module
Contract
Constraint
Indexed view
5. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
Stopword
Thesaurus
Nonclustered Index
Dialog
6. A collection of conversations that are related
Conversation group
Event group
Conversation
SQLCLR
7. A table without a clustered index; (A ____ can still have nonclustered indexes defined on it)
Filter daemon host process (Fdhost exe)
Isolation
Heap
Methods
8. 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
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Consistency
Methods
Materialized view
9. The word - phrase - or character string included as input in the full -text query.
Methods
Term
Thesaurus
Stoplist
10. A built-in or user-defined function that provides a calculation on a set of rows or values
Change tables
XML fragment
Aggregate function
Table-valued function
11. A TSQL operator that combines the result sets from multiple queries.
UNION
PartItioned view
Row Identifier (RID)
Indexed view
12. A constraint that is used to implement referential integrity between tables (or even within a single table)
Unique constraint
FOR XML
Foreign key constraInt
JOIN
13. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
Constraint
Methods
Cost
Remote service binding
14. A trigger that executes in response to a DML event
DML trigger
Scalar function
OUTER JOIN
Index
15. A numeric value representing a physical location within a heap and page.
Variable
Aggregate function
Row Identifier (RID)
Recursive CTE
16. Defines the name and contents of a message.
Queue
Message type
Cmdlets
User-defined function (UDF)
17. A ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.
Nondeterministic function
OUTER JOIN
Cost
Open Geospatial Consortium (OGC)
18. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table
Open Geospatial Consortium (OGC)
XML document
Variable
Clustered Index
19. 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.
Correlated subquery
Distributed partitioned view
Log Sequence Number (LSN)
Filter
20. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Cmdlets
PartItioned view
Scalar function
Event group
21. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.
UNION
Route
Change tables
Open Geospatial Consortium (OGC)
22. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.
Unique constraint
Row Identifier (RID)
Noncorrelated subquery
Upper bound
23. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Stopword
Module
Function
OGC Extended Methods
24. A database object that is used to manage stopwords; There is a system-defined stoplist and you can also create your own stoplists.
XML fragment
Filter
Stoplist
Partition function
25. 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.
Stored procedure
Cmdlets
Check constraint
Well-known text (WKT)
26. 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
Impersonation
Remote service binding
Isolation
27. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted
Event group
Durability
Identlty
Geography data type
28. 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
Fllestream
Function
Execution context
Geometry data type
29. The process of adding data to a full -text index either during creation or when the full-text index is built.
Event group
Population (crawl)
Log Sequence Number (LSN)
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
30. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
OGC Extended Methods
Aggregate function
Contract
31. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.
XML data type
Materialized view
Module
PartItioned view
32. A collection of properties and methods that provide a defined functionality.
Log Sequence Number (LSN)
Function
Object
Full-text catalog
33. The process of producing a particular instance of an object based on the object's properties and methods
Instantiation
Row Identifier (RID)
Well-known binary (WKB)
Unique constraint
34. A query that is embedded within - and references columns from - an outer query
System process ID (SPID)
Event group
Correlated subquery
Row Identifier (RID)
35. 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.
Function
Execution context
Schema binding
SQLCLR
36. Is not well-formed; that is - it does not have a root node.
Partition scheme
Dialog
XML fragment
Geography data type
37. A deterministic view that has a unique - clustered _____ created against it
Function
Route
Dialog
Indexed view
38. The name given to the group of tasks within a Service Broker solution that require messages to be sent.
Isolation
Service
Execution context
Message type
39. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis
Nondeterministic function
Cursor
Term
Function
40. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
Service Broker endpoint
Row Identifier (RID)
Conversation
Term
41. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances
Distributed partitioned view
Constraint
Remote service binding
Materialized view
42. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates
Noncorrelated subquery
Parameter
Indexed view
Geography data type
43. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.
Well-known text (WKT)
Index
Geography data type
Function
44. Used to store planar data based on Euclidean space such as points - lines - and polygons
Well-known text (WKT)
Conversation
Geometry data type
Row Identifier (RID)
45. A function that returns the results as a table data type.
Table-valued function
JOIN
Geography data type
Conversation group
46. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.
Object
Well-known binary (WKB)
UNION
SQLCLR
47. A variable that is passed to a stored procedure or function.
Parameter
Impersonation
Word breaker
Route
48. 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
Recursive CTE
Geography data type
Word breaker
Indexed view
49. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.
Durability
Parameter
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
PartItioned view
50. Provides security to dialogs connecting to remote databases.
Remote service binding
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Geography data type
Index