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 variable that is passed to a stored procedure or function.
Parameter
Correlated subquery
Conversation priority
Stored procedure
2. 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.
JOIN
Methods
Geography data type
Aggregate function
3. NET Framework applications that provide specialized functionality within SQL Server PowerShell
Atomicity
XML document
Cmdlets
Dialog
4. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table
Partition function
Noncorrelated subquery
XML document
Clustered Index
5. Actions an object can perform.
Methods
Full-Text Engine
Aggregate function
Index
6. A query that is embedded within - but does not reference any columns from - an outer query.
Stopword
Distributed partitioned view
Noncorrelated subquery
Word breaker
7. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.
Route
Page
Log Sequence Number (LSN)
Impersonation
8. An object that contains significant words and their locations within the columns included in the index
Schema binding
Full-text Index
Function
Instantiation
9. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.
DML trigger
PartItioned view
Partition scheme
Isolation
10. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.
Filter
OUTER JOIN
SQLCLR
Conversation
11. The process by which a user assumes the security credentials of another user
Partition function
Impersonation
XML data type
Methods
12. A physical structure implemented as a balanced tree that is used to speed up query operations
DML trigger
XML document
Term
Index
13. A function that defines the values that divide a table or index into multiple ___________.
XML
Nondeterministic function
Partition function
Aggregate function
14. 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
Message type
Isolation
Materialized view
Cost
15. A query that is embedded within - and references columns from - an outer query
SQLCLR
DDL trigger
Correlated subquery
Table-valued function
16. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Contract
Well-known binary (WKB)
Table-valued function
17. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.
JOIN
Full-text catalog
XML data type
Service Broker endpoint
18. A hidden table where Service Broker messages are stored until they are processed.
Index
Queue
Stoplist
Thesaurus
19. Is well formed; that is - it must have a root node.
System process ID (SPID)
Page
Cmdlets
XML document
20. 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.
Page
Atomicity
DML trigger
Schema binding
21. A deterministic view that has a unique - clustered _____ created against it
Route
Partition scheme
Indexed view
Clustered Index
22. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.
UNION
Cost
Upper bound
Event group
23. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Cmdlets
PartItioned view
Scalar function
Cost
24. Sets the relative precedence for Service Broker conversations
System process ID (SPID)
Page
Nonclustered Index
Conversation priority
25. Defines the name and contents of a message.
Variable
Contract
Nondeterministic function
Message type
26. 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
Function
SQLCLR
Unique constraint
Filter
27. The name given to the group of tasks within a Service Broker solution that require messages to be sent.
Stemmer
Service
Consistency
Geography data type
28. A built-in or user-defined function that provides a calculation on a set of rows or values
Well-known binary (WKB)
Cursor
Aggregate function
Term
29. A numeric value representing a physical location within a heap and page.
Partition function
Stored procedure
Recursive CTE
Row Identifier (RID)
30. A function that returns the results as a table data type.
Check constraint
Log Sequence Number (LSN)
Table-valued function
Variable
31. A _________ that might return a different value each time it is called given the same input parameter.
Nondeterministic function
FOR XML
Instantiation
Methods
32. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted
Geometry data type
Stopword
Object
Durability
33. 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
Nonclustered Index
Service
FOR XML
Stored procedure
34. A function created as TSQL or as Common Language Runtime (CLR) code; TSQL ____s include scalar - multi statement table valued - and inline table-valued functions.
Atomicity
User-defined function (UDF)
Cost
Geography data type
35. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.
Cursor
Word breaker
Distributed partitioned view
Page
36. Is not well-formed; that is - it does not have a root node.
Module
Durability
UNION
XML fragment
37. A collection of conversations that are related
Conversation group
Service
FOR XML
Materialized view
38. A collection of properties and methods that provide a defined functionality.
Object
Consistency
Service Broker endpoint
Module
39. Provides security to dialogs connecting to remote databases.
Variable
Full-Text Engine
Remote service binding
Partition function
40. 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.
User-defined function (UDF)
Queue
Word breaker
Full-text catalog
41. A constraint that applies a Boolean expression to rows added or updated in tables to verify whether the update should be allowed
Dialog
Materialized view
System process ID (SPID)
Check constraint
42. 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.
Token
Primary key
Table-valued function
Variable
43. The security credentials under which a code module is executed
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Execution context
OUTER JOIN
Full-text Index
44. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates
Row Identifier (RID)
Term
Geography data type
Change tables
45. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
Conversation
Conversation priority
Index
SQLCLR
46. A set of DDL events within the DDL event hierarchy
Event group
Gating role
Partition scheme
Atomicity
47. Defines on which file group each ________ defined by a _______ function should be stored.
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Well-known text (WKT)
Partition scheme
INNER JOIN
48. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Stored procedure
Module
Nonclustered Index
System process ID (SPID)
49. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
PartItioned view
Dialog
Execution context
Stoplist
50. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process
Execution context
Term
Filter daemon host process (Fdhost exe)
Queue
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests