Reading...
Play button
Play button
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;
14 Cards in this Set
- Front
- Back
|
AUTO_CLOSE
|
ON - db is shutdown cleanly and resources freed, reopens when user accesses db again
OFF - db remains open after last user exists (default except for sQL server 2000 or SQL server express) |
|
|
AUTO_CREATE_STATISTICS
|
ON-any missing stats required by a query for optimization are auto-build during query optimization (default)
OFF-stats must be manually created |
|
|
AUTO_SHRINK
|
ON-db files are candidates for periodic shrinking, both data and log files can be shrunk automatically by SQL server. reduces the size of Trans Log if set to Simple recovery model.
OFF - no auto shrinking, nor checking (default |
|
|
AUTO_UPDATE_STATISTICS_ASYNCHRONOUSLY
|
true-updates the stats asynchronously
false-(default) |
|
|
CURSOR_CLOSE_ON_COMMIT
|
ON-any cursors open when a transaction is committed or rolled back are closed.
OFF - cursors remain open, rolling back a trans closes any cursors except those defined as INSENSITIVE or STATIC (default) |
|
|
CURSOR_DEFAULT
|
LOCAL-the scope is local to the batch, sp, or trigger
GLOBAL-cursor can be referenced in any sp or batch executed by the connection (default) |
|
|
DB availability - OFFLINE | ONLINE | EMERGENCY
|
ONLINE-open and available for use(default)
OFFLINE-closed and shutdown cleanly and marked offline (default) EMERGENCY-READ_ONLY,logging is disabled and access is limited to members of sysdamin fixed server role |
|
|
DB availability - READ_ONLY |READ_WRITE
|
READ_ONLY- users can read from the db but not modify
READ_WRITE - available for modification(default) |
|
|
DB availability - SINGLE_USER | RESTRICTED_USER | MULTI_USER
|
SINGLE_USER - one user at a time is allowed to connect to the db. all other user connections are broken
RESTRICTED_USER - only members of the db_owner fixed but number not limited MULTI_USER - all users w/ permissions to connect are allowed(default) |
|
|
DB_CHAINING
|
ON-db can be source or target of cross-db ownership chain
OFF- db cannot participate in cross-db ownership chaining (default) |
|
|
TRUSTWORTHY
|
ON-db modules that use impersonation context can access resources outside the db
OFF-impersonation context cannot access resources outside the db. set to OFF whenever the db is attached (default) |
|
|
PARAMETERIZATION
|
SIMPLE- queries are parameterized based on the default behavior of the db. (default)
FORCED-parameterizes all queries in the db |
|
|
RECOVERY
|
FULL-(default)
SIMPLE BULK-LOGGED |
|
|
PAGE_VERIFY
|
CHECKSUM - db engine calculates a checksum over the contents of the whole page an stores the value in the page header when a page is written to disk.(default)
TORN_PAGE_DETECTION-a specific 2-bit pattern for each 512-byte sector in the 8-KB db page is saved and stored in the db NONE-db page writes will not generate checksum or tornpage |
