Shared Flashcard Set

Details

Intro to Database Management
CH 8 Improving Data Access
12
Computer Science
Undergraduate 4
07/18/2012

Additional Computer Science Flashcards

 


 

Cards

Term
Disk Access
Definition
how quickly hard disk can process read and write requests
Term
SQL Server Profiler
Definition
captures database activity for analysis
Term
SQL Server Database Tuning Engine
Definition
analyzes system activity and reports on index use
Term
Clustered Indexes
Definition
impose physical organization on tables, sort rows in index order
Term
Non clustered Indexes
Definition
provide logical organization, organize data according to specified columns, do not affect physical table order
Term
CREATE INDEX
Definition
used to create indexes
Term
ALTER INDEX
Definition
to modify index
Term
DROP INDEX
Definition
to delete index
Term
Views
Definition
used to provide access to selected data, helps to restrict access to the database
Term
Procedure
Definition
set of executable statements that supports input and output parameters
Term
Function
Definition
accepts input parameters and returns specific type of value, either scalar or table value
Term
Trigger
Definition
specialized procedure associated with specific objects or events
Supporting users have an ad free experience!