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 built-in or user-defined function that provides a calculation on a set of rows or values
Distributed partitioned view
Aggregate function
Queue
Constraint
2. 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
PartItioned view
Partition function
Constraint
Consistency
3. 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
Constraint
Correlated subquery
Table-valued function
Function
4. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.
Well-known text (WKT)
Table-valued function
UNION
Impersonation
5. A query that is embedded within - and references columns from - an outer query
Correlated subquery
Message type
Scalar function
Gating role
6. 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
Index
Contract
Aggregate function
Cursor
7. The process by which a user assumes the security credentials of another user
Remote service binding
Atomicity
Impersonation
Clustered Index
8. A component that processes a document to extract the textual information from documents stored in a varbinary(max) or image column and then sends that information to the word breaker
Word breaker
OUTER JOIN
Filter
Execution context
9. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker
Conversation
Full-text Index
Instantiation
Partition function
10. Provides security to dialogs connecting to remote databases.
Remote service binding
Well-known text (WKT)
DetermInistic function
UNION
11. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.
Message type
Row Identifier (RID)
SQLCLR
Fllestream
12. 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
Spatial reference identifier (SRID)
Schema binding
Fllestream
Isolation
13. A numeric value assigned to each connection to SQL Server.
Nonclustered Index
Instantiation
System process ID (SPID)
Service
14. A module of code that is stored within a database that provides an API that applications can use to abstract the database structure from application code.
Log Sequence Number (LSN)
Partition scheme
Stored procedure
Spatial reference identifier (SRID)
15. A function that returns the results as a table data type.
Table-valued function
XML
Isolation
Function
16. A ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.
Correlated subquery
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
OUTER JOIN
Cmdlets
17. A numeric value representing a physical location within a heap and page.
Scalar function
Conversation priority
Row Identifier (RID)
Geometry data type
18. An object that is used to store a scalar value for use within a function - trigger - or stored procedure.
Table-valued function
Variable
Filter daemon host process (Fdhost exe)
Schema binding
19. 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.
User-defined function (UDF)
Nondeterministic function
Recursive CTE
Nonclustered Index
20. The security credentials under which a code module is executed
Heap
Nondeterministic function
Execution context
Schema binding
21. The process of adding data to a full -text index either during creation or when the full-text index is built.
Population (crawl)
Nondeterministic function
Isolation
Service Broker endpoint
22. 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
System process ID (SPID)
User-defined function (UDF)
Variable
23. 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
Event group
Isolation
Atomicity
Clustered Index
24. An international nonprofit organization that develops standards for geospatial and location-based services.
Spatial reference identifier (SRID)
Open Geospatial Consortium (OGC)
Function
Module
25. Tables within a database that store modified rows in a database with CDC enabled
UNION
Nondeterministic function
Change tables
Message type
26. A function that returns the same value every time it is executed given the same input parameters
Constraint
DetermInistic function
XML fragment
Correlated subquery
27. A _________ that might return a different value each time it is called given the same input parameter.
Conversation priority
Nondeterministic function
User-defined function (UDF)
Thesaurus
28. A constraint that applies a Boolean expression to rows added or updated in tables to verify whether the update should be allowed
Module
XML fragment
Heap
Check constraint
29. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.
Message type
Page
Correlated subquery
Stoplist
30. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.
Stemmer
XML
UNION
Conversation priority
31. A collection of conversations that are related
Conversation group
Unique constraint
Conversation priority
Open Geospatial Consortium (OGC)
32. A set of DDL events within the DDL event hierarchy
Variable
INNER JOIN
Event group
Cmdlets
33. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis
Geography data type
OGC Extended Methods
Change tables
Cursor
34. A collection of properties and methods that provide a defined functionality.
INNER JOIN
JOIN
Object
Recursive CTE
35. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are
Open Geospatial Consortium (OGC)
Impersonation
Atomicity
Upper bound
36. Is well formed; that is - it must have a root node.
XML document
Cmdlets
Conversation
Well-known binary (WKB)
37. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume
Dialog
Stopword
Cost
User-defined function (UDF)
38. A query that is embedded within - but does not reference any columns from - an outer query.
UNION
Message type
Stemmer
Noncorrelated subquery
39. A reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.
Remote service binding
Spatial reference identifier (SRID)
Identlty
Partition scheme
40. A special type of __________ that has an anchor query - which is the source of the recursion - along with a UNION ALL statement and a second query - which recurses across the anchor query - and an outer query - which references the _____ and specifie
Recursive CTE
Population (crawl)
Stoplist
Schema binding
41. A function that defines the values that divide a table or index into multiple ___________.
Cost
Table-valued function
Partition function
OGC Extended Methods
42. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.
Service Broker endpoint
Well-known binary (WKB)
DetermInistic function
SQLCLR
43. 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
Full-text catalog
Stemmer
Cursor
44. Used to configure SQL Server to send and receive messages over TCP/IP connections.
Aggregate function
Filter
Log Sequence Number (LSN)
Service Broker endpoint
45. 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.
Log Sequence Number (LSN)
Materialized view
Consistency
Durability
46. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Correlated subquery
Execution context
Scalar function
Full-text catalog
47. 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
Correlated subquery
Change tables
Full-text catalog
48. The word - phrase - or character string included as input in the full -text query.
Distributed partitioned view
Execution context
Term
Parameter
49. A physical structure implemented as a balanced tree that is used to speed up query operations
Index
Stopword
Constraint
Aggregate function
50. 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.
Cost
Conversation
JOIN
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
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