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?

You are a Web developer for XYZ. You create an ASP.NET application that accesses sales and marketing data. The data is stored in a Microsoft SQL Server 2000 database on a server named XYZ01.

The company purchases a factory automation software application. The application is installed on XYZ01, where it creates a second instance of SQL Server 2000 named Factory and a database named FactoryDB. You connect to FactoryDB by using Windows Integrated authentication.

You want to add a page to your ASP.NET application to display inventory data from  FactoryDB. You use a SqlConnection object to connect to the database. You need to create a connection string to FactoryDB in the instance of SQL Server named Factory on XYZ01. Which string should you use?

Which message appears when you select Use query drill while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?

A. The Scope of Analysis is empty

B. The query drill mode option is enabled

C. The query drill mode option is not enabled

D. The Scope of Analysis is not empty

What infotype does not have BEGDA or ENDA.

A. IT0014 & IT0015

B. IT0015

C. IT0014

D. None of these

Which one is the correct statement in regards with the use of IT2002

A. To record changes to working time.

B. To record completed working hours with a cost center that deviates from an employees master cost center.

C. Record completed planned working hours.

D. Record planned working times that were not completed.

Which indirect valuation module has to be used for variable bonus between 0 - 8% of basic pay ?

A. TARIFF

B. SUMME

C. PRZNT

D. SUMME and PRZNT

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.

Time wage type selection occurs in subschema...

A.  TC11.

B.  TC10.

C.  TC01.

D.  TC00.