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;

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:   C) MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?


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


Paint programs keep track of every __________ placed on the screen.

A) Object B) Image
C) Color D) Pixel
Answer & Explanation Answer: D) Pixel

Report Error

View Answer Workspace Report Error Discuss

5 107

Programs from the same developer, sold bundled together, that provide better integration and share common features, toolbars and menus are known as_________ ?

A) integrated software packages B) personal information managers
C) software processing packages D) software suites
Answer & Explanation Answer: D) software suites

Report Error

View Answer Workspace Report Error Discuss

5 116

What do you mean by APM ?


APM is abbreviated as Advanced Power Management, which was developed by Microsoft and Intel as an API. This API is mainly utilised for power management, and is very useful especially to those using Windows on their laptops or desktops.

Report Error

View answer Workspace Report Error Discuss

5 113

Both Joyel and Susy share a Windows 10 tablet with different user accounts. Joyel needs to access some files in Susy’s Documents folder. How can he do this ?

A) Joyel can access the files only if he has administrative rights B) Susy must choose to make the Documents folder Public for Joyel to see them
C) Joyel can, by default, see and access the files in any Documents folder on this computer D) Joyel cannot access those files without Susy moving them to another folder
Answer & Explanation Answer: A) Joyel can access the files only if he has administrative rights

Report Error

View Answer Workspace Report Error Discuss

5 139

You develop an enterprise application, called XYZApplication that includes a Windows Form presentation layer, middle-tier components for business logic and data access, and a Microsoft SQL Server database.

You are in the process of creating a middle-tier component that will execute the data access routines in your application. When data is passed to this component, the component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction.

The code for the middle-tier component will implement the following objects:
SqlConnection cn = new SqlConnection();
SqlTransaction tr;

If two users try to update the same data concurrently, inconsistencies such as phantom reads will occur. You must now add code to your component to specify the highest possible level of protection against such inconsistencies.
Which code segment should you use?

A) tr = cn.BeginTransaction(?ReadCommitted?); B) tr = cn.BeginTransaction(IsolationLevel.ReadCommitted);
C) tr = cn.BeginTransaction(IsolationLevel.Serializable); D) tr = cn.BeginTransaction(?Serializable?);
Answer & Explanation Answer: C) tr = cn.BeginTransaction(IsolationLevel.Serializable);


Serializable is the highest isolation transaction level. It provide the highest possible level of protection against concurrent data errors. The correct syntax to begin a transaction with this transaction isolation level is: cn.BeginTransaction(IsolationLevel.Serializable)

Report Error

View Answer Workspace Report Error Discuss

0 877