Term
| In addition to being a security structure, what else does a schema function as? |
|
Definition
- a containter that owns all objects wintin a database
- a mechanism to group and/or separate objects within a database
|
|
|
Term
| What is the most fundamental performance decision you make for a database? |
|
Definition
|
|
Term
| Which two data types are designed specifically to store values with a maximum of four decimal places? And how much storage space is required for each? |
|
Definition
MONEY - 8 bytes
SMALLMONEY - 4 bytes |
|
|
Term
| Decimal data types contain what two parameters? |
|
Definition
precision and scale.
precision - the total number of digits that can be stored both to the left and to the right of the decimal.
scale - the maxiumum number of digits to the right of the decimal point. |
|
|
Term
| What are the four character data types? |
|
Definition
CHAR
VARCHAR
NCHAR
NVARCHAR |
|
|
Term
| What are the 6 Date and Time data types? |
|
Definition
SMALLDATETIME
DATETIME
DATETIME2
DATETIMEOFFSET
DATE
TIME |
|
|
Term
| In SQL Server, what type of structure are XML schemas stored within? |
|
Definition
|
|
Term
| SQL Server 2008 supports what two data types to store spatial data? |
|
Definition
|
|
Term
| What data type is used to organize hierarchical data? |
|
Definition
|
|
Term
| Which column property controls the way characters in various languages are handled? |
|
Definition
|
|
Term
| What column property alleviates the issue of both controlling and maintaining files with SQL Server and allowing the data to reside in a file on the operating system? |
|
Definition
|
|
Term
| What column property is designed to optimize storage space for columns with a large percentage of NULLS? |
|
Definition
|
|
Term
| When is it invalid to apply the SPARSE property to a column? |
|
Definition
- columns with the ROWGUIDCOL or IDENTITY property
- TEXT, NTXT, IMAGE, TIMESTAMP, GEOMETRY, GEOGRAPHY, or user-defined data types
- a VARBINARY(MAX) with the FILESTREAM property
- a computed column of a column with a rule or default bound to it
- columns that are part of either a clustered index or a primary key
- a column within an ALTER TABLE statement
|
|
|
Term
| What is the benefit of row-level compression? |
|
Definition
| Row-level compression allows individual rows to be compressed to fit more rows on a page, which reduces the amount of storage space for the table, thus reducing pages on a disk. |
|
|
Term
| How are temp tables categorized and how are they designated? |
|
Definition
categorized: local or global
designated: # for local (i.e., #tempdb);
## for global (i.e., ##tempdb) |
|
|
Term
| Compression is not compatible with what type of column property? |
|
Definition
|
|
