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. 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
Message type
Identlty
Module
Row Identifier (RID)
2. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates
Unique constraint
SQLCLR
Geography data type
JOIN
3. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.
Service
Conversation group
Well-known text (WKT)
JOIN
4. 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
Stemmer
Service Broker endpoint
Identlty
Full-Text Engine
5. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
Distributed partitioned view
XML fragment
Cost
Atomicity
6. A function that defines the values that divide a table or index into multiple ___________.
Consistency
Nondeterministic function
Partition function
Instantiation
7. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process
Correlated subquery
Nonclustered Index
Recursive CTE
Filter daemon host process (Fdhost exe)
8. A ____ that includes only the rows that are in common in all tables referenced in the FROM clause
Materialized view
Variable
INNER JOIN
JOIN
9. Actions an object can perform.
Cmdlets
Row Identifier (RID)
Schema binding
Methods
10. A function that returns the results as a table data type.
Recursive CTE
Identlty
Table-valued function
Index
11. 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.
JOIN
Noncorrelated subquery
Log Sequence Number (LSN)
OUTER JOIN
12. 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.
Upper bound
Stopword
Row Identifier (RID)
JOIN
13. 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.
Correlated subquery
XML fragment
Primary key
Contract
14. A variable that is passed to a stored procedure or function.
Parameter
Instantiation
SQLCLR
DetermInistic function
15. A constraint that is used to implement referential integrity between tables (or even within a single table)
Message type
Partition function
Nondeterministic function
Foreign key constraInt
16. A physical structure implemented as a balanced tree that is used to speed up query operations
INNER JOIN
Index
Filter daemon host process (Fdhost exe)
Noncorrelated subquery
17. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis
Full-text catalog
Distributed partitioned view
Cmdlets
Cursor
18. A reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.
Spatial reference identifier (SRID)
Check constraint
Unique constraint
Atomicity
19. An international nonprofit organization that develops standards for geospatial and location-based services.
Open Geospatial Consortium (OGC)
Aggregate function
DDL trigger
Conversation
20. A table without a clustered index; (A ____ can still have nonclustered indexes defined on it)
Cmdlets
Partition scheme
Heap
Distributed partitioned view
21. A ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.
Conversation group
Stored procedure
OUTER JOIN
Contract
22. _______ designed to work with geometry and geography data types.
Word breaker
Distributed partitioned view
Open Geospatial Consortium (OGC)
OGC Extended Methods
23. The name given to the group of tasks within a Service Broker solution that require messages to be sent.
Service
Cmdlets
Full-text Index
Thesaurus
24. Sets the relative precedence for Service Broker conversations
Conversation priority
Distributed partitioned view
Module
Unique constraint
25. A query that is embedded within - but does not reference any columns from - an outer query.
Module
Geography data type
Noncorrelated subquery
OGC Extended Methods
26. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.
Cost
Identlty
Constraint
XML
27. Defines the name and contents of a message.
Term
Message type
Foreign key constraInt
Function
28. A numeric value assigned to each connection to SQL Server.
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Module
System process ID (SPID)
XML
29. 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
Cmdlets
Change tables
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
30. A built-in or user-defined function that provides a calculation on a set of rows or values
Identlty
Unique constraint
Spatial reference identifier (SRID)
Aggregate function
31. A virtual object that represents a group of full-text indexes
XML
Full-text catalog
Event group
Materialized view
32. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.
OUTER JOIN
Upper bound
DDL trigger
User-defined function (UDF)
33. A database object that is used to manage stopwords; There is a system-defined stoplist and you can also create your own stoplists.
DetermInistic function
Stoplist
Nondeterministic function
Well-known text (WKT)
34. An object that contains significant words and their locations within the columns included in the index
XML fragment
Conversation priority
Spatial reference identifier (SRID)
Full-text Index
35. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.
Partition function
Full-text catalog
SQLCLR
Log Sequence Number (LSN)
36. Used to configure SQL Server to send and receive messages over TCP/IP connections.
Impersonation
Materialized view
Service Broker endpoint
XML
37. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
Conversation
Filter
Recursive CTE
Variable
38. The security credentials under which a code module is executed
Noncorrelated subquery
Cmdlets
SQLCLR
Execution context
39. Provides security to dialogs connecting to remote databases.
Heap
Remote service binding
Variable
Stoplist
40. The process by which a user assumes the security credentials of another user
Schema binding
Impersonation
System process ID (SPID)
Message type
41. A hidden table where Service Broker messages are stored until they are processed.
Log Sequence Number (LSN)
Stored procedure
XML
Queue
42. Tables within a database that store modified rows in a database with CDC enabled
Change tables
Nondeterministic function
Conversation
Thesaurus
43. The process of adding data to a full -text index either during creation or when the full-text index is built.
Parameter
Stopword
Population (crawl)
DetermInistic function
44. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are
Event group
Atomicity
Primary key
PartItioned view
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
Function
Token
Fllestream
Contract
46. A collection of conversations that are related
User-defined function (UDF)
Conversation group
XML fragment
Index
47. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Distributed partitioned view
Aggregate function
Isolation
48. 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.
Primary key
Word breaker
Remote service binding
Consistency
49. A function that returns the same value every time it is executed given the same input parameters
DDL trigger
Object
DetermInistic function
Full-text catalog
50. Is well formed; that is - it must have a root node.
Index
Heap
Conversation
XML document