Microsoft Certification Questions

You are preparing to install Windows 2000 server on a new computer at your office. You want to perform an over-the-network installation. Which method will you use to start the installation ?

A large document contains meeting notes from all meeting that took place between HR and Finance. You need to find all instances of 'derive' or 'dive' or 'dave'. What would be the most efficient way to find these terms using the Find & Replace dialog box?

You want to create and format a simple volume on a Windows 2000 computer. Which tool should you use?

You are the administrator of a SQL Server 2000 computer. You configure SQL Server to perform C2 auditing. Audit logs are saved in the C:MSSQLAudit folder.The server functions normally for several days, but then the MSSQLServer service shuts down without warning. You cannot restart the service.You need to restart the MSSQLServer service. What should you do?

You develop an inventory management application called XYZManagement that will call a Microsoft SQL Server stored procedure named sp_GetDailyXYZSales. The stored procedure will run a query that returns your daily sales total as an output parameter. This total will be displayed to users in a message box.

Your application uses a SqlCommand object to run sp_GetDailyXYZSales. You write the
following code to call sp_GetDailyXYZSales:
SqlConnection cnn = new SqlConnection(myConnString);
SqlCommand cmd = new SqlCommand(“sp_GetDaily XYZ Sales”, cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter prm = cmd.Parameters.Add(“@ItemTotal”,SqlDbType.Int);
prm.Direction = ParameterDirection.Output;
cnn.Open();
cmd.ExecuteNonQuery();

Now you must write additional code to access the output parameter. Which code segment should you use?

You are upgrading your single master Windows NT Server 4.0 network to Windows 2000. Which computer should you upgrade first?

You want to configure synchronization settings for your office files. Which tool should you use?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. The application connects to a Microsoft SQL Server database. The application has two DataTable objects that reference the Customers and Orders tables in the database. The application contains the following code segment. (Line numbers are included for reference only.)

01DataSet customerOrders = new DataSet();
02customerOrders.EnforceConstraints = true;
03ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04customerOrders.Tables["Customers"].Columns["CustomerID"],
05customerOrders.Tables["Orders"].Columns["CustomerID"]);
06
07customerOrders.Tables["Orders"].Constraints.Add(ordersFK);

You need to ensure that an exception is thrown when you attempt to delete Customer records that have related Order records. Which code segment should you insert at line 06?