Certification Questions

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 2645
Q:

What is a requirement to connect a V6R1 IBM i host to an XIV Storage System?

A) XIV firmware V10.0.8 B) Host Attachment Kit V1.0.1
C) SAN Volume Controller (SVC)V4.2 D) Virtual I/O Server (VIOS) V2.1.1
 
Answer & Explanation Answer: D) Virtual I/O Server (VIOS) V2.1.1

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2644
Q:

Navigation structure of roadmanps consist of

A. work packages            B. tasks

C. accelerators                D.phases

E. activities

Report Error

View answer Workspace Report Error Discuss

9 2643
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 2643
Q:

If someone in Russia sets their language preference to English, will they see ads targeted to people in Russia? Will their ads be in Russian or in English?

Answer

They will see ads targeted to people located in Russia with the ads in English.

Report Error

View answer Workspace Report Error Discuss

1 2642
Q:

Which IEEE committee has been sanctioned by WAP and is called WPA2?

Answer

The IEEE 802.11i standard has been sanctioned by WPA and is termed WPA version 2.

Report Error

View answer Workspace Report Error Discuss

Subject: CCNA

1 2638
Q:

You want to use a single group to organise users from multiple domains that perform similar job tasks. Which kind of group should you use?

A) Universal group B) Global group
C) Domain Local group D) Built-in special group
 
Answer & Explanation Answer: A) Universal group

Explanation:

Universal groups are used to organize users from multiple domains  that perform similar job tasks or have similar network access requirements, and / or to control access to shared resources in multiple domains.

Report Error

View Answer Report Error Discuss

0 2637
Q:

Which of the statements are true

A. all company codes in the payment run parameters must be in the same country

B. the payment proposal can only be edited, deleted and recreated as often as desired

C. the exception list is a part of the payment proposal

D. a payment method can only be used if it is entered in the account master record

Answer

Answer : A ,B ,C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP FI

0 2631