Term
Which of the following utilities contains the documentation and help files associated with SQL Server 2000 and its various functions?
A) Books Online
B) Client utility
C) Configure SQL utility
D) Enterprise manager |
|
Definition
|
|
Term
Which of the following utilities is used to setup server aliases as well as some more advanced configurations?
A) Configure SQL XML Support
B) Client Network Utility
C) Enterprise Manager
D) Profiler |
|
Definition
| B) Client Network Utility |
|
|
Term
Which of the following utilities is used to configure SQL to accept requests directly over the Internet?
A) Client Network Utility
B) Enterprise Manager
C) Configure SQL XML Support in HS
D) Profiler |
|
Definition
| C) Configure SQL XML Support in HS |
|
|
Term
Which of the following utilities is a robust management tool for administrating and configuring SQL Server 2000 instances?
A) Profiler
B) Enterprise Manager
C) Client Manager
D) All of the above |
|
Definition
|
|
Term
Which of the following utilities invokes the data transformation services DTS Wizard?
A) Enterprise Manager
B) Import and Export Data
C) Profiler
D) Query Analyzer |
|
Definition
| B) Import and Export Data |
|
|
Term
Which of the following utilities can be setup to generate a trace file that records a list of all actions performed against an instance?
A) Enterprise Manager
B) Profiler
C) Query Analyzer
D) All of the above |
|
Definition
|
|
Term
Which of the following utilities is used to design and test T-SQL statements that run against an instance of SQL Server 2000?
A) Profiler
B) Enterprise Manager
C) Query Analyzer
D) All of the Above |
|
Definition
|
|
Term
Which of the following utilities allows an administrator to activate, deactivate, and reconfigure server network libraries used to listen for clients accessing the database over various network protocols?
A) Service Network Manager
B) Server Network Utility
C) Server Group Utility
D) None of the Above |
|
Definition
| B) Server Network Utility |
|
|
Term
Which of the following tools allows the various services associated with SQL Server 2000 to be stopped, started, and paused?
A) Services Manager
B) Services Group
C) Services Analyzer
D) Services Profiler |
|
Definition
|
|
Term
Which of the following default groups is created when Enterprise Manager is installed?
A) Profile Group
B) Services Group
C) Query Group
D) SQL Server Group |
|
Definition
|
|
Term
In order to complete a successful registration of the server, you must supply which of the following pieces of information about an instance?
A) The name of the SQL Server 2000 instance
B) The authentication mode used to connect to the SQL Server
C) The server group within which the new instance will reside in Enterprise Manager
D) All of the Above |
|
Definition
|
|
Term
If the Query Analyzer is NOT started from the Enterprise Manager, which of the following must be specified?
A) Login Information
B) Network Socket Information
C) Network IP Address
D) All of the above |
|
Definition
|
|
Term
Which of the following would be considered a time saving feature of the Query Analyzer?
A) Automatic object based scripts
B) Templates
C) Both A and B
D) Automatic Execute Query |
|
Definition
|
|
Term
A(n) ____ provides skeleton statements for creating objects in a database as well as performing management functions.
A) Object-based script
B) Template
C) Server Utility
D) Server Group |
|
Definition
|
|
Term
A(n) ____ is used to generate the syntax for performing inserts, updates, and deletes on particular tables in a database.
A) Templates
B) Object-based scripts
C) Server utility
D) Server group |
|
Definition
|
|
Term
Which of the following tabs displays the various software and hardware properties of the computer on which SQL Server 2000 is installed?
A) Security
B) Connection
C) Memory
D) General |
|
Definition
|
|
Term
Which of the following would be considered a default start up option for SQL Server?
A) -dmaster_file_path
B) -eerror_log_path
C) -lmaster_log_path
D) All of the above |
|
Definition
|
|
Term
Which of the following would be considered the fully qualified path of the master database file?
A) -emaster_file_path
B) -dmaster_file_path
C) -lmaster_log_path
D) -master_path_log |
|
Definition
|
|
Term
Which of the following would be the fully qualified path for an error log file in SQL Server?
A) -lerror_log_path
B) -elog_path_error
C) -eerror_log_path
D) None of the above |
|
Definition
|
|
Term
Which of the following startup options reduces startup time by starting an instance of SQL Server 2000 independently of the Service Control Manager?
A) -f
B) -m
C) -x
D) -c |
|
Definition
|
|
