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 set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Module
DDL trigger
Word breaker
Identlty
2. A hidden table where Service Broker messages are stored until they are processed.
Queue
DetermInistic function
XML data type
Service Broker endpoint
3. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
Materialized view
User-defined function (UDF)
Population (crawl)
Cost
4. 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
Log Sequence Number (LSN)
Recursive CTE
Remote service binding
Fllestream
5. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
Full-text catalog
Full-text Index
Conversation group
Conversation
6. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Geometry data type
Scalar function
OUTER JOIN
Stoplist
7. 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
Conversation
Scalar function
Identlty
Gating role
8. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Heap
Conversation
Filter daemon host process (Fdhost exe)
9. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis
Upper bound
Conversation
Cursor
Well-known binary (WKB)
10. A numeric value representing a physical location within a heap and page.
PartItioned view
XML fragment
Filter
Row Identifier (RID)
11. 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
Variable
Well-known binary (WKB)
Identlty
12. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process
Service
Fllestream
Filter daemon host process (Fdhost exe)
Partition scheme
13. A database object that is used to manage stopwords; There is a system-defined stoplist and you can also create your own stoplists.
Heap
Stoplist
Durability
Unique constraint
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
Remote service binding
Table-valued function
Full-Text Engine
Identlty
15. The word - phrase - or character string included as input in the full -text query.
XML data type
Term
OUTER JOIN
Materialized view
16. Is well formed; that is - it must have a root node.
Clustered Index
Full-text Index
XML document
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
17. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.
Aggregate function
Open Geospatial Consortium (OGC)
Page
Constraint
18. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted
Spatial reference identifier (SRID)
Durability
Materialized view
Module
19. An international nonprofit organization that develops standards for geospatial and location-based services.
Message type
Object
XML
Open Geospatial Consortium (OGC)
20. The process of adding data to a full -text index either during creation or when the full-text index is built.
Well-known binary (WKB)
Population (crawl)
Noncorrelated subquery
Durability
21. The name given to the group of tasks within a Service Broker solution that require messages to be sent.
PartItioned view
Route
Service
Constraint
22. 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
Distributed partitioned view
Contract
DetermInistic function
FOR XML
23. A variable that is passed to a stored procedure or function.
Stemmer
Identlty
Parameter
Partition function
24. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.
Primary key
Table-valued function
Well-known text (WKT)
UNION
25. Provides security to dialogs connecting to remote databases.
Module
Object
Change tables
Remote service binding
26. A set of DDL events within the DDL event hierarchy
OUTER JOIN
Identlty
DetermInistic function
Event group
27. A virtual object that represents a group of full-text indexes
Conversation
Function
Full-text catalog
Correlated subquery
28. A physical structure implemented as a balanced tree that is used to speed up query operations
Dialog
Event group
XML fragment
Index
29. 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
Contract
Message type
Isolation
XML fragment
30. A _________ that might return a different value each time it is called given the same input parameter.
Well-known binary (WKB)
Nondeterministic function
Open Geospatial Consortium (OGC)
Event group
31. A trigger that executes in response to a DDL event
Scalar function
Aggregate function
Stopword
DDL trigger
32. 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.
Instantiation
XML data type
Indexed view
JOIN
33. Is not well-formed; that is - it does not have a root node.
XML fragment
Clustered Index
Noncorrelated subquery
Stoplist
34. 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.
Unique constraint
Nondeterministic function
Parameter
Word breaker
35. A constraint that applies a Boolean expression to rows added or updated in tables to verify whether the update should be allowed
Check constraint
Dialog
Route
Primary key
36. NET Framework applications that provide specialized functionality within SQL Server PowerShell
Partition scheme
Stopword
Cmdlets
FOR XML
37. 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
Event group
Nonclustered Index
Foreign key constraInt
Row Identifier (RID)
38. A function that returns the results as a table data type.
Table-valued function
Service Broker endpoint
Impersonation
Population (crawl)
39. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
Fllestream
Gating role
Dialog
Stopword
40. A constraint that is used to implement referential integrity between tables (or even within a single table)
DDL trigger
Methods
Fllestream
Foreign key constraInt
41. Used to store planar data based on Euclidean space such as points - lines - and polygons
Open Geospatial Consortium (OGC)
Geometry data type
Page
Filter
42. 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
Indexed view
Cost
Schema binding
43. Sets the relative precedence for Service Broker conversations
Conversation priority
Filter daemon host process (Fdhost exe)
Foreign key constraInt
Identlty
44. A word or character string defined by a word breaker.
Isolation
XML
Constraint
Token
45. A TSQL operator that combines the result sets from multiple queries.
UNION
Methods
Function
Durability
46. A table without a clustered index; (A ____ can still have nonclustered indexes defined on it)
Stoplist
Heap
System process ID (SPID)
Scalar function
47. A ____ that includes only the rows that are in common in all tables referenced in the FROM clause
Recursive CTE
Message type
INNER JOIN
Cursor
48. A function that returns the same value every time it is executed given the same input parameters
System process ID (SPID)
DetermInistic function
Queue
Well-known binary (WKB)
49. A collection of conversations that are related
Clustered Index
Conversation group
INNER JOIN
Scalar function
50. A reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.
OUTER JOIN
Unique constraint
Spatial reference identifier (SRID)
Full-text catalog