D


Index


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

data access
     concurrency 2nd 3rd
     exam prep questions 2nd 3rd 4th 5th 6th
     indexes 2nd
         clustered 2nd
         covering 2nd
         dropping 2nd
         full-text 2nd
         Index Tuning Wizard 2nd
         indexed views 2nd
         nonclustered 2nd 3rd
         rebuilding 2nd 3rd
         strategies 2nd
         what not to index 2nd 3rd
         what to index 2nd
     locks 2nd 3rd
         contention 2nd
         controlling lock behavior 2nd 3rd
         exclusive locks
         granularity
         shared locks
         transaction isolation levels 2nd
     partitioned views 2nd
         indexing 2nd
     stored procedures 2nd 3rd 4th
         recompilation 2nd
         web applications and 2nd
     transactions 2nd 3rd
         atomicity
         beginning 2nd
         consistency
         durability
         isolation
         isolation levels 2nd
         rolling back 2nd
data analysis 2nd
data cache
data encryption [See encryption]
data files
data formatting 2nd
data integrity
     definition of
data modeling [See logical data modeling]
data normalization [See normalization]
data replication [See replication]
data retrieval
     conditional data filtering
         arithmetic operators
         BETWEEN keyword
         bitwise operators
         comparison operators 2nd
         EXISTS keyword
         IN keyword
         LIKE keyword 2nd
         logical operators 2nd
         NULL values 2nd
         unary operators
     exam prep questions 2nd 3rd 4th 5th 6th 7th 8th
     joining multiple sets of data 2nd
         cross joins 2nd
         inner joins 2nd
         outer joins 2nd 3rd
         unions 2nd 3rd
     moving data 2nd
         BACKUP/RESTORE operations 2nd
         BCP (Bulk Copy Program) 2nd 3rd 4th
         DTS Import/Export Wizard 2nd
         XML (Extensible Markup Language) 2nd 3rd
     SELECT statement
         arithmetic operators
         BETWEEN keyword
         bitwise operators
         column names, specifying 2nd
         comparison operators 2nd
         COMPUTE BY clause
         COMPUTE clause
         CUBE keyword 2nd
         DISTINCT clause
         EXISTS keyword
         EXPLICIT clause 2nd
         FOR XML clause 2nd
         FROM clause
         GROUP BY clause 2nd
         HAVING clause
         IN keyword
         INTO clause 2nd
         LIKE keyword 2nd
         logical operators 2nd
         NULL values 2nd
         OPENXML keyword 2nd 3rd
         ORDER BY clause 2nd
         ROLLUP keyword 2nd
         SET ROWCOUNT clause
         simple example 2nd 3rd
         TOP clause 2nd
         unary operators
         WHERE clause
Data Transformation Services [See DTS]
Data Type descriptor (columns)
data types 2nd
     binary data types 2nd
     casting 2nd
     character data types 2nd
     converting 2nd
     metadata 2nd
     numeric data types 2nd
     object definitions 2nd
     specialty data types 2nd
     user data 2nd
     user-defined data types 2nd 3rd
database
     concurrency 2nd 3rd
     owners
Database Console Command [See DBCC]
database diagrams 2nd
     definition of
Database Properties dialog box 2nd
     Auto options 2nd
     Cursor options 2nd
     Recovery options 2nd
     SQL options 2nd 3rd
     State options 2nd 3rd
databases 2nd 3rd 4th 5th 6th 7th 8th [See also logical data modeling] [See also exam prep questions] [See also security]
     (relational)
     alerts
     altering
     cascade action 2nd
    checks and balances
         CHECK constraints 2nd
         COLUMN CHECK constraints 2nd
         TABLE CHECK constraints
     collation sequences 2nd
     configuration options 2nd
         ANSI_NULL_DEFAULT
         ANSI_NULLS
         ANSI_PADDING
         ANSI_WARNINGS
         ARITHABORT
         AUTO_CLOSE 2nd
         AUTO_CREATE_STATISTICS
         AUTO_SHRINK
         AUTO_UPDATE_STATISTICS
         CONCAT_NULL_YIELDS_NULL
         CURSOR_CLOSE_ON_COMMIT
         CURSOR_DEFAULT GLOBAL
         CURSOR_DEFAULT LOCAL
         MULTI_USER
         NUMERIC_ROUNDABORT
         OFFLINE
         QUOTED_IDENTIFIER
         READ_ONLY
         READ_WRITE
         RECOVERY BULK_LOGGED
         RECOVERY FULL
         RECOVERY SIMPLE
         RECURSIVE_TRIGGERS
         RESTRICTED_USER
         SINGLE_USER
         TORN_PAGE_DETECTION
         WITH termination (termination in italic) 2nd
    constraints
         definition of
     creating 2nd 3rd 4th 5th
    data types
         user-defined data types
     database diagrams 2nd
         definition of
     default names
     defaults 2nd 3rd
     definition of 2nd
     deleting data from 2nd 3rd
     denormalization 2nd 3rd 4th 5th
     dependencies
         parent-child
     design 2nd
     distribution
     exam prep questions 2nd 3rd 4th 5th 6th
    fields
         definition of
     file system
         file placement 2nd
         filegroups 2nd
         filenames
         primary files
         secondary files
     Full-Text catalogs 2nd
     indexes 2nd 3rd 4th 5th 6th
         clustered 2nd
         clustered indexes 2nd
         covering 2nd
         creating 2nd
         definition of
         dropping 2nd
         fill factor 2nd
         full-text 2nd
         Full-Text indexes 2nd
         Index Tuning Wizard 2nd
         indexed views 2nd
         nonclustered 2nd 3rd
         nonclustered indexes 2nd
         Pad Index setting
         rebuilding 2nd 3rd 4th
         strategies 2nd
         unique indexes
         what not to index 2nd 3rd
         what to index 2nd
     inserting data into 2nd 3rd
     jobs
     joining multiple sets of data 2nd
         cross joins 2nd
         inner joins 2nd
         outer joins 2nd 3rd
         unions 2nd 3rd
     locks 2nd 3rd
         contention 2nd
         controlling lock behavior 2nd 3rd
         exclusive locks
         granularity
         shared locks
         transaction isolation levels 2nd
     Master 2nd
     minimum hardware requirements 2nd 3rd 4th
     Model 2nd
    moving data
         BACKUP/RESTORE operations 2nd
         BCP (Bulk Copy Program) 2nd 3rd 4th
         DTS Import/Export Wizard 2nd
         moving data 2nd
         moving data;XML (Extensible Markup Language) 2nd 3rd
     msdb 2nd
     normalization 2nd 3rd
         definition of 2nd
         fifth normal form
         first normal form 2nd
         fourth normal form
         second normal form
         third normal form
     Northwind
     object groupings 2nd
     OLE-DB 2nd
     operating system service properties 2nd
     operators
     packages
     permissions
    properties
         altering 2nd
     Pubs
     querying with SELECT
         arithmetic operators
         BETWEEN keyword
         bitwise operators
         column names, specifying 2nd
         comparison operators 2nd
         COMPUTE BY clause
         COMPUTE clause
         CUBE keyword 2nd
         DISTINCT clause
         EXISTS keyword
         EXPLICIT clause 2nd
         FOR XML clause 2nd
         FROM clause
         GROUP BY clause 2nd
         HAVING clause
         IN keyword
         INTO clause 2nd
         LIKE keyword 2nd
         logical operators 2nd
         NULL values 2nd
         OPENXML keyword 2nd 3rd
         ORDER BY clause 2nd
         ROLLUP keyword 2nd
         SET ROWCOUNT clause
         simple example 2nd 3rd
         TOP clause 2nd
         unary operators
         WHERE clause
     RAID (redundant array of independent/inexpensive disks) 2nd
    records
         definition of
     referential integrity
     relationships 2nd 3rd 4th
         cardinality
         identifying 2nd
         many-to-many 2nd 3rd 4th 5th
         one-to-many 2nd 3rd 4th
         one-to-one 2nd 3rd
     replication 2nd 3rd 4th
         advantages of 2nd
         articles
         central Publisher, multiple Subscribers 2nd
         data distribution 2nd
         Distributors
         latency 2nd
         merge replication 2nd 3rd 4th
         multiple Publishers, multiple Subscribers 2nd
         multiple Publishers, single Subscriber
         publications
         Publishers
         single Publisher, single Subscriber 2nd
         site autonomy 2nd
         snapshot replication 2nd 3rd 4th
         Subscribers
         transactional consistency 2nd
         transactional replication 2nd 3rd
    roles
         definition of
    rows
         counting
     rules
     security
     server configuration settings
         Affinity Mask
         Allow Updates
         AWE Enabled
         C2 Audit Mode
         Cost Threshold for Parallelism
         Cursor Threshold
         Default Full-Text Language
         Default Language
         Fill Factor
         Index Create Memory
         Lightweight Pooling
         Locks
         Max Degree of Parallelism
         Max Server Memory
         Max Text Repl Size
         Max Worker Threads
         Media Retention
         Min Memory Per Query
         Min Server Memory
         Nested Triggers
         Network Packet Size
         Open Objects
         Priority Boost
         Query Governor Cost Limit
         Query Wait
         Reconfigure 2nd
         Recovery Interval
         Remote Access
         Remote Login Timeout
         Remote Proc Trans
         Remote Query Timeout
         Scan for Startup Process
         Set Working Set Size
         Two Digit Year Cutoff
         User Connections
         User Options
     stored procedures 2nd
         definition of
     tables 2nd 3rd 4th
         columns 2nd 3rd 4th
         cross joins 2nd
         definition of 2nd
         FOREIGN KEY constraints 2nd
         inner joins 2nd
         outer joins 2nd 3rd
         PRIMARY KEY constraints 2nd 3rd
         syscolumns
         syscomments
         sysdatabases
         sysindexes
         syslogins
         sysmessages
         sysobjects
         sysprocesses
         sysremotelogins
         sysservers
         systypes
         sysusers
         unions 2nd 3rd
     tempdb 2nd
     triggers 2nd
         definition of
    troubleshooting
         failed object creation 2nd
     updating
     user-defined functions
         definition of
     users
         adding
         definition of
     very large database applications 2nd
     views 2nd 3rd 4th 5th 6th
         advantages of 2nd
         altering
         creating 2nd 3rd
         definition of
         dropping 2nd
         indexed views 2nd 3rd
         partitioned views 2nd 3rd
         schema binding 2nd 3rd 4th
DATALENGTH() function
date/time functions
     DATEADD() 2nd
     DATEDIFF() 2nd
     DATENAME() 2nd
     DATEPART() 2nd
     GETDATE()
DATEADD() function
DATEDIFF() function 2nd
DATENAME() function 2nd
DATEPART() function 2nd
datetime data type
DB_ID() function
DB_NAME() function
DBCC (Database Console Command) 2nd 3rd
     maintenance options 2nd
     miscellaneous options 2nd
     trace flags 2nd
     validation options 2nd
DBCC DBREINDEX statement
DEALLOCATE statement
deallocating
     cursors
DECLARE CURSOR statement 2nd
declaring
     variables
decomposing
     attributes 2nd 3rd
Default Full-Text Language option (server properties)
Default Language option (server properties)
Default Value descriptor (columns)
defaults 2nd 3rd 4th
defining
     attributes 2nd 3rd
DELETE statement 2nd 3rd
deleting
     triggers
deleting data
     DELETE statement 2nd 3rd
denormalization 2nd 3rd 4th 5th
dependencies
     parent-child
Description descriptor (columns)
design
     business systems 2nd
         automation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
         distributed data 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
         exam prep questions 2nd 3rd 4th 5th
         Internet application architecture 2nd
         one-tier systems 2nd
         replication 2nd 3rd 4th 5th 6th 7th
         SQL Server Back Office integration 2nd
         third-party database interactions 2nd
         three- or more tier systems 2nd
         two-tier systems 2nd
         very large database applications 2nd
     databases 2nd
deterministic functions
deviation functions
diagrams
     ERDs (Entity Relationship Diagrams)
diagrams (database) 2nd
     definition of
dialog boxes
     Database Properties 2nd
         Auto options 2nd
         Cursor options 2nd
         Recovery options 2nd
         SQL options 2nd 3rd
         State options 2nd 3rd
     Server Properties
         Affinity Mask option
         Allow Updates option
         AWE Enabled option
         C2 Audit Mode option
         Cost Threshold for Parallelism option
         Cursor Threshold option
         Default Full-Text Language option
         Default Language option
         Fill Factor option
         Index Create Memory option
         Lightweight Pooling option
         Locks option
         Max Degree of Parallelism option
         Max Server Memory option
         Max Text Repl Size option
         Max Worker Threads option
         Media Retention option
         Min Memory Per Query option
         Min Server Memory option
         Nested Triggers option
         Network Packet Size option
         Open Objects option
         Priority Boost option
         Query Governor Cost Limit option
         Query Wait option
         Reconfigure option 2nd
         Recovery Interval option
         Remote Access option
         Remote Login Timeout option
         Remote Proc Trans option
         Remote Query Timeout option
         Scan for Startup Process option
         Set Working Set Size option
         Two Digit Year Cutoff option
         User Connections option
         User Options option
DISTINCT clause (SELECT statement)
distributed data 2nd
     linked servers 2nd 3rd 4th
     OLE-DB 2nd
     OPENQUERY function
     OPENROWSET function 2nd 3rd
     remote servers 2nd
distributed partitioned views
Distributed Transaction Services (DTS)
distribution database
Distributors
double dash (--)
DROP EXISTING clause (CREATE INDEX statement)
DROP INDEX statement
DROP TRIGGER statement
DROP VIEW statement
dropping
     indexes 2nd
     triggers
     views 2nd
DTS (Data Transformation Services)
     Import/Export Wizard 2nd
DTS (Distributed Transaction Services)
durability (transactions)
DYNAMIC cursors



EXAM CRAM 2 Designing and Implementing Databases with SQL Server 2000 Enterprise
MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
ISBN: 0789731061
EAN: 2147483647
Year: 2005
Pages: 154

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net