Certification Questions

Q:

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

A) Disk Administrator B) Disk Management
C) The Convert.exe command -line utility D) The Format.exe command-line utility
 
Answer & Explanation Answer: B) Disk Management

Explanation:

Windows 2000 includes a powerful tool to manage disks - it's called Disk Management. You can use Disk Management to create and manage several different volume types on a Windows 2000 computer.

Report Error

View Answer Report Error Discuss

1 2287
Q:

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?

A) MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].Value.ToString()); B) MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].ToString());
C) MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal? D) MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?
 
Answer & Explanation Answer: C) MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?

Explanation:

The @ItemTotal parameter is declared as an output parameter with SQL Server data type INT.We use the Value property of the SQLParameter class to retrieve the value of this parameter. We must also convert the INT value to a string value with the ToString method. We then supply this string to the MessageBox.Show method. 

 

Incorrect Answers


Option A, B:
The @ItemTotal parameter is the output parameter. Using @Output this way is incorrect. Output is a keyword and no variable named @Output has been declared.


Option D:
We must use the Value method to retrieve the value of the parameter..

Report Error

View Answer Report Error Discuss

1 2287
Q:

What is the effect of including both keywords and placements in an Ad Group on the Display Network?

Answer

Your ads will be restricted to only specific sites that you choose and webpages where the content is relevant to the theme of the keywords.

Report Error

View answer Workspace Report Error Discuss

0 2279
Q:

Project authorization is one of the processes that is associated with the initiation phase of a project. Authorization can come in many different forms, and projects are generally authorized by all of the following except

A) Technological Advances B) Customer request or market demand
C) Executive year - end bonuses D) Business or Social needs
 
Answer & Explanation Answer: C) Executive year - end bonuses

Explanation:

Project authorization should not be exclusively based upon the impact of an executive's bonus (many people would agree that it should not ever be based upon an executive's bonus). Answer A, B, and D are common events that predicate the need for project authorization and can evolve into large scope projects.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

0 2276
Q:

Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Service Pack 3 (SP3). You install and configure Microsoft Windows Server Update Services (WSUS) 3.0 on a member server named Server1. You create a new Group Policy Object named GPO1 that enables automatic updating. You link GPO1 to the domain. You need to ensure that each client computer obtains software updates from Server1. What should you do?

A) On each client computer, run Gpupdate /Force. B) On each client computer, run wuauclt /detectnow.
C) From GPO1, configure the Enable client side targeting setting. D) From GPO1, configure the Specify intranet Microsoft update service location setting.
 
Answer & Explanation Answer: D) From GPO1, configure the Specify intranet Microsoft update service location setting.

Explanation:
Report Error

View Answer Report Error Discuss

3 2273
Q:

Which statement correctly changes the next extent size?

A) ALTER TABLE customer MODIFY NEXT SIZE 300 B) ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300
C) ALTER TABLE customer MODIFY EXTENT SIZE 300 D) ALTER TABLE customer NEXT SIZE 300
 
Answer & Explanation Answer: A) ALTER TABLE customer MODIFY NEXT SIZE 300

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

2 2271
Q:

Why is BGP a better choice for Internet routing than the IGPs?

Answer

RIP version 1 and IGRP are classful protocols and do not advertise subnet mask information. RIP version 2 has a limited network diameter of 15 hops. EIGRP, OSPF, and IS-IS use computational intensive algorithms for determining a shortest path. BGP relies on simple techniques for best path selection and loop detection, and can handle the number of network prefixes required for Internet routing.

Report Error

View answer Workspace Report Error Discuss

Subject: CCNP

3 2271
Q:

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

A) The stand-alone server in the Windows NT 4.0 domain that will become the root domain in your Windows 2000 network B) The primary domain controller (PDC) in the Windows NT 4.0 domain that will become a child domain in your Windows 2000 network
C) The backup domain controller (BDC) in the Windows NT 4.0 domain that will become a child domain in your Windows 2000 network D) The Primary domain controller (PDC) in the Windows NT 4.0 domain that will become the root domain in your Windows 2000 network
 
Answer & Explanation Answer: D) The Primary domain controller (PDC) in the Windows NT 4.0 domain that will become the root domain in your Windows 2000 network

Explanation:

When upgrading from a Windows NT 4.0 single master domain model to windows 2000, the first computer you should upgrade is the PDC of the Windows NT 4.0 domain that will become the root domain of your Windows 2000 network.

Report Error

View Answer Report Error Discuss

0 2270