Term
The Term Database usually refers to a software application that consists of which of the following?
A) Files used to store physical data
B) An application for managing and accessing certain files
C) Both A and B
D) None of the above |
|
Definition
|
|
Term
Which of the following is NOT considered a database management system software package?
A) Microsoft SQL Server 2000
B) Oracle
C) Sybase
D) Access |
|
Definition
|
|
Term
3) The figure shown above depicts which of the following (Customer table and Orders table with the primary key of customer ID)
A) Simple table structure for Northwind DB
B) Relational database for Northwind
C) Occupational structure for Northwind
D) All of the above |
|
Definition
| A) Simple Table Structure For The Northwind DB |
|
|
Term
The figure shown above depicts which of the following? (3 photos - 1 of SQL Server 1 Product Table, SQL Server 2 Product Table, SQL Server 1 Product Table
A) Transact of SQL servers
B) Locking of SQL servers
C) Federated Database Servers
D) Scalability Of Federated servers |
|
Definition
| C) Federated Database Servers |
|
|
Term
______ Allows multiple computers running SQL Server 2000 to run concurrently with a shared set of hard disks that house the database.
A) Entity Clustering
B) Failover Clustering
C) Federation Clustering
D) Replication Clustering |
|
Definition
|
|
Term
If 2 users both attempt to modify the same row in a table at the same time, which of the following is likely to occur?
A) Neither modification will be applied
B) Modifications will be applied on a first-come first serve-basis
C) Both modifications will be applied
D) Both B and C |
|
Definition
|
|
Term
Which of the following would be considered administrative tools included with SQL Server 2000?
A) Enterprise Manager
B) SQL Query Analyzer
C) SQL Profiler
D) All Of The Above |
|
Definition
|
|
Term
Which of the following tools allows an administrator to easily create routines for a given SQL Server?
A) SQL Profiler
B) Import/Export Data
C) SQL Query Analyzer
D) Enterprise Manager |
|
Definition
|
|
Term
Which of the following tools captures events that occur for a particular instance of SQL Server 2000?
A) Import/Export Data
B) SQL Query Analyzer
C) SQL Profiler
D) All of the above |
|
Definition
|
|
Term
Which of the following is NOT considered a security enhancement for SQL Server 2000?
A) Automatic Virus Protection
B) Role based security for the server database and application profiles.
C) Security auditing tools
D) Tracking of 18 different security events and additional sub-events |
|
Definition
| A) Automatic Virus Protection |
|
|
Term
Which of the following systems could be included in a data warehouse?
A) Relational Management
B) Spreadsheet
C) Accounting
D) All of the above |
|
Definition
|
|
Term
Which of the following statements would be considered true for services?
A) They do NOT have a user interface because they perform activities that do NOT require one.
B) They do have a user interface because they perform activities that require one.
C) They are launched when the computer boots up
D) None of the above. |
|
Definition
| A) They do NOT have a user interface because they perform activities that do NOT require one. |
|
|
Term
Which of the following is NOT considered a defined object for the SQL Server Agent?
A) Jobs
B) Alerts
C) Defragmentation
D) Operators |
|
Definition
|
|
Term
Which of the following consists of 1 or more steps to be performed and can be scheduled to execute at regular intervals?
A) Operators
B) Jobs
C) Alerts
D) None of the above |
|
Definition
|
|
Term
Which of the following is an organization of the industry and business groups that develop trade and communication standards for the U.S.?
A) American National Standards Institute
B) American National Standards Alliance
C) American Standard Institute Of Technology
D) None Of The Above |
|
Definition
| A) American National Standards Institute |
|
|
Term
Which of the following is a piece of information that describes a data entry?
A) Kerberos
B) Service
C) Attribute
D) Transaction |
|
Definition
|
|
Term
Using redundant technologies like failover clustering increases which of the following?
A) Scalability
B) Federation
C) Distributed Transactions
D) Availability |
|
Definition
|
|
Term
Which of the following is a single queriable entity that is horizontally partitioned and housed on multiple physical computers?
A) Distributed Partition View
B) Distributed Transactions
C) Federation
D) Transact |
|
Definition
| A) Distributed Partition View |
|
|
Term
Which of the following are transactions that group queries that affect data on multiple servers?
A) Service Transactions
B) Extensible Transactions
C) Distributed Transactions
D) None of the above |
|
Definition
| C) Distributed Transactions |
|
|
Term
Which of the following is considered an object comprised of various pieces of data and stored in a database?
A) Attribute
B) Entity
C) Log
D) Secure socket |
|
Definition
|
|
