Shared Flashcard Set

Details

CIT 171 - SQL Server 2000 Chapter 3
CIT 171 - Columbus State Comm College - Test Questions Bank 1
20
Computer Science
Undergraduate 2
10/20/2010

Additional Computer Science Flashcards

 


 

Cards

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
A) Books Online
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
B) Enterprise Manager
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
B) Profiler
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
C) Query Analyzer
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
A) Services Manager
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
D) SQL Server Group
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
D) All of the above
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
A) Login Information
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
C) Both A and B
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
B) Template
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
B) Object-based scripts
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
D) General
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
D) All of the above
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
B) -dmaster_file_path
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
C) -eerror_log_path
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
D) -c
Supporting users have an ad free experience!