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. Is well formed; that is - it must have a root node.
XML document
Contract
Recursive CTE
PartItioned view
2. Tables within a database that store modified rows in a database with CDC enabled
Index
Nondeterministic function
Change tables
Stored procedure
3. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.
XML document
XML
Materialized view
User-defined function (UDF)
4. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.
Filter
Service Broker endpoint
Page
Stored procedure
5. 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.
Spatial reference identifier (SRID)
Log Sequence Number (LSN)
Token
Module
6. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.
Conversation priority
Service Broker endpoint
DML trigger
Materialized view
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
SQLCLR
Module
Isolation
Identlty
8. A deterministic view that has a unique - clustered _____ created against it
INNER JOIN
Thesaurus
Indexed view
FOR XML
9. A set of DDL events within the DDL event hierarchy
Constraint
Change tables
DML trigger
Event group
10. 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.
Materialized view
Cmdlets
DetermInistic function
JOIN
11. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.
Heap
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
XML
Isolation
12. 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
Recursive CTE
Full-text catalog
Foreign key constraInt
13. A TSQL operator that combines the result sets from multiple queries.
Full-text Index
UNION
Object
Aggregate function
14. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.
Indexed view
Thesaurus
Stemmer
Parameter
15. A ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.
XML document
OUTER JOIN
Event group
Term
16. 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
Geography data type
Page
Isolation
Parameter
17. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
Instantiation
XML document
Conversation
Parameter
18. Defines the name and contents of a message.
Fllestream
Message type
PartItioned view
Instantiation
19. A database object that is used to manage stopwords; There is a system-defined stoplist and you can also create your own stoplists.
PartItioned view
Stopword
Stoplist
Full-Text Engine
20. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted
Stopword
Module
Durability
Conversation priority
21. The process of producing a particular instance of an object based on the object's properties and methods
Instantiation
Population (crawl)
Parameter
Indexed view
22. 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.
Partition function
Dialog
Word breaker
XML data type
23. A function that returns the same value every time it is executed given the same input parameters
Object
DetermInistic function
Remote service binding
DDL trigger
24. A way to make SQL Server return a stream making up an XML document or fragment
OUTER JOIN
FOR XML
Stoplist
Cmdlets
25. 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
Conversation priority
Full-text Index
Unique constraint
Full-text catalog
26. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.
Fllestream
Upper bound
Nonclustered Index
Indexed view
27. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
Dialog
Stopword
Conversation group
Materialized view
28. A trigger that executes in response to a DML event
DML trigger
User-defined function (UDF)
Full-text catalog
Change tables
29. A query that is embedded within - but does not reference any columns from - an outer query.
User-defined function (UDF)
OUTER JOIN
Noncorrelated subquery
Token
30. A function that returns the results as a table data type.
Isolation
Distributed partitioned view
Table-valued function
XML document
31. A virtual object that represents a group of full-text indexes
Clustered Index
Full-text catalog
Distributed partitioned view
Thesaurus
32. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.
Partition scheme
Conversation
XML data type
Page
33. A numeric value assigned to each connection to SQL Server.
System process ID (SPID)
DetermInistic function
Row Identifier (RID)
Filter daemon host process (Fdhost exe)
34. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Cursor
Module
UNION
Scalar function
35. The process of adding data to a full -text index either during creation or when the full-text index is built.
Population (crawl)
XML data type
Conversation
Variable
36. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
Indexed view
Cost
Conversation group
XML fragment
37. A built-in or user-defined function that provides a calculation on a set of rows or values
Aggregate function
Page
Impersonation
Cursor
38. Used to store planar data based on Euclidean space such as points - lines - and polygons
XML data type
Geography data type
Service
Geometry data type
39. 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
Filter
Correlated subquery
Parameter
Atomicity
40. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are
Full-text catalog
Atomicity
FOR XML
PartItioned view
41. A constraint that is used to implement referential integrity between tables (or even within a single table)
Well-known text (WKT)
Foreign key constraInt
Stopword
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
42. Used to configure SQL Server to send and receive messages over TCP/IP connections.
Constraint
Filter
Durability
Service Broker endpoint
43. A function that defines the values that divide a table or index into multiple ___________.
Partition scheme
Route
FOR XML
Partition function
44. A table without a clustered index; (A ____ can still have nonclustered indexes defined on it)
Module
Isolation
System process ID (SPID)
Heap
45. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.
Conversation priority
SQLCLR
Aggregate function
Geometry data type
46. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.
Row Identifier (RID)
Route
Well-known text (WKT)
Conversation
47. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Full-text Index
PartItioned view
Variable
Scalar function
48. 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
Geometry data type
JOIN
Fllestream
Nondeterministic function
49. A hidden table where Service Broker messages are stored until they are processed.
Upper bound
Queue
Nonclustered Index
Index
50. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table
Check constraint
Clustered Index
Schema binding
Correlated subquery