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. 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
Aggregate function
Consistency
System process ID (SPID)
Service Broker endpoint
2. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Log Sequence Number (LSN)
Foreign key constraInt
JOIN
Module
3. The process by which a user assumes the security credentials of another user
PartItioned view
Conversation priority
Partition function
Impersonation
4. _______ designed to work with geometry and geography data types.
Contract
Geometry data type
Atomicity
OGC Extended Methods
5. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.
Well-known text (WKT)
Cmdlets
Table-valued function
Spatial reference identifier (SRID)
6. A role specified when enabling CDC that is used to limit access to the change data
Message type
Nonclustered Index
Identlty
Gating role
7. 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.
DetermInistic function
Word breaker
Instantiation
Execution context
8. 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.
Methods
Geometry data type
Open Geospatial Consortium (OGC)
Primary key
9. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Cmdlets
Stemmer
Scalar function
FOR XML
10. A function that defines the values that divide a table or index into multiple ___________.
OUTER JOIN
Partition function
Cursor
Noncorrelated subquery
11. 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
JOIN
Primary key
Atomicity
Fllestream
12. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.
OGC Extended Methods
Thesaurus
XML
Execution context
13. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
Conversation
Word breaker
Stopword
Service
14. 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
Spatial reference identifier (SRID)
Geometry data type
Constraint
Word breaker
15. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table
Table-valued function
Clustered Index
Primary key
Population (crawl)
16. A constraint that applies a Boolean expression to rows added or updated in tables to verify whether the update should be allowed
Check constraint
System process ID (SPID)
Conversation priority
Function
17. Provides security to dialogs connecting to remote databases.
Geometry data type
Distributed partitioned view
FOR XML
Remote service binding
18. A trigger that executes in response to a DML event
DML trigger
Conversation priority
Service
Spatial reference identifier (SRID)
19. 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.
Change tables
Cmdlets
Methods
Schema binding
20. Tables within a database that store modified rows in a database with CDC enabled
Cursor
Cmdlets
Change tables
Full-text Index
21. The word - phrase - or character string included as input in the full -text query.
Unique constraint
Nonclustered Index
Instantiation
Term
22. Used to configure SQL Server to send and receive messages over TCP/IP connections.
Open Geospatial Consortium (OGC)
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Service Broker endpoint
Geometry data type
23. A hidden table where Service Broker messages are stored until they are processed.
XML fragment
Service Broker endpoint
Instantiation
Queue
24. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.
Parameter
Aggregate function
Well-known text (WKT)
SQLCLR
25. An object that is used to store a scalar value for use within a function - trigger - or stored procedure.
Correlated subquery
XML fragment
Spatial reference identifier (SRID)
Variable
26. Sets the relative precedence for Service Broker conversations
XML document
JOIN
Spatial reference identifier (SRID)
Conversation priority
27. A named SQL statement programming object that can be called in either a SELECT or FROM clause that returns a single {scalar} value or a value with a table data type - but is not allowed to modify the state of a database or the instance
Cursor
Function
Clustered Index
Heap
28. A virtual object that represents a group of full-text indexes
Durability
Module
Full-text catalog
DDL trigger
29. Is well formed; that is - it must have a root node.
Spatial reference identifier (SRID)
XML document
Row Identifier (RID)
Population (crawl)
30. NET Framework applications that provide specialized functionality within SQL Server PowerShell
Full-Text Engine
INNER JOIN
Durability
Cmdlets
31. A set of DDL events within the DDL event hierarchy
Cursor
Event group
Index
OGC Extended Methods
32. A variable that is passed to a stored procedure or function.
Instantiation
Parameter
Primary key
Cost
33. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances
Distributed partitioned view
JOIN
Durability
Execution context
34. XML files that define synonyms for terms in a specific language.
Function
Thesaurus
Execution context
Open Geospatial Consortium (OGC)
35. A built-in or user-defined function that provides a calculation on a set of rows or values
Distributed partitioned view
Aggregate function
Message type
DML trigger
36. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.
Gating role
Row Identifier (RID)
Filter
Well-known binary (WKB)
37. 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
Gating role
Primary key
Identlty
Execution context
38. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates
PartItioned view
OUTER JOIN
Open Geospatial Consortium (OGC)
Geography data type
39. A numeric value representing a physical location within a heap and page.
Row Identifier (RID)
Upper bound
Instantiation
Atomicity
40. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.
Materialized view
Variable
Stemmer
Schema binding
41. A deterministic view that has a unique - clustered _____ created against it
Consistency
Indexed view
Token
Dialog
42. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.
Queue
Full-text catalog
PartItioned view
Correlated subquery
43. A numeric value assigned to each connection to SQL Server.
System process ID (SPID)
OUTER JOIN
XML
Variable
44. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
Geography data type
Dialog
Identlty
XML document
45. 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
Stoplist
Conversation group
Methods
Full-Text Engine
46. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.
Function
XML fragment
Conversation group
Stemmer
47. The process of producing a particular instance of an object based on the object's properties and methods
Identlty
Instantiation
Aggregate function
Geography data type
48. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.
XML data type
OUTER JOIN
Row Identifier (RID)
Nonclustered Index
49. A collection of conversations that are related
Geography data type
Conversation group
Thesaurus
Atomicity
50. Defines on which file group each ________ defined by a _______ function should be stored.
Parameter
Open Geospatial Consortium (OGC)
System process ID (SPID)
Partition scheme