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 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
Indexed view
Consistency
Queue
2. 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
Service
FOR XML
Page
Constraint
3. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances
Object
Function
Remote service binding
Distributed partitioned view
4. A collection of conversations that are related
FOR XML
Conversation group
DDL trigger
Module
5. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Module
Dialog
Parameter
Population (crawl)
6. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates
Unique constraint
Geography data type
Instantiation
Full-text catalog
7. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.
Well-known binary (WKB)
Filter daemon host process (Fdhost exe)
Spatial reference identifier (SRID)
Execution context
8. A function that returns the results as a table data type.
Atomicity
Module
DML trigger
Table-valued function
9. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.
Service
DML trigger
SQLCLR
Conversation priority
10. An object that contains significant words and their locations within the columns included in the index
Nondeterministic function
Correlated subquery
Full-text Index
Object
11. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.
XML
Atomicity
Service Broker endpoint
PartItioned view
12. A table without a clustered index; (A ____ can still have nonclustered indexes defined on it)
Durability
Conversation group
Heap
Token
13. A variable that is passed to a stored procedure or function.
Table-valued function
Gating role
Parameter
Full-Text Engine
14. NET Framework applications that provide specialized functionality within SQL Server PowerShell
Correlated subquery
Page
Cmdlets
Partition scheme
15. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
DetermInistic function
Open Geospatial Consortium (OGC)
User-defined function (UDF)
Cost
16. The word - phrase - or character string included as input in the full -text query.
JOIN
Term
Message type
Parameter
17. A _________ that might return a different value each time it is called given the same input parameter.
Schema binding
Module
Log Sequence Number (LSN)
Nondeterministic function
18. 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)
Methods
Conversation group
Geography data type
19. A virtual object that represents a group of full-text indexes
FOR XML
Full-text catalog
Service
Log Sequence Number (LSN)
20. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
JOIN
Nondeterministic function
Variable
Dialog
21. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted
Consistency
DetermInistic function
Identlty
Durability
22. A trigger that executes in response to a DDL event
User-defined function (UDF)
Identlty
Geometry data type
DDL trigger
23. A hidden table where Service Broker messages are stored until they are processed.
Queue
Message type
XML data type
Full-Text Engine
24. 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
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Unique constraint
Fllestream
Conversation
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.
Open Geospatial Consortium (OGC)
XML
Stored procedure
Cost
26. 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
Distributed partitioned view
Execution context
Full-Text Engine
Recursive CTE
27. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
System process ID (SPID)
XML fragment
Conversation
Cost
28. A ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.
OUTER JOIN
Stopword
Primary key
UNION
29. An international nonprofit organization that develops standards for geospatial and location-based services.
JOIN
DetermInistic function
Open Geospatial Consortium (OGC)
Event group
30. Sets the relative precedence for Service Broker conversations
Geography data type
Conversation priority
Nonclustered Index
SQLCLR
31. A database object that is used to manage stopwords; There is a system-defined stoplist and you can also create your own stoplists.
Well-known text (WKT)
Atomicity
Cursor
Stoplist
32. A word or character string defined by a word breaker.
Partition scheme
Upper bound
Remote service binding
Token
33. A built-in or user-defined function that provides a calculation on a set of rows or values
Event group
JOIN
Conversation priority
Aggregate function
34. A numeric value assigned to each connection to SQL Server.
Aggregate function
Distributed partitioned view
XML document
System process ID (SPID)
35. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are
Object
Contract
Unique constraint
Atomicity
36. A query that is embedded within - but does not reference any columns from - an outer query.
Service
Noncorrelated subquery
Variable
Change tables
37. A function that returns the same value every time it is executed given the same input parameters
Atomicity
Well-known binary (WKB)
DetermInistic function
Conversation
38. 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.
Durability
JOIN
XML document
Indexed view
39. A constraint that is used to implement referential integrity between tables (or even within a single table)
Remote service binding
Indexed view
Foreign key constraInt
Check constraint
40. A physical structure implemented as a balanced tree that is used to speed up query operations
Index
Stored procedure
Conversation priority
Identlty
41. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.
Foreign key constraInt
Atomicity
Materialized view
Term
42. The security credentials under which a code module is executed
Execution context
Well-known binary (WKB)
Word breaker
Conversation group
43. A TSQL operator that combines the result sets from multiple queries.
Check constraint
Change tables
UNION
Geometry data type
44. A trigger that executes in response to a DML event
Queue
DML trigger
INNER JOIN
Upper bound
45. 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
Contract
XML document
Route
Change tables
46. 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
Check constraint
Filter
Aggregate function
XML document
47. 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
Isolation
Gating role
Term
UNION
48. 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.
Unique constraint
Materialized view
Schema binding
Conversation
49. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.
PartItioned view
Isolation
XML document
Conversation
50. 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.
Identlty
Scalar function
OUTER JOIN
Log Sequence Number (LSN)