Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
28 Cards in this Set
- Front
- Back
The FOR XML clause is executed after what clause in a query? |
After ORDER BY |
|
True or False: XML, and XML querying languages, are case-sensitive |
True |
|
What is XQuery used for? |
Browsing XML instances and returning XML. |
|
What are FLWOR expressions and what does FLWOR mean? |
Meaning: For, let, where, order by, return They are a for each loop, used to iterate through sequences. |
|
What is the sequence object? |
An independent object in the database from which you can obtain new sequence values. Like identity it supports any numeric type with a scale of 0. Unlike identity, it's not tied to a particular column. |
|
What are the only two clauses of a query that a window function can be in? |
SELECT and ORDER BY |
|
What operator is usually used to create a recursive query using CTEs? |
UNION ALL |
|
What is the value range for the tinyint data type? |
0-255 |
|
What is the value range for the smallint data type? |
About -32,000 to 32,000 |
|
How many bytes are in the integer datatype? Bigint? |
int - 4 bigint - 8 |
|
How many bytes are in the uniqueidentifier data type? |
16 |
|
What is the rowversion data type? |
Autogenerated, successor type to timestamp |
|
What is the maximum size (in bytes) of a value stored using the XML data type? |
2 GB |
|
What data type can store data of various data types? |
sql_variant |
|
What is the ISO standard for float? float(?)
|
float(24) |
|
What is the ISO and ANSI standard for datetime? |
2005-07-01 00:00:00.000 |
|
Parse is a new function that does what? |
Converts strings to date, time and number types. |
|
What happens if a try_parse fails? |
It returns a null value |
|
What does the format function do? |
Format data to different formats |
|
Unicode covers all characters in __________, which is a large range of international characters. |
UTF18 |
|
What does charindex return? |
An int which states the starting position of the indicated string in the searched string. |
|
Which data type is larger in size? Datetime or Datetime2? |
Datetime2 can be as large as datetime (8 bytes) but can also be as small as 4 bytes. Datetime is always 8 bytes. |
|
Do date or time data types save space compared to using a datetime data type for ONLY it's date or time? |
Yes, slightly |
|
If OrderDate is a datetime column is the following a valid where clause?
WHERE OrderDate = '20070805' |
Yes |
|
Does the data type uniqueidentifier create a unique ID for all databases or just the current database? |
Current database |
|
What does the ROWGUIDCOL property for a data type do? |
Enforces a unique value throughout all databases on networked computers. |
|
How does a NEWSEQUENTIALID function differ from NEWID function and what are the advantages? |
NEWSEQUENTIALID creates an incremented GUID which offers better performance because it can take advantage of more cached data pages. |
|
What does the MERGE (keyword) do in a TSQL statement? |
Performs insert, update, or delete operations on a target table based on the results of a join with a source table. |