Term
Which of the following nodes are transversed to quickly locate specific rows of data?
A) Leaf mode
B) Branch mode
C) Mixed mode
D) Index mode |
|
Definition
|
|
Term
During a(n) ____ records in a foreign key table are automatically deleted when primary key rows are removed.
A) Cascading delete
B) cascading update
C) foreign key update
D) non-cluster update |
|
Definition
|
|
Term
During a(n) ____ changes to a primary key field are automatically made to related foreign key fields.
A) Clustering update
B) Default update
C) Cascading update
D) Extent update |
|
Definition
|
|
Term
Which of the following are user-defined rules that help enforce the integrity of column data?
A) Deadlock
B) Constraints
C) Index
D) Page |
|
Definition
|
|
Term
Which of the following indexes physically sorts and stores the rows of a table?
A) Leaf index
B) Extended index
C) Clustered index
D) Non-clustered index |
|
Definition
|
|
Term
A(n) ____ arises when two users, each having a lock on one piece of data, attempt to acquire a lock on another piece.
A) Domain lock
B) Information lock
C) Page lock
D) Deadlock |
|
Definition
|
|
Term
Which of the following constraints defines a value for a column in a table?
A) Default
B) Domain
C) Extent
D) Index |
|
Definition
|
|
Term
Which of the following represents the valid range of values for a set of data?
A) Extent
B) Domain
C) Foreign Key
D) None of the above |
|
Definition
|
|
Term
Which of the following procedures is implemented in a dynamic link library (DLL) and usually is written in a language like Visual C+ and Visual Basic?
A) Extended stored procedure
B) Foreign stored procedure
C) Mixed stored procedure
D) Cascading stored procedure |
|
Definition
| Extended stored procedure |
|
|
Term
All physical space allocated to tables is done using ____.
A) Indexes
B) Clusters
C) Extents
D) All of the above |
|
Definition
|
|
Term
Using a(n) ____ is a way of enforcing a relationship between tables.
A) Index key
B) Extended key
C) Default key
D) Foreign Key |
|
Definition
|
|
Term
When there is a restriction of rows from a result set, they are said to be ____.
A) Vertically partitioned
B) Horizontally partitioned
C) Non-clustered
D) Cascaded |
|
Definition
| B) Horizontally partitioned |
|
|
Term
A(n) ____ increases the data retrieval performance of SQL Server 2000 by reducing the amount of I/O operations to locate specific rows.
A) Mixed Index
B) Clustered Index
C) Page
D) Index |
|
Definition
|
|
Term
A(n) _____ are individual entries stored in a page and contain a key value and a memory pointer to other pages.
A) Mixed row
B) Extended row
C) Index row
D) All the above |
|
Definition
|
|
Term
Depending on the type of index, a(n) ____ will contain actual data rows or memory pointers to data rows.
A) Page node
B) Mixed node
C) Branch node
D) Leaf node |
|
Definition
|
|
Term
Which of the following ensures transactional integrity and database consistency by preventing users from accessing data being changed by other users?
A) Deadlock
B) Locking
C) Both A and B
D) None of the Above |
|
Definition
|
|
Term
Which of the following houses information from multiple tables or indexes on a page?
A) Non-clustered index
B) Clustered index
C) Mixed extent
D) Clustered extent |
|
Definition
|
|
Term
Which of the following indexes does NOT physically order the data in a table?
A) Clustered index
B) Non-clustered index
C) Index node
D) Page node |
|
Definition
|
|
Term
Which of the following is the smallest unit of storage employed by SQL Server 2000, measuring only 8 KB?
A) Page
B) Leaf node
C) Branch node
D) Domain |
|
Definition
|
|
Term
Which of the following constraints is applied to a column or set of columns in a table to ensure that each row is unique?
A) Primary Key
B) Secondary Key
C) Both A and B
D) None of the Above |
|
Definition
|
|
