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 ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.
Module
OGC Extended Methods
Cost
OUTER JOIN
2. 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
SQL Full Text Filter Daemon launcher (Fdlauncher:exe)
Isolation
Change tables
Cost
3. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.
XML
Well-known binary (WKB)
Cost
Foreign key constraInt
4. 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.
Geography data type
Stored procedure
Foreign key constraInt
DetermInistic function
5. A _________ that might return a different value each time it is called given the same input parameter.
Event group
OUTER JOIN
Nondeterministic function
Service
6. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.
XML
Spatial reference identifier (SRID)
Dialog
Partition function
7. The word - phrase - or character string included as input in the full -text query.
Heap
Variable
Stopword
Term
8. A constraint that is used to implement referential integrity between tables (or even within a single table)
Stoplist
Event group
Isolation
Foreign key constraInt
9. Defines on which file group each ________ defined by a _______ function should be stored.
Route
Object
Partition scheme
Materialized view
10. 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
Scalar function
Event group
Conversation group
Constraint
11. A role specified when enabling CDC that is used to limit access to the change data
Gating role
Unique constraint
Durability
Scalar function
12. 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.
Event group
XML data type
Row Identifier (RID)
User-defined function (UDF)
13. A deterministic view that has a unique - clustered _____ created against it
Indexed view
Term
DDL trigger
Log Sequence Number (LSN)
14. 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
Open Geospatial Consortium (OGC)
Full-Text Engine
Row Identifier (RID)
Change tables
15. 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.
Service Broker endpoint
Word breaker
Check constraint
Service
16. Used to store planar data based on Euclidean space such as points - lines - and polygons
Cost
Remote service binding
OUTER JOIN
Geometry data type
17. 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
Conversation priority
Object
Contract
Noncorrelated subquery
18. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process
Durability
Stemmer
Filter daemon host process (Fdhost exe)
Cost
19. An international nonprofit organization that develops standards for geospatial and location-based services.
Conversation group
Full-text catalog
Schema binding
Open Geospatial Consortium (OGC)
20. A built-in or user-defined function that provides a calculation on a set of rows or values
Aggregate function
Filter
Distributed partitioned view
Variable
21. A variable that is passed to a stored procedure or function.
XML fragment
Parameter
User-defined function (UDF)
Cursor
22. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.
Nonclustered Index
Conversation
Message type
PartItioned view
23. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.
Module
Nonclustered Index
Well-known text (WKT)
SQLCLR
24. 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
Heap
Log Sequence Number (LSN)
Full-text catalog
Fllestream
25. An object that is used to store a scalar value for use within a function - trigger - or stored procedure.
Variable
Term
Filter
XML
26. A virtual object that represents a group of full-text indexes
Service Broker endpoint
Filter daemon host process (Fdhost exe)
Full-text catalog
Queue
27. A word or character string defined by a word breaker.
OGC Extended Methods
Thesaurus
Token
Event group
28. 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
Check constraint
FOR XML
Conversation priority
29. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.
Partition scheme
Nondeterministic function
Route
Atomicity
30. The security credentials under which a code module is executed
Page
Execution context
OUTER JOIN
Parameter
31. A numeric value assigned to each connection to SQL Server.
Contract
Geometry data type
System process ID (SPID)
Filter daemon host process (Fdhost exe)
32. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery
Thesaurus
Module
Dialog
Partition scheme
33. A collection of properties and methods that provide a defined functionality.
Object
Stoplist
Variable
Dialog
34. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table
OGC Extended Methods
Clustered Index
Token
Stemmer
35. Tables within a database that store modified rows in a database with CDC enabled
Service Broker endpoint
Partition function
Gating role
Change tables
36. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are
Atomicity
Full-text catalog
Isolation
Word breaker
37. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances
Distributed partitioned view
Page
Stemmer
Spatial reference identifier (SRID)
38. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.
Change tables
Filter
OGC Extended Methods
Materialized view
39. Is not well-formed; that is - it does not have a root node.
Well-known text (WKT)
Term
Row Identifier (RID)
XML fragment
40. 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
Filter
XML data type
Identlty
Nonclustered Index
41. A query that is embedded within - and references columns from - an outer query
XML
Correlated subquery
Nonclustered Index
Atomicity
42. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.
Isolation
Scalar function
OGC Extended Methods
Atomicity
43. 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
Page
Noncorrelated subquery
Filter daemon host process (Fdhost exe)
Consistency
44. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.
Geography data type
Upper bound
XML data type
Page
45. A function that returns the same value every time it is executed given the same input parameters
Execution context
Identlty
DetermInistic function
OGC Extended Methods
46. 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
Instantiation
Clustered Index
Dialog
47. 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)
User-defined function (UDF)
Recursive CTE
Gating role
48. A numeric value representing a physical location within a heap and page.
Route
Row Identifier (RID)
Recursive CTE
Conversation group
49. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.
Atomicity
Function
Module
Message type
50. XML files that define synonyms for terms in a specific language.
Thesaurus
Token
Conversation
Clustered Index
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