MSCE Interview Questions and Answers

QUESTION 7
You work as a network administrator at Mcse.com. The Mcse.com network consists of a single Windows NT 4.0 domain named MCSE . All servers on the Mcse.com network run Windows NT Server 4.0. The Mcse.com network contains three SQL Server 2000 database servers named MCSE -DB01,MCSE -DB02 and MCSE -DB03.You need to configure replication between the three database servers. You configure the MSSQLServer service on all three database servers to use a domain user account named SQLAdmin. You need to ensure that the SQL Server 2000 database servers continue to function properly. What should you do?

A. Assign the SQLAdmin user account the Log on as a service user right.
B. Add the SQLAdmin user account to the Enterprise Admins group in the domain.
C. Configure the MSSQLServer service to run under the local System account.
D. Reset the password for the SQLAdmin 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. Incorrect answers:
B: Adding the SQLAdmin user account to the Enterprise Admins group will not ensure that the SQLServer service will start. The MSSQLServer service must have the Log on as a service right on the local computer.
C: Configuring the MSSQLServer service to run under the local System account will
allow the MSSQLServer service to start but will not allow replication between the three
servers as the local System account cannot access the network.
D: Resetting the password for the SQLAdmin user account is not required.

QUESTION 8
You work as the database administrator at Mcse.com. Mcse.com has a Windows NT 4.0 network. The Mcse.com network contains a database server named MCSE -DB01 that hosts a SQL Server 6.5 database named CKSalesand a SQL Server 7.0 database named CK_Inventory.
You need to upgrade the CK_Sales database to SQL Server 2000. You install a named instance of SQL Server 2000 on MCSE -DB01. You run the SQL Server Upgrade Wizard to upgrade the CK_Sales database to SQL Server 2000. However, the CKSales database is not listed on the Database Selection page of the SQL Server Upgrade Wizard.You need to ensure that the CK_Sales database is listed on the Database Selection page.
What should you do?

A. Upgrade SQL Server 7.0 to SQL Server 2000.
B. Install Service Pack 5 for SQL Server 6.5.
C. Install SQL Sever 2000 on a separate server.
D. Reinstall SQL Server 2000 as a default instance.

Answer: D

Explanation: To run the SQL Server Upgrade Wizard, you must have a default instance of Microsoft SQL Server 2000 installed on the server. Incorrect Answers:
A: It is not necessary to upgrade SQL Server 7.0 to SQL Server 2000. You must install SQL Server as a default instance as you cannot run the SQL Server Upgrade Wizard unless SQL Server 2000 is installed as the default instance.
B: Service Pack 5 for SQL Server 6.5 is required if you want to install SQL Server 2000 as a side-by-side installation. However, you want to upgrade SQL Server 6.5 to SQL Server 2000 sing the SQL Server Upgrade Wizard. You must install SQL Server as a default instance to use the SQL Server Upgrade Wizard.
C: Installing SQL Server 2000 on a separate server will not allow you to use the SQL
Server Upgrade Wizard.


QUESTION 9
You work as the database administrator at Mcse.com. The Mcse.com network consists of a single domain named Mcse.com. All servers on the Mcse.com network run Windows 2000 Server. The Mcse.com network contains three SQL Server 6.5 database servers named MCSE -DB01, MCSE -DB02 and MCSE -DB03. Server Service Pack 3 for SQL Server 6.5 is installed on each database server. In addition to several other databases, MCSE -DB01 hosts a database named CK_Sales which stores sales transactions for the company. Mcse.com wants to upgrade the CKSales database to SQL Server 2000. You decide to perform an in-place upgrade to SQL Server 2000. You run database consistency checks against each database on MCSE -DB01 and then backup the databases. What should you do next? (Each correct answer presents part of the solution.
Choose TWO.)

A. Change the database instances on MCSE -DB01 to named instances.
B. Install Service Pack 4 for SQL Server 6.5 on MCSE -DB01.
C. Install Service Pack 5 for SQL Server 6.5 on MCSE -DB01.
D. First upgrade MCSE -DB01 to SQL Server 7.0.
E. Install the SQL Server instance as the default instance on MCSE -DB01.

Answer: C, E

Explanation: You are only upgrading one database to SQL Server 2000; therefore you will be running SQL Server 6.5 along side SQL Server 2000. You need to install Service Pack 5 for SQL Server 6.5 to support side-by-side installations with SQL Server 2000. Also, the SQL Server 2000 installation must be the default instance as SQL Server 6.5 only recognizes default instances and not named instances. Incorrect answers:
A: SQL Server 6.5 only recognizes default instances and not named instances.
B: The minimum requirement for upgrading to SQL Server 2000 from SQL Server 6.5 is
Service Pack 5.
D: You can upgrade to SQL Server 7.0 and then to SQL Server 6.5 but this is unnecessary as you can upgrade from SQL Server 6.5 Service Pack 5 to SQL Server
2000.

QUESTION 10
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 departments include a Sales department, a Purchasing department, and an Accounts department. The Mcse.com network contains a SQL Server 6.5 database server named MCSE -DB01 and a SQL Server 2000 database server named MCSE -DB02. MCSE -DB02 contains a database named CK_Sales that stores sales data for the company.
The Sales department makes extensive use of the CKSales database. Mcse.com users in the Purchasing department make use of a Microsoft Access database that runs on an application server named MCSE -SR04 while users in the Accounts departments make use of a SQL Server 6.5 database that run MCSE -DB01. The manager of the Accounts department wants to be able to run distributed queries against the CK_Sales database and the databases in the Purchasing and Accounts departments. You must configure the MCSE -SR04 and MCSE -DB01 as linked servers on MCSE -DB02. You need to select the required data sources to create the linked server definitions. What should you do? (Choose all that apply.)

A. Use the OLE DB Provider for Jet as a data source.
B. Use the OLE DB Provider for SQL Server as a data source.
C. Use the OLE DB Provider for ODBC as a data source.
D. Use the OLE DB Provider for DB2 as a data source.

Answer: A, B

Explanation: The Microsoft Access database requires the OLE DB Provider for Jet to communicate with the linked server while the SQL Server 6.5 database requires
the OLE DB Provider for SQL Server.
Incorrect answers:
C: SQL Server 6.0 databases require the OLE DB Provider for ODBC but SQL Server 6.5 databases require the OLE DB Provider for SQL Server.
D: The OLE DB Provider for DB2 is required for IBM DB2 databases.

QUESTION 11
You have just been hired as the database administrator at Mcse.com. Mcse.com currently uses several Microsoft Access databases to store its business information. The Microsoft Access databases are stored on two application servers named MCSE -SR04 and MCSE -SR05.
You have been instructed to migrate some of the Microsoft Access databases on MCSE -SR04 to SQL Server 2000. You must ensure that Mcse.com users can access data in the Microsoft Access databases until all the data has been migrated to SQL Server 2000. During the migration process, Mcse.com users must be able to run distributed queries against the data in both SQL Server 2000 and Microsoft Access. You install SQL Server 2000 on a member server named MCSE -SR06. MCSE -SR06 has limited disk space. What should you do?

A. Configure MCSE -SR04 as a linked server on MCSE -SR06. Configure theOLE DB Provider for Jet as the data source.
B. Configure MCSE -SR04 as a linked server on MCSE -SR06. Configure theOLE DB Provider for SQL Server as a data source.
C. Configure MCSE -SR06 as a linked server on MCSE -SR04. Configure theOLE DB Provider for ODBC as a data source.
D. Configure MCSE -SR06 as a linked server on MCSE -SR04. Configure theOLE DB Provider for SQL Server as a data source.

Answer: A

Explanation: To support distributed queries, you must configure the Microsoft Access database server as a linked server on the SQL database server. Microsoft Access requires the OLE DB Provider for Jet to communicate with the linked server.
Incorrect answers:
B: Microsoft Access requires the OLE DB Provider for Jet to communicate with the linked server, not the OLE DB Provider for SQL Server.
C, D: You cannot create linked servers in Microsoft Access. You must create them in
SQL Server 2000.