Sawaal
  • Home/
  • Searching for 5%

 Searching for "5%"

Q:

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. The application connects to a Microsoft SQL Server 2008 database. The database includes a table named dbo.


Documents that contains a column with large binary dat a. You are creating the Data Access Layer (DAL). You add the following code segment to query the dbo.Documents table. (Line numbers are included for reference only.)


01public void LoadDocuments(DbConnection cnx)
02{
03var cmd = cnx.CreateCommand();
04cmd.CommandText = "SELECT * FROM dbo.Documents";
05...
06cnx.Open();
07
08ReadDocument(reader); }


You need to ensure that data can be read as a stream. Which code segment should you insert at line 07?

A) var reader = cmd.ExecuteReader(CommandBehavior.Default); B) var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
C) var reader = cmd.ExecuteReader(CommandBehavior.KeyInfo); D) var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
 
Answer & Explanation Answer: D) var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSD-Microsoft Certified Solutions Developer

Q:

You are creating an ASP.NET application for XYZ. The company data is stored in a Microsoft SQL Server 6.5 database. Your application generates accounting summary reports based on transaction tables that contain million of rows.


You want your application to return each summary report as quickly as possible. You need to configure your application to connect to the database and retrieve the data in a away that achieves this goal.


What should you do?

A) Use a SqlConnection object to connect to the database, and use a SqlCommand object to run a stored procedure that returns the data. B) Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.
C) Configure SQL Server to support HTTP access, and create an XML template to run a stored procedure that returns the data in XML format. D) Use COM interop to create an ADODB.Connection object, and use an ADODB.Command object to run a SQL statement that returns the data.
 
Answer & Explanation Answer: B) Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.

Explanation:

We need to use an OleDBConnection to connect to SQL Server Version 6.5 (or earlier). 

 

Incorrect Answers:

 

A: We could use a SqlConnection object only if the SQL Server were SQL Server 7.0, 2000 or later.

 

C: HTTP functionality is not required in this scenario. It would introduce unnecessary overhead.

 

D: ADODB is a legacy standard and should not be used here

Report Error

View Answer Report Error Discuss

Filed Under: MCSD-Microsoft Certified Solutions Developer

Q:

Suppose a customer is planning to create a non-hosted Linux partition on an i825. Linux will have only direct-attach devices. What is the Linux console option?

A) Use OS/400 VNC support. B) Telnet to the virtual console.
C) Share the primary partitions console. D) Allocate a console IOA to the Linux partition.
 
Answer & Explanation Answer: B) Telnet to the virtual console.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

The following transactions are relevant to the data sources in an SAP BW source system.

A. RSA4

B. RSA5

C. RSA6

D. RSA3

Answer

Answer : B , C , D


 


Explanation :  Transaction RSA3, or extractor checker, is used in the BW source system to check data sources for various extraction modes, including full update, delta update and delta initialization.

RSA5 is for installing standard business content data sources and RSA6 is for maintaining data sources.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

What infotype does not have BEGDA or ENDA.

A. IT0014 & IT0015

B. IT0015

C. IT0014

D. None of these

Answer

Answer : B

Report Error

View answer Workspace Report Error Discuss

Subject: SAP HR

Q:

Payroll schema consists of a sequence of functions. Which of these functions is used to import Absence infotype data?

A. PAB.

B. PIT.

C. P0015.

D. RAB.

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP HR

Q:

Out of the 5 phases of the ASAP methodology, for which phase does the Solution Manager NOT provide any tasks (or taskgroups).

A. Evaluation phase

B. Final Preparation phase

C. Business Blueprint

D. Project preparation phase

Answer

Answer : B

Report Error

View answer Workspace Report Error Discuss

Subject: SAP Solution Manager

Q:

Excluding the Continuous improvement phase, how many phases are there in the Accelerated SAP roadmap

A. 4                        B. 6

C. 5                        D. 3

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP Solution Manager