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. Provides security to dialogs connecting to remote databases.
FOR XML
Queue
Remote service binding
Message type
2. 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
UNION
Fllestream
Execution context
Noncorrelated subquery
3. A trigger that executes in response to a DDL event
INNER JOIN
Parameter
DDL trigger
Nonclustered Index
4. A word or character string defined by a word breaker.
Stoplist
Nonclustered Index
Change tables
Token
5. Used to store planar data based on Euclidean space such as points - lines - and polygons
Distributed partitioned view
Geometry data type
Function
Primary key
6. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.
Upper bound
Indexed view
Aggregate function
Thesaurus
7. 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
Atomicity
Stored procedure
Isolation
Constraint
8. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.
Remote service binding
Stoplist
Well-known binary (WKB)
Stopword
9. 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.
FOR XML
Conversation priority
Variable
Schema binding
10. A trigger that executes in response to a DML event
Nonclustered Index
Term
Clustered Index
DML trigger
11. A built-in or user-defined function that provides a calculation on a set of rows or values
Conversation
Aggregate function
Module
DetermInistic function
12. A set of DDL events within the DDL event hierarchy
Open Geospatial Consortium (OGC)
Conversation group
Cmdlets
Event group
13. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.
Indexed view
XML
Word breaker
Contract
14. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table
Atomicity
System process ID (SPID)
Execution context
Clustered Index
15. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are
Methods
Isolation
Atomicity
Instantiation
16. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.
Full-Text Engine
Nonclustered Index
Geometry data type
XML data type
17. 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
XML document
Function
Conversation priority
Identlty
18. 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
Full-text catalog
Indexed view
Consistency
Stemmer
19. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.
Cost
Nondeterministic function
Materialized view
Spatial reference identifier (SRID)
20. A numeric value representing a physical location within a heap and page.
Word breaker
Row Identifier (RID)
Geography data type
Conversation group
21. A TSQL operator that combines the result sets from multiple queries.
Stoplist
OUTER JOIN
UNION
Table-valued function
22. A constraint that applies a Boolean expression to rows added or updated in tables to verify whether the update should be allowed
User-defined function (UDF)
Stemmer
Cost
Check constraint
23. A query that is embedded within - and references columns from - an outer query
Word breaker
Indexed view
Correlated subquery
Clustered Index
24. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances
Dialog
Distributed partitioned view
Full-Text Engine
XML fragment
25. A deterministic view that has a unique - clustered _____ created against it
Geography data type
FOR XML
Gating role
Indexed view
26. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
FOR XML
Change tables
Module
XML document
27. 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.
Schema binding
Object
XML
Log Sequence Number (LSN)
28. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
Cost
Population (crawl)
Atomicity
OUTER JOIN
29. Is not well-formed; that is - it does not have a root node.
Upper bound
Distributed partitioned view
XML fragment
Table-valued function
30. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.
Distributed partitioned view
Stopword
INNER JOIN
Stemmer
31. 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
DML trigger
Nonclustered Index
Partition function
Well-known text (WKT)
32. Defines on which file group each ________ defined by a _______ function should be stored.
Identlty
Partition scheme
Spatial reference identifier (SRID)
SQLCLR
33. Tables within a database that store modified rows in a database with CDC enabled
Filter daemon host process (Fdhost exe)
Noncorrelated subquery
Change tables
Event group
34. A numeric value assigned to each connection to SQL Server.
Well-known text (WKT)
Parameter
System process ID (SPID)
Nonclustered Index
35. A hidden table where Service Broker messages are stored until they are processed.
DML trigger
Schema binding
Index
Queue
36. Is well formed; that is - it must have a root node.
Full-Text Engine
Scalar function
Index
XML document
37. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.
PartItioned view
Isolation
DDL trigger
Unique constraint
38. _______ designed to work with geometry and geography data types.
OGC Extended Methods
Partition function
Scalar function
Row Identifier (RID)
39. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.
Indexed view
Page
XML document
Partition function
40. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process
Full-Text Engine
UNION
Methods
Filter daemon host process (Fdhost exe)
41. 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.
Index
Schema binding
Conversation group
User-defined function (UDF)
42. A function that defines the values that divide a table or index into multiple ___________.
Route
Partition function
Aggregate function
DDL trigger
43. 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
Heap
DDL trigger
Clustered Index
44. 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
Word breaker
Full-Text Engine
Token
Service
45. 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.
Word breaker
Durability
Nondeterministic function
Service Broker endpoint
46. The security credentials under which a code module is executed
Primary key
Word breaker
Execution context
Well-known binary (WKB)
47. A virtual object that represents a group of full-text indexes
Full-text catalog
Conversation priority
Nondeterministic function
Noncorrelated subquery
48. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.
SQLCLR
Constraint
Aggregate function
Stoplist
49. The name given to the group of tasks within a Service Broker solution that require messages to be sent.
Impersonation
Service
Queue
Remote service binding
50. A function that returns the results as a table data type.
Table-valued function
Function
Partition scheme
Full-text Index
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