Term
Which of the following is NOT a SQL Server 2000 instance that is necessary for SQL Server to operate?
A) Master
B) Network
C) Model
D) MSDB |
|
Definition
|
|
Term
Which of the following file types is NOT supported by SQL Server 2000?
A) Primary Data Files
B) Secondary Data Files
C) Quantitative Data Files
D) Log Files |
|
Definition
| C) Quantitative Data Files |
|
|
Term
Which of the following statements is true concerning SQL Server 2000 databases?
A) They Are Created Using Enterprise Manager
B) They are created using T-SQL Statements
C) Both A&B
D) None of the above |
|
Definition
|
|
Term
To increase the file sizes for databases using SQL Enterprise Manager, you would do which of the following?
A) Right-click on the database and choose Properties from the context sensitive menu.
B) Left-click on the database and choose General from context sensitive menu.
C) Right-click on the database and choose Security from the context sensitive menu.
D) Left-click on the database and choose Security from the context sensitive menu. |
|
Definition
| B) B) Left-click on the database and choose General from context sensitive menu. |
|
|
Term
Which of the following is a true statement concerning automatic database shrinking?
A)Shrinking occurs as a background process and should NOT affect normal usage.
B) Shrinking occurs as a foreground process and will affect normal usage.
C)Shrinking occurs as a foreground process and will NOT affect normal usage.
D) Shrinking occurs as a background process and will affect normal usage. |
|
Definition
| A) Shrinking occurs as a background process and should NOT affect normal usage. |
|
|
Term
Each database has a set of options that govern its behavior. You can modify many of these database options by using which of the following?
A) The Security settings box in the SQL Enterprise Manager
B) The Database Properties box in the SQL Enterprise Manager
C) The General Tab in the SQL Enterprise Manager
D) None of the Above |
|
Definition
| B) The Database Properties box in the SQL Enterprise Manager. |
|
|
Term
Which of the following is NOT considered a database option?
A) Read-Only
B) Auto-Update Statistics
C) Write-Only
D) Compatibility |
|
Definition
|
|
Term
The figure shown above depicts which of the following? (Photo Of the Default E.M. view)
A) Database File Manager
B) Database Objects
C) Database Security Settings
D) Database Network Settings |
|
Definition
|
|
Term
Which of the following are rules created for database objects?
A) The first letter of the name must be a letter, underscore, @, or # signs.
B)The rest of the name must follow the first letter rules but may also include numbers.
C) No Spaces Allowed
D) All Of The Above |
|
Definition
|
|
Term
To view information about an object in the database with SQL Enterprise Manager, you would do which of the following?
A) Expand your database by left-clicking on the plus sign next to the database name.
B) Expand your database by right-clicking on the plus sign next to the database name.
C) Expand your database by right-clicking on the minus sign next to the database name.
D) Expand your database by left-clicking on the minus sign next to the database name |
|
Definition
| A) Expand your database by left-clicking on the plus sign next to the database name. |
|
|
Term
To rename an object with SQL Enterprise Manager, you would do which of the following?
A) Expand your database by right-clicking on the plus sign next to the database name.
B)Expand your database by left-clicking on the plus sign next to the database name.
C)Expand your database by right-clicking the minus sign next to the database name.
D)Expand your database by left-clicking the minus sign next to the database name. |
|
Definition
| B) Expand your database by left-clicking on the plus sign next to the database name. |
|
|
Term
Stored procedures are compiled groups of T-SQL statements that are processed as a(n) ____.
A) Single Unit Of Operations
B) Double Unit Of Operations
C) Both A & B
D) None Of The Above |
|
Definition
| A) single unit of operations |
|
|
Term
Which of the following is configured to fire after data modification statements are run?
A) Database Trigger
B) System Trigger
C) Fill Trigger
D) After Trigger |
|
Definition
|
|
Term
Which of the following is a logical collection of data and objects that are used to support maintenance and use of that data?
A) Model File
B) Regular Identifier
C) Database
D) Scale |
|
Definition
|
|
Term
Which of the following filegroups has space allocated when a table or index does NOT explicitly define that group?
A) Default Filegroup
B) Delimited Filegroup
C) Extended Filegroup
D) Primary Filegroup |
|
Definition
|
|
Term
Which of the following are names that do NOT follow the rules of regular identifiers?
A) Extended identifiers
B) System Identifiers
C) Secondary Identifiers
D) Delimited Identifiers |
|
Definition
|
|
Term
Which of the following is a user-defined name to value associated with an object in database?
A) Secondary Property
B) Extended Property
C) System Property
D) Master Property |
|
Definition
|
|
Term
Which of the following is considered physical and stores a database transaction log?
A) Factor
B) GUID
C) File
D) None Of The Above |
|
Definition
|
|
Term
The named grouping of one or more physical data files is commonly called what?
A) Regular Files
B) Filegroups
C) Scale Files
D) All Of The Above |
|
Definition
|
|
Term
Which of the following is the amount of space left in an index page to account for future growth?
A) Primary Factor
B) Extended Factor
C) Fill Factor
D) Scale Factor |
|
Definition
|
|
