Login

MCSE-Microsoft Certified Solutions Expert Questions

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.

A) Remove the permissions for the local administrator from the printer.

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.

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 & ExplanationAnswer: C) When you rename the root domain server you will lose the entire network orphaning the child domains.

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.

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 & ExplanationAnswer: 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.

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 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.

To achieve optimum functionality of the client computers, you must upgrade all of them to Windows 2000. Upgrading some of them and/or installing the Directory Service Client will gain some functionality, but the question specifically states that "optimum functionality" is the required result.