# MCSE-Microsoft Certified Solutions Expert Questions

Q:

As a network administrator you have been requested to move a printer from your company's Marketing OU to your company's Research OU. After the move you test the printer and find that the local administrator assigned to the Marketing OU still has access and can remove print jobs from it. What can you do to change this?

 A) Remove the permissions for the local administrator from the printer. B) Remove printer permissions from the local administrator. C) Remove the Everyone group from the printer. D) Delete the printer object.

Explanation:

6 6020
Q:

You recently been promoted to Network Administrator for DLM Shipping. When you took over this position the first thing you notice is this Windows 2000 environment using DNS naming convention, root domain is DIM.COM, with numerous child domains. User accounts are stored in the child domains. However your supervisor informs you that root domain is misspelled and should be DLM.COM. He explains this is causing tremendous problems with the users and customers. He wants you to rename the domain. What will happen if you rename this root domain server?

 A) When you rename the root domain server you will only have to rebuild the user accounts since the root domain holds the authentication (SAM) database. B) When you rename the root domain server you will simply rename the child domain also. C) When you rename the root domain server you will lose the entire network orphaning the child domains. D) When you rename the root domain server you will not need to do anything else since domain names are inherited the child domains will acquire the new domain name.

Answer & Explanation Answer: C) When you rename the root domain server you will lose the entire network orphaning the child domains.

Explanation:

7 4623
Q:

How many-shares of market value RS.25 each can be purchased for Rs.12750, brokerage being 2% ?

 A) Rs.450 B) Rs.500 C) Rs.550 D) Rs.600

Explanation:

CP. of each share= Rs.(25 + 2% of 25) = Rs.25.50.

Number of shares= $1275025.50$= 500

0 4441
Q:

Which hardware platform (or platforms) are supported by Windows 2000?

 A) The Intel Pentium/ 166MHZ (and higher) platform B) The Compac Alpha platform C) The PowerPC platform D) The MIPS R4000 platform

Answer & Explanation Answer: A) The Intel Pentium/ 166MHZ (and higher) platform

Explanation:

The Intel Pentium/166MHz (and higher) platform is the only hardwaer platform supported by Windows 2000.

0 3611
Q:

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database has a Parts table that has a field named InStock.When parts are shipped, a table named PartsShipped is updated. When parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit. (Click the Exhibit button.)

You want the database to update the InStock field automatically. What should you do?

 A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table. B) Use a view that creates anInStock field as part of an aggregate query. C) Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock field in the Parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables. D) Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.

Answer & Explanation Answer: A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.

Explanation:

Triggers are a special class of stored procedure defined to fire automatically when an UPDATE, INSERT, or DELETE statement is issued against a table or view. They are powerful tools that can be used to enforce business rules automatically when data is modified. Triggers can extend the integrity checking logic of SQL Server constraints, defaults, and rules, although constraints and defaults should be used instead whenever they provide all the needed functionality. In this scenario an AFTER UPDATE trigger can be used to update the tables to update the PartsShipped and the PartsReceived tables that update the InStock column in the parts table.

0 3572
Q:

You create a mirrored volume on a Windows 2000 Server computer. What additional item should you create?

 A) A new Config.nt file B) A new Auto exec.nt file C) A fault tolerance boot disk D) A set of Windows 2000 Setup Boot Disks

Explanation:

A fault tolerance boot disk is a floppy disk that you create that enables you to boot your Windows 2000 computer in the event that the first disk in your computer's mirrored volume fails. This disk contains an edited copy of the Boot.ini file.

0 2913
Q:

You are installing Windows 2000 on a computer that already has another operating system installed on it. You choose to install Windows 2000 in a different folder than the previously installed operating system. What will Windows 2000 do?

 A) Wireless devices B) Multiple displays C) Advanced Power Management (APM) D) Uninterruptible Power Supplies (UPSs)

Explanation:

Of the four features listed, all are supported on both Windows 2000 Professional and Windows 2000 Server Computers except APM. APM is only supported on Windows 2000 Professional computers.

0 2875
Q:

You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information.BULK INSERT finance.dbo.customersFROM 'd:bulkaccts143_10142000.txt'WITH DATAFILETYPE = 'char', FIELDTERMINATOR = 't', ROWTERMINATOR = 'n', TABLOCK You want to ensure that response times do not slow when new account information is added to the database. What should you do?

 A) Add the BATCHSIZE option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded. B) Add the ROWS_PER_BATCH option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded. C) Drop the indexes for the Customers table before the data load, and then re-create the indexes after the data load is complete. D) Remove the TABLOCK option from the BULK INSERT statement.

Answer & Explanation Answer: D) Remove the TABLOCK option from the BULK INSERT statement.

Explanation:

The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.

Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.