Shared Flashcard Set

Details

DBA, Exam 1 Review
Collects Terms that will for sure be on the Exam
32
Computer Science
Undergraduate 4
02/15/2011

Additional Computer Science Flashcards

 


 

Cards

Term
SQL Server Analysis Services (SSAS):
Definition
online analytical processing (OLAP) and data mining; enables you to work with aggregated data from multiple sources
Term
SQL Server Integration Services (SSIS):
Definition
for extracting and transforming data from multiple sources and moving it to one or more destination data sources for data warehouses, data marts, etc.
Term
Reporting Services:
Definition
Report Manager and Report Server for
creating, managing, and distributing reports; built on IIS and .NET Framework technology
Term
Service Broker:
Definition
provides reliable queuing and messaging as a central part of the database; allows queries to be stacked and performed as resources allow; delivers notification messages
Term
Sync Framework:
Definition
enables data synchronization for collaboration and offline use
Term
Where are files stored in filestream?
Definition
Files are stored in a folder on the OS, but are linked directly into a database
Term
what property do you use to designate a filegroup to be used for unstructured data?
Definition
the CONTAINS FILESTREAM property
Term
what does the filestream.hdr file do?
Definition
a system file used to manage files written to the folder in FILESTREAM
Term
DBCC CHECKDB, what does it do?
Definition
use this command to read every page from disk and check integrity
Term
DBCC CHECKDB, if integrity error is found in index
Definition
drop and rebuild it
Term
DBCC CHECKDB, If integrity error is found in table
Definition
recover from backup
Term
What three commands does DBCC CHECKDB execute?
Definition
1. DBCC CHECKALLOC: checks page allocation of the DB
2. DBCC CHECKCATALOG: checks the DB catalog
3. DBCC CHECKTABLE: checks each table and view in the DB for structural integrity
Term
Transaction Logs, when a transaction has been committed, the change must be ________________
Definition
hardened to persistent storage
Term
Maximum transaction throughput for any database is bound by the amount of data per second that can be written to the ___________
Definition
Transaction logs
Term
When is the only time that data is read from the transaction log?
Definition
recovery
Term
Put these in order:
Transaction Log, Buffer, Data Files
Definition
Buffer > Transaction Log > Data File
Term
What are the three types of recovery models?
Definition
1. Full
2. Bulk-logged
3. Simple
Term
Which Recovery Model allows you to retrieve data from any given point in time?
Definition
Full Recovery Model
Term
Which recovery model has the least amount of data loss?
Definition
Full Recovery Model
Term
in Full Recovery, when are changes to the transaction log removed?
Definition
execution of a transaction log backup
Term
Which Recovery model is used most for OLTP (online transaction processing) DBs
Definition
Full Recovery
Term
Which recovery model uses minimal logging
Definition
Bulk-logged Recovery Model
Term
BCP and Bulk Insert are used in what Recovery Model
Definition
Bulk-logged Recovery Model
Term
Which recovery models cannot recover to a given point in time?
Definition
Bulk-logged and Simple
Term
In the Simple Recovery model, what happens to the transaction log once it's committed
Definition
It is immediately discarded
Term
T or F, you can recover to a specific point in time using Simple Recovery Model
Definition
False
Term
What command do you use to set the recovery model
Definition
ALTER DATABASE command
Term
how many pages are in an Extent?
Definition
8 pages
Term
How many kilobytes does a page hold?
Definition
8kb
Term
Full text indexes allow you to work with unstructured data in what 3 types of columns?
Definition
1. Filestream
2. XML
3. Large Character
Term
For Data Protection, Data should use RAID _______
Definition
RAID 0+1 or RAID 5
Term
For Data Protection, Data should use RAID _______
Definition
RAID 1
Supporting users have an ad free experience!