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 function that returns the results as a table data type.
Message type
Full-Text Engine
Upper bound
Table-valued function
2. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Instantiation
Aggregate function
Scalar function
Remote service binding
3. Defines the name and contents of a message.
Message type
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
SQLCLR
Check constraint
4. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.
Queue
Scalar function
XML
Well-known text (WKT)
5. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.
Page
Noncorrelated subquery
Full-Text Engine
Dialog
6. The name given to the group of tasks within a Service Broker solution that require messages to be sent.
DDL trigger
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Schema binding
Service
7. 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
Identlty
Correlated subquery
Upper bound
Partition scheme
8. A virtual object that represents a group of full-text indexes
Table-valued function
Full-text catalog
Row Identifier (RID)
Population (crawl)
9. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.
Correlated subquery
XML data type
User-defined function (UDF)
Variable
10. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are
Log Sequence Number (LSN)
Nondeterministic function
Atomicity
Change tables
11. The process of producing a particular instance of an object based on the object's properties and methods
Materialized view
Instantiation
Conversation group
Methods
12. A trigger that executes in response to a DML event
Word breaker
Conversation
DML trigger
Distributed partitioned view
13. A role specified when enabling CDC that is used to limit access to the change data
Gating role
Spatial reference identifier (SRID)
Cmdlets
Object
14. A trigger that executes in response to a DDL event
Message type
Isolation
DDL trigger
Primary key
15. A variable that is passed to a stored procedure or function.
Remote service binding
Gating role
Token
Parameter
16. A physical structure implemented as a balanced tree that is used to speed up query operations
Well-known text (WKT)
Materialized view
OGC Extended Methods
Index
17. A constraint that is used to implement referential integrity between tables (or even within a single table)
XML document
Distributed partitioned view
Heap
Foreign key constraInt
18. 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.
Contract
SQLCLR
Durability
Stopword
19. 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
Index
Cmdlets
Conversation group
20. An international nonprofit organization that develops standards for geospatial and location-based services.
Event group
Stoplist
Open Geospatial Consortium (OGC)
UNION
21. A deterministic view that has a unique - clustered _____ created against it
JOIN
Indexed view
Queue
XML document
22. A way to make SQL Server return a stream making up an XML document or fragment
FOR XML
Cursor
Execution context
Well-known text (WKT)
23. The security credentials under which a code module is executed
OUTER JOIN
Cost
Function
Execution context
24. Used to store planar data based on Euclidean space such as points - lines - and polygons
User-defined function (UDF)
Atomicity
Stored procedure
Geometry data type
25. The process of adding data to a full -text index either during creation or when the full-text index is built.
Scalar function
Queue
Page
Population (crawl)
26. 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.
Schema binding
Table-valued function
Conversation group
PartItioned view
27. A word or character string defined by a word breaker.
Gating role
Fllestream
Token
System process ID (SPID)
28. Is well formed; that is - it must have a root node.
Recursive CTE
Open Geospatial Consortium (OGC)
Gating role
XML document
29. 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
Token
Function
Stopword
PartItioned view
30. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.
Term
Heap
Consistency
Materialized view
31. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
DDL trigger
Event group
Filter daemon host process (Fdhost exe)
Cost
32. Actions an object can perform.
Consistency
Impersonation
Function
Methods
33. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.
XML
DML trigger
SQLCLR
Thesaurus
34. A database object that is used to manage stopwords; There is a system-defined stoplist and you can also create your own stoplists.
Gating role
Stoplist
Variable
Durability
35. A function that returns the same value every time it is executed given the same input parameters
Isolation
DetermInistic function
FOR XML
XML
36. A query that is embedded within - and references columns from - an outer query
Correlated subquery
Token
Schema binding
Term
37. A collection of conversations that are related
Primary key
Atomicity
INNER JOIN
Conversation group
38. 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.
Foreign key constraInt
INNER JOIN
Word breaker
Well-known text (WKT)
39. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Event group
Execution context
JOIN
Module
40. A _________ that might return a different value each time it is called given the same input parameter.
Nondeterministic function
Foreign key constraInt
Conversation group
INNER JOIN
41. _______ designed to work with geometry and geography data types.
Conversation priority
Spatial reference identifier (SRID)
Indexed view
OGC Extended Methods
42. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
Spatial reference identifier (SRID)
Dialog
Page
XML document
43. The word - phrase - or character string included as input in the full -text query.
Queue
XML
Table-valued function
Term
44. A function that defines the values that divide a table or index into multiple ___________.
Constraint
Filter
Route
Partition function
45. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis
PartItioned view
Filter
Cursor
Route
46. An object that contains significant words and their locations within the columns included in the index
Consistency
Gating role
Index
Full-text Index
47. A set of DDL events within the DDL event hierarchy
OGC Extended Methods
Event group
Message type
Conversation group
48. A constraint that applies a Boolean expression to rows added or updated in tables to verify whether the update should be allowed
Check constraint
Word breaker
Thesaurus
Scalar function
49. The process by which a user assumes the security credentials of another user
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Impersonation
XML
Well-known binary (WKB)
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.
Partition function
Partition scheme
PartItioned view
Log Sequence Number (LSN)
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