Term
Which of the following would be considered a shared resource in a system configured with failover clustering?
A) Covered Fill
B) Fill Group
C) Narrow Group
D) Cluster Group |
|
Definition
|
|
Term
Which of the following is a query whose requested table columns are all stored in a single index?
A) Cluster Query
B) Covered Query
C) Disk Query
D) Fill Query |
|
Definition
|
|
Term
Which of the following would be considered step-by-step instructions for implementing a query in the most efficient way?
A) Execution Plan
B) Stripe Plan
C) Parity Plan
D) Procedure Plan |
|
Definition
|
|
Term
____ involves combining two or more hard drives into a single logical drive and writing chunks of data across all of the disks in a round robin fashion.
A) Fill Striping
B) Node Striping
C) Disk Striping
D) Narrow Striping |
|
Definition
|
|
Term
Which of the following would be considered an attribute of an index that defines the amount of free space left on each page of the index when it is created or rebuilt?
A) Fill Factor
B) Node Factor
C) Stripe Factor
D) Parallel Factor |
|
Definition
|
|
Term
Which of the following refers to inefficient use of physical storage that results from page splitting?
A) Tracing
B) Indexing
C) Fragmentation
D) All Of The Above |
|
Definition
|
|
Term
____ are T-SQL directories used to manually control how an execution plan is generated by the query optimizer?
A) Stripes
B) Hints
C) Page Split
D) None Of The Above |
|
Definition
|
|
Term
Which of the following has very few key columns?
A) Narrow Index
B) Wide Index
C) Query Index
D) Table Index |
|
Definition
|
|
Term
____ is a single computer running a cluster configuration.
A) Stripe
B) Parallel
C) Node
D) None Of The Above |
|
Definition
|
|
Term
Which of the following refers to the process of handling a new insertion to a full index or data page?
A) Parallel Split
B) Parity Split
C) Stripe
D) Page Split |
|
Definition
|
|
Term
Which of the following is a process by which multiple CPUs are used to read data resigning on multiple filegroups simultaneously?
A) Parallel Scans
B) Trace Scans
C) Procedure Scans
D) SP Scans |
|
Definition
|
|
Term
Which of the following terms refers to an integers property of being odd or even?
A) Cache
B) Parity
C) Stripe
D) All Of The Above |
|
Definition
|
|
Term
Which of the following is a pool of memory allocated by SQL Server 2000 to store and reuse compiled execution plans?
A) Procedure Cache
B) Redundant Cache
C) Optimized Cache
D) Trace Cache |
|
Definition
|
|
Term
Which of the following is a database engine component that generates efficient execution plans for SQL statements?
A) SP Optimizer
B) Procedure Optimizer
C) Trace Optimizer
D) Query Optimizer |
|
Definition
|
|
Term
Which of the following is a hard drive configuration where multiple physical disk drives are grouped to create a single logical drive?
A) RAID
B) WAID
C) Both A & B
D) None Of The Above |
|
Definition
|
|
Term
Which of the following is a system storage procedure that displays current lock information, including which users hold lock on which database objects?
A) Recompile_Lock
B) SP_Lock
C) Stripe_Lock
D) Trace_Lock |
|
Definition
|
|
Term
Which of the following is a system storage procedure that is used to force the stored procedures and triggers to regenerate more current execution plans?
A) SP_Who
B) SP_Trace
C) SP_Recompile
D) Process_Recompile |
|
Definition
|
|
Term
Which of the following is a system stored procedure that turns information by the current user and process activity?
A) Query_Who
B) SP_Who
C) Trace_Who
D) None Of The Above |
|
Definition
|
|
Term
Which of the following is considered an individual block of data?
A) Array
B) Stripe
C) Parity
D) Page Split |
|
Definition
|
|
Term
Which of the following is a unique number that is used to identify individual processes connected to SQL Server 2000?
A) System process identification number
B) Procedure process identification number
C) Page process identification number
D) Parallel process identification number |
|
Definition
| A) System process identification number |
|
|
