MSCE Interview Questions and Answers

Installing, Configuring and AdministeringMicrosoft SQL Server 2000, Enterprise Edition

QUESTION 1
You work as a system administrator at Mcse.com. All servers on the Mcse.com network run Windows 2000 Server. All client computers run either Windows 98 or Novel NetWare. Your duties include administrating a member server named Mcse -SR07.You must install SQL Server 2000 on Mcse -SR07 and create a database named CK_Data. You need to ensure that all Windows 98 and Novell NetWare client computers can connect to the CK_Data database using the Named Pipes nd IPX/IPX Net-Libraries respectively. You need to configure the client computers to connect to the CK_Data database using the minimum number of configuration changes on the client computers.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)

A. Configure the new instance to use Mixed Mode Authentication.
B. Configure the new instance to use Windows Authentication.
C. Configure the new instance to use SQL Server Authentication.
D. Configure Mcse -SR07 to use the Named Pipes and IPX/SPX Net-Libraries.
E. Configure Mcse -SR07 to use the Multiprotocol Net-Library.
F. Configure Mcse -SR07 to use the Shared Memory Net-Library.

Answer: A, D

Explanation: The client computers in this scenario will be running Windows 98 and Novel NetWare. Novell NetWare clients are not supported by Windows Authentication; however SQL Server Authentication should only be used for backward compatibility. Hence you should use Mixed Mode Authentication. By using specific communication protocols, and not the Multiprotocol Net-Library, performance would be better. Every extraneous protocol adds overhead. Incorrect Answers:
B: As client computers will be running Windows 98 and Novel NetWare, you cannot use Windows Authentication as Novel NetWare systems are not supported by Windows Authentication.
C: SQL Server Authentication should only be used for backward compatibility. Hence you should use Mixed Mode Authentication.
E: The Multiprotocol Net-Library is used to support the different protocol that the clients use. This provides easy of administration. However, since unused protocols are installed, it also introduces overhead. This is not the best solution.
F: Shared Memory is only supported for local database connection on the database
server. It does not support database connections over the network.

QUESTION 2
You work as the database administrator at Mcse.com. The Mcse.com network consists of a single Windows 2000 domain named Mcse.com. All servers on the Mcse.com network run Windows 2000 Advanced Server. The Mcse.com network contains a SQL Server 2000 database server named MCSE-DB01. MCSE-DB01 is a production server and hosts a database named CK_Sales which stores sales transactions for the company. Mcse.com has database application developer named Rory Allen who uses a Windows 2000 Professional client computer named MCSE-WS228. Rory Allen needs to test a database application on MCSE-DB01. You install a separate a SQL Server 2000 instance named RA_Test on MCSE-DB01. You need to ensure that Rory Allen can connect to the RA_Test instance. What should you do?

A. Configure the RA_Test instance to use the Named Pipes Net-Library.
B. Configure the RA_Test instance to use the Multiprotocol Net-Library.
C. Configure the RA_Test instance to use the NWLink IPX/SPX Net-Library.
D. Configure the RA_Test instance to use the Shared Memory Net-Library.

Answer: A

Explanation: Windows 2000 Professional can use the TCP/IP Sockets and Named Pipes Net-Libraries by default. Incorrect Answers:
B: The Multiprotocol Net-Library can only be used to connect to a default instance of SQL Server 2000 as it does not support named instances of SQL Server 2000.

C: The NWLink IPX/SPX Net-Library is used to support Novell NetWare clients.

D: Shared Memory is only supported for local database connection on the database server. It does not support database connections over the network.

QUESTION 3
You work as the database administrator at Mcse.com. The Mcse.com network consists of a single Windows 2000 domain named Mcse.com. The Mcse.com network contains a SQL Server 7.0 database server named MCSE-DB01 that runs on Windows NT Server 4.0. MCSE-DB01 is a production server and hosts several databases for the company. You install SQL Server 2000 as the default instance on a new database server named MCSE-DB02. Certkiller -DB02 runs Windows 2000 Server.Mcse.com users in the Accounts department must have direct access to the databases on both MCSE-DB01 and MCSE-DB02. The users in the Accounts department use client computers that run Windows 2000 Professional. You need to encrypt the network communication between the Accounts department users' client computers and the database servers.What should you do?

A. Configure the client computers to use the Named Pipes Net-Library.
B. Configure the client computers to use the Multiprotocol Net-Library.
C. Configure the client computers to use the TCP/IP Sockets Net-Library.
D. Configure the client computers to use the Shared Memory Net-Library.

Answer: B

Explanation:
Windows 2000 Professional can use the TCP/IP Sockets, Multiprotocol and Named Pipes Net-Libraries by default. However, only the Multiprotocol Net-Library supports remote procedure call (RPC) encryption. RPC encryption is required because SQL Server 7.0 only supports RPC encryption. Incorrect Answers: A, C: Although the Windows 2000 Professional client computers can use the TCP/IP Sockets and Named Pipes Net-Libraries by default; and the TCP/IP Sockets and Named Pipes Net-Libraries support Secure Socket Layer (SSL), SQL Server 7.0 only supports remote procedure call (RPC) encryption which is only supported by the Multiprotocol Net-Library.D: Shared Memory is only supported for local database connection on the database server. It does not support database connections over the network. Reference:

QUESTION 4
You work as the database administrator at Mcse.com. The Mcse.com network consists of a single Windows 2000 domain named Mcse.com. All servers on the Mcse.com network run on Windows 2000 Server while the client computers run Windows 2000 Professional, Windows 98, and Novell NetWare. All computers are members of the Mcse.com domain. The Mcse.com network contains a SQL Server 2000 database server named MCSE -DB01 that hosts a default instance of SQL Server 2000. Mcse.com wants to implement another SQL Server 2000 instance for a database named SalesDB. SalesDB will store sales data for the company. All Mcse.com users will require access to the Sales_DB database. You have been instructed to create the SQL Server 2000 instance for the Sales_DB database. You need to ensure that all users will be able to connect to the SalesDB database. You cannot make configuration changes to the client computers. Your solution must optimize network traffic.
What should you do?

A. Install the instance as a named instance and configure it to support Mixed Mode Authentication. Then enable the NWLink IPX/SPX Net-Library for the instance.
B. Install the instance as a default instance and configure it to support WindowsAuthentication. Then enable the TCP/IP Sockets Net-Library for the instance.
C. Install the instance as a Named Instance and configure it to support SQL ServerAuthentication. Then enable the IPX/SPX for the instance.
D. Install the instance as a default instance and configure it to support WindowsAuthentication. Then enable the TCP/IP Sockets Net-Library for the instance.

Answer: A

Explanation: The default instance is already in use; therefore you should use a Named Instance as only one instance can be the default instance. You should use Mixed Mode Authentication and enable the NWLink IPX/SPX Net-Library to support Novell NetWare users. Incorrect answers:
B: You cannot use the default instance as the default instance as it is already in use. Furthermore, you need to use Mixed Mode Authentication as Windows Authentication does not support Novell NetWare users and you need to enable the NWLink IPX/SPX Net-Library to support Novell NetWare users.
C: SQL Server Authentication is supported for backward compatibility and is not
recommended for use. You should rather use Mixed Mode Authentication.
D: You cannot use the default instance as the default instance as it is already in use.
Furthermore, you need to use Mixed Mode Authentication as Windows Authentication
does not support NetWare users. Furthermore, you need to enable the NWLink IPX/SPX
Net-Library to support Novell NetWare users.

QUESTION 5
You work as a network administrator at Mcse.com. The Mcse.com network consists of a single Windows 2000 forest. The Mcse.com forest has a single root domain named Mcse.com. All servers on the Mcse.com network run Windows 2000 Server. The Mcse.com network contains a member server named MCSE -SR12. You install SQL Server 2000 on MCSE -SR12 and configure the MSSQLServer service to run under a domain user account named SQLAdmin in the Mcse.com root domain. You add the SQLAdmin account to the Enterprise Admins group. You start MCSE -SR12 but the MSSQLServer service does not start. You need to ensure that the MSSQLServer service starts. What should you do?

A. Configure the MSSQLServer service to run under the local System account onMCSE -SR12.
B. Add the SQLAdmin user account to the Domain Admins group in the Mcse.comroot domain.
C. Add the Enterprise Admins group to the Domain Admins group in the Mcse.comroot domain.
D. Configure the MSSQLServer service and the MSSQLServerAgent service to rununder the same user account.

Answer: A

Explanation: The MSSQLServer service must have the Log on as a service right on the local computer. You have created a user account for the SQLServer service but this service does not have the Log on as a service right on the local computer. You can resolve the problem by having the MSSQLServer service use the local System account.

Incorrect answers:
B, C: Adding the SQLAdmin user account or the Enterprise Admins group to the Domain Admins group will not ensure that the SQLServer service will start. TheMSSQLServer service must have the Log on as a service right on the local computer. D: The MSSQLServer and MSSQLServerAgent services usually run under the same user account to reduce administrative overhead; however, the MSSQLServer service must have the Log on as a service right on the local computer before it will start.