| Terms |
Definitions |
|
______has limited error correction
|
BCP
|
|
Database Engine Services:
|
core database, notification, replication, full-text search components
|
|
Sync Framework:
|
enables data synchronization for collaboration and offline use
|
|
Two major categories of principals:
|
Logins/users Groups
|
|
ON clause
|
specifies which filegroup should store the object
|
|
comparison operators are used to build ________
|
conditions
|
|
set DB recovery model to ______ before using BULK INSERT
|
Bulk-Logged
|
|
Performance Condition Alert
|
defined against the System Monitor Counters
|
|
Primary filegroup:
|
contains primary data file and any other file not specifically assigned to another filegroup
|
|
when exporting data using BCP, how can you specify the tab as a terminator?
|
\t
|
|
Who was the commander of the Continental Army?
|
George Washington
|
|
if the masterdb fails
|
it takes the whole server down,
|
|
what events are commonly used to establish a performance baseline?
|
RPC:Completed and SQL:BatchCompleted
|
|
what defines a set of boundary points on which data will be partitioned?
|
partition function
|
|
DBCC CHECKDB, If integrity error is found in table
|
recover from backup
|
|
Advantage of alignment:
|
if a single partition is backed up orrestored, the data and corresponding indexes are kept together as a single unit
|
|
what are the three methods of replication?
|
snapshot, transactional, and merge
|
|
SQL Server Integration Services (SSIS):
|
for extracting and transforming data from multiple sources and moving it to one or more destination data sources for data warehouses, data marts, etc.
|
|
Import & Export Data Wizard:
|
define SSIS packages for import and export
|
|
what does this partition function do?CREATE PARTITION FUNCTION PF100 (int)AS RANGE LEFT FOR VALUES9 (100);
|
First partition contains rows with values of 100 or less, second partition contains rows with values > 100
|
|
during restore, how do you make it so that the database recovers immediately
|
specify the RECOVERY option
|
|
what data types are not allowed for partition functions?
|
text, ntext, image, varbinary(max), timestamp, xml, or varchar(max)
|
|
what does the inactive transaction log contain
|
all changes that have been committed to the database
|
|
True or False, to use the Switch Operator, the source and target tables must NOT have identical structure
|
False, they should have identical structures
|
|
what errors do you see if your disk goes off-line underneath a database?
|
SQL begins logging device activation errors
|
|
If page corruption occurs in a table or on the primary key,
|
you must perform a restore to fix it
|
