MSCE Interview Questions and Answers

QUESTION 12
You work as the database administrator at Mcse.com. Mcse.com has a Windows NT 4.0 network. The Mcse.com network contains a SQL Server 7.0 database server named MCSE -DB01. MCSE -DB01 hosts a database named CK_Data that stores business data for the company. You have been instructed to implement SQL Server 2000 on a new database server named MCSE -DB02. You must configure MCSE -DB01 as a linked server on MCSE -DB02 once SQL Server 2000 has been implemented. Mcse.com users must query only the SQL Server 2000 database. You must ensure that users can perform distributed queries. What should you do?

A. Enable the Named Pipes client Net-Library on MCSE -DB01.
B. Install SQL Server 7.0 client tools and connectivity components on MCSE -DB02.
C. Install SQL Server 2000 client tools and connectivity components on all clientcomputers.
D. Enable the Named Pipes client Net-Library on MCSE -DB02.

Answer: C

Explanation: To enable users to perform distributed queries on the SQL Server 2000 database, you must upgrade the SQL Server 7.0 client tools and connectivity components on their client computers to SQL Server 2000. The SQL Server 2000 client tools and connectivity components support the new features in SQL Server 2000 that were not supported in SQL Server 7.0. Incorrect answers:
A, D: The Named Pipes client Net-Library is not required to allow users to perform distributed queries on the SQL Server 2000 database.
B: SQL Server 2000 client tools and connectivity components are backward compatible with SQL Server 7.0 client tools and connectivity components. Therefore you do not need to install SQL Server 7.0 client tools and connectivity components on MCSE -DB02.

QUESTION 13
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 Server. The Mcse.com network contains a SQL Server 2000 database server named MCSE -DB01, and a Microsoft Exchange Server 5.5 mail server named MCSE -EX01.
(MAPI) is enabled on MCSE -EX01. You configure the SQL Server Agent to log in to Windows 2000 under a user account named SQLAgent when firing alerts. You want the SQL Server Agent service to send an e-mail when an alert is fired. What should you do? (Each correct answer presents part of the solution. Choose TWO.)

A. Add the SQLAgent user account to the Enterprise Admins group.
B. Log on to MCSE -DB01 as SQLAgent.
C. Log on to MCSE -EX01 as SQLAgent.
D. Configure a mail profile for the SQLAgent user account.
E. Configure the mailbox properties for the SQLAgent user account.

Answer: B, D

Explanation: You need to create a mail profile for the SQLAgent user account. You can accomplish this by logging on to the database server as SQLAgent and using the SQL Server Enterprise Manager console to create the mail profile. Incorrect answers:
A: Membership to the Enterprise Admins group is not required to enable SQL Mail.
C: You must create a mail profile for the SQLAgent user account to allow it to send
e-mail. This is performed on the database server and not the mail server.
D: You must create a mail profile for the SQLAgent user account, not the mail box
properties.

QUESTION 14
You work as a network administrator at Mcse.com. The Mcse.com network consists of a single Windows NT 4.0 domain. The Mcse.com network contains a SQL Server 2000 database server named MCSE -DB01, and a Microsoft Exchange Server 5.5 mail server named MCSE -EX01. (MAPI) is enabled on MCSE -EX01. The MSSQLServer and MSSQLServerAgent services on MCSE -DB01 are configured to run under different domain user accounts.
MCSE -DB01 hosts a database named CKSales that is used to store sales related data for the company. You want the MSSQLServerAgent service to send an e-mail to the backup operator when database backup jobs have completed successfully. You configure a mail profile for the MSSQLServerAgent service. You test your solution by backing up the master database on MCSE -DB01. The designated backup operator reports that she has received the e-mail.
Mia Hamm is the manager of the Purchasing department. Mia Hamm wants to be informed whenever changes are made to the Inventory table in the CK_Sales database. You create a trigger to send an e-mail message to Mia Hamm whenever INSERT, UPDATE or UPDATE statements are run against the Inventory table. You configure the trigger to use the xp_sendmail extended stored procedure and configure the Mia Hamm's user account as the designated operator. You test your solution by inserting a row into the CKSales.Inventory table. However, Mia Hamm does not receive an e-mail message. You need to ensure that Mia Hamm receives an e-mail message whenever changes are made to the CKSales.Inventory table. You want to accomplish this task using the least amount of administrative effort What should you do? (Choose all that apply.)

A. Configure the MSSQLServer service and the MSSQLServerAgent service to rununder the local System account.
B. Configure the MSSQLServer service and the MSSQLServerAgent service to rununder the same user account.
C. Configure the MSSQLServer service and the MSSQLServerAgent service to use thesame mail profile.
D. Configure the permissions on MCSE -EX01 to allow multiple connections to theSQL Server mailbox.
E. Configure the permissions on MCSE -EX01 to allow connections from theMSSQLServer service account.

Answer: B, C

Explanation: SQL Server 2000 has two independent mail mechanisms - SQL Mail and SQLServerAgent Mail. SQLServerAgent Mail sends mail messages in response to alerts and jobs while SQL Mail handles stored procedures related to e-mail. Because the two mail mechanisms operate independently, you need to create mail profiles for both mechanisms. The easiest way to accomplish this is to configure the MSSQLServer service to use that same user account and mail profile as the MSSQLServerAgent service.
Incorrect Answers:
A: Configuring the MSSQLServer and MSSQLServerAgent services to run under the local System account will not allow the services to send e-mail messages as the local System account cannot access the network.
D, E: There is no need to configure any permissions on MCSE -EX01 as the MSSQLServerAgent service can send mail successfully. You need to configure the MSSQLServer service to use that same user account and mail profile as the MSSQLServerAgent service.

QUESTION 15
You work as a network administrator at Mcse.com. The Mcse.com network consists of a single Windows 2000 domain named Mcse.com. The Mcse.com network contains 12 Windows 2000 Server computers, 70 Windows 2000 Professional client computers, 45 Windows NT Workstation 4.0 client computers, 20 Windows 98 client computers and 5 Macintosh client computers. The AppleTalk protocol is installed and enabled on the Macintosh client computers. The Mcse.com network also contains a SQL Server 2000 database server named
MCSE -DB01. A default instance and a named instance of SQL Server 2000 are installed on MCSE -DB01. The default instance is configured to use the Named Pipes and TCP/IP Sockets Net-Libraries while the named instance is configured to use the AppleTalk and TCP/IP Sockets Net-Libraries. You add 10 new Novell NetWare client computers to the network. Only the IPX/SPX protocol is installed and enabled on the Novell NetWare client computers.
The Windows-based client computers will only connect to the default instance while the Macintosh and Novell NetWare clients will only connect to the named instance. You need to ensure that the respective client computers can connect to the appropriate instance. You want the minimum number of Net-Libraries enabled on MCSE -DB01.
What should you do? (Choose all that apply.)

A. Enable the Shared Memory Net-Library on the default instance.
B. Enable the Shared Memory Net-Library on the named instance.
C. Disable the TCP/IP Sockets Net-Library on the default instance.
D. Disable the TCP/IP Sockets Net-Library on the named instance.
E. Enable the NWLink IPX/SPX Net-Library on the default instance.
F. Enable the NWLink IPX/SPX Net-Library on the named instance.
G. Enable the AppleTalk Net-Library on the default instance.
H. Disable the Named Pipes Net-Library on the default instance.

Answer: D, F, H

Explanation: To enable that Novell NetWare clients can connect to the named instance, you must enable the NWLink IPX/SPX Net-Library on the named instance.
You should disable the TCP/IP Sockets Net-Library on the named instance as neither the Macintosh nor the Novell NetWare clients require the TCP/IP Sockets Net-Library. You should also configure the default instance to use only the TCP/IP Sockets Net-Library as Windows 98 clients can only use TCP/IP Sockets Net-Library and not the Named Pipes Net-Library. This means you must disable the Named Pipes Net-Library on the default instance.
Incorrect answers:
A, B: Shared Memory is only supported for local database connection on the database
server. It does not support database connections from client computers over the network.
Furthermore, Shared Memory is enabled by default and cannot be disabled.
C: You should also configure the default instance to use only the TCP/IP Sockets
Net-Library as Windows 98 clients can only use TCP/IP Sockets Net-Library and not the
Named Pipes Net-Library. This means you must disable the Named Pipes Net-Library
rather than the Named Pipes Net-Library on the default instance.
E, G: Only the Macintosh and Novell NetWare clients use the AppleTalk and NWLink
SPX/IPX Net-Libraries respectively. As these clients will only connect to the named
instance, the AppleTalk and NWLink SPX/IPX Net-Libraries are not required on the
default instance.

QUESTION 16
You work as a network administrator at Mcse.com. The Mcse.com network consists of a single Windows 2000 Active Directory domain named Mcse.com. All servers on the Mcse.com network run Windows 2000 Server. The client computers run a variety of operating systems, including Windows 98, Windows NT Workstation 4.0, Macintosh and UNIX. Mcse.com wants to implement a SQL Server 2000 database server named MCSE -DB01. MCSE -DB01 will store business information for the company. Some of the business information is of a sensitive nature. To protect the sensitive information, you must secure all network communication between MCSE -DB01 and the Mcse.com client computers. What should you do?

A. Enable SSL encryption on all Net-Libraries and protocols.
B. Configure MCSE -DB01 to use IPSec.
C. Configure MCSE -DB01 to use the only the Multiprotocol Net-Library andenable RPC encryption.
D. Configure MCSE -DB01 to use the only the IP/TCP Sockets Net-Library.Answer: A
Explanation: SQL Server 2000 supports Secure Sockets Layer (SSL) encryption for all protocols and Net-Libraries.
Incorrect answers:
B: IPSec can only be used on TCP/IP and is only supported by Windows 2000. C: The Multiprotocol Net-Library does not support Macintosh clients. D: Using only the IP/TCP Sockets Net-Library will not provide security on its own. It also does not support Macintosh clients.