Shared Flashcard Set

Details

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

Additional Computer Science Flashcards

 


 

Cards

Term
In a typical production environment, which of the following would be the most optimum situation to have in terms of processor and memory?

A) One Pentium processor and 128MB of RAM
B) Two Pentium processors and 256MB of RAM
C) One Pentium processor and 256MB of RAM
D) Two Pentium processors and 64MB of RAM
Definition
B) Two Pentium processors and 256MB of RAM
Term
When installing the SQL Server components, which of the following options will begin the installation process for the administrative tools and the database engine?

A) Install English Query
B) Install Analysis Services
C) Install Database server
D) None of the above
Definition
C) Install Database server
Term
When installing the SQL Server components, which of the following options will begin the installation process for the data warehousing components of sQL Server 2000?

A) Install English Query
B) Install Analysis services
C) Both A and B
D) None of the above
Definition
B) Install Analysis services
Term
When installing the SQL Server components which of the following options installs a special set of facilities that allows users of SQL Server 2000 to query the database using logical English statements?

A) Install English services
B) Install Analysis services
C) Both A and B
D) None of the above
Definition
A) Install English services
Term
When installing SQL Server, which of the following options is only enabled if an existing instance of SQL server is detected by the setup program?

A) Advanced Options
B) Upgrade/Remove or Add
C) Typical
D) Custom
Definition
B) Upgrade/Remove or Add
Term
When multiple instances of SQL Server 2000 are installed on a single computer, which of the following resources are created for each instance?

A) System and user databases
B) SQL Server and SQL Server Agent Services
C) Registry keys associated with the MSSQL and SQL Server Agent Services
D) All of the above
Definition
D) All of the above
Term
When installing SQL Server 2000, which of the following options will install all of the components of SQL server ans assume the default installation options?

A) Typical
B) Minimum
C) Custom
D) All of the above
Definition
A) Typical
Term
When installing SQL Server 2000, which of the following is only chosen when the hardware limitations prevent the installation of all the components?

A) Typical
B) Minimum
C) Custom
D) None of the above
Definition
B) Minimum
Term
When installing SQL Server 2000, which of the following components allows an administrator to explicitly select components and sub-components as well as customize the collation settings for installation?

A) Typical
B) Minimum
C) Custom
D) None of the abovve
Definition
C) Custom
Term
When installing the program files for SQL Server 2000, which of the following is considered to be true?


A) They are located on the hard drive and the data files are stored on the secondary physical drive.
B) Program files are stored on the secondary physical drive and the data files are stored on the primary hard drive.
C) Both A and B
D) None of the above
Definition
A) They are located on the hard drive and the data files are stored on the secondary physical drive.
Term
Which of the following would be considered server components of SQL Server 2000?

A) Upgrade Tools
B) Replication support
C) Full-Text search
D) All of the above
Definition
D) All of the above
Term
Which of the following components installs a set of programming examples that demonstrate common programming tasks associated with developing applications with SQL Server 2000?

A) Books Online
B) Development tools
C) Code samples
D) Client samples
Definition
C) Code samples
Term
Which of the following components installs tools that are useful when programming applications for SQL Server 2000?

A) Code Tools
B) Client tools
C) Development tools
D) All of the above
Definition
C) Development tools
Term
Which of the following features can only be implemented if the services are configured to use a domain user account?

A) Replication
B) Remote procedure calls
C) Backups to network hard drives
D) All of the above
Definition
D) All of the above
Term
When installing SQL Server 2000, which of the following would be true?

A) It requires a Pentium 166 MHz or higher
B) It requires 64MB of RAM at minimum
C) More disk space will be required depending on the volume of data being stored on or in the user database
D) All of the above
Definition
D) All of the above
Term
Which of the following is NOT supported with main instances of SQL Server 2000 and will NOT be supported in future releases of SQL Server?

A) AppleTalk ADSP
B) Banyan VINES
C) Both A and B
D) TCP/IP
Definition
C) Both A and B
Term
Which of the following is a company that hosts and supports software for its customers or provides an application that can be leased by its customers?

A) Cluster Service Provider
B) Application Service Provider
C) Internet Service Provider
D) Mixed Service Provider
Definition
B) Application Service Provider
Term
Which of the following is a library that supports a special type of client?

A) Banyan VINES
B) Heartbeat
C) NWLink
D) Windows Authentication
Definition
A) Banyan VINES
Term

Which of the following is a term used to refer to shared sets of resources used by a SQL Server fail-over cluster?

 

 

A) Collision group

B) Mixed group

C) Authentication group

D) Cluster group

Definition
D) Cluster group
Term
Which of the following defines bit patterns and represents specific letters, numbers, and symbols?

A) Code page
B) Unicode code
C) Sort code
D) Node
Definition
A) Code page
Supporting users have an ad free experience!