ODBC identifies two types of drivers: single tier and multiple-tier.

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?);

JDBC Type 1 drivers are JDBC-ODBC bridge drivers.

A

True

B

False

Two statements are given, followed by three conclusions numbered I, II and III. Assuming the statements to be true, even if they seem to be at variance with commonly known facts, decide which of the conclusions logically follow(s) from the statements. Statements: All equipments are screw-drivers. All machines are equipments. Conclusions: I. Some screw-drivers are equipments. II. Some screw-drivers are machines. III. All equipments are machines.

A

All conclusions follow.

B

Only conclusions II and III follow.

C

Only conclusions I and II follow.

D

Only conclusions I and III follow.

Consider the given statements to be true and decide which of the conclusion(s) logically follows these statements. Statement: 1. All chefs are drivers. 2. No drivers are gardeners. Conclusion: I. No chefs are gardeners. II. Some drivers are chefs.

A

Both conclusion I and conclusion II follow.

B

Neither conclusion I nor conclusion II follow.

C

Only conclusion I follows.

D

Only conclusion II follows.

When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?

A

Data source

B

Driver

C

Driver manager

D

DBMS

An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.

A

True

B

False

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?

A

Data source

B

Driver

C

Driver manager

D

OLE DB

Given below are certain committees related to Panchayati Raj System in India and their recommendations. Match the two correctly. Committee Recommendation G.V.K Rao Committee Constitutional recognition of local self-government. L.M Singhvi Committee The Zila Parishad should be the principal body in the Panchayati Raj System of India. Ashok Mehta Committee Three-tier system of Panchayati Raj Institutions. Balwant Rai Mehta Committee Two-tier system of Panchayati Raj Institutions.

A

i-c, ii-b, iii-a, iv-d

B

i-b, ii-a, iii-d, iv-c

C

i-b, ii-a, iii-c, iv-d

D

i-a, ii-c, iii-b, iv-d

Two statements are given, followed by two conclusions numbered I and II. Assuming the statements to be true, even if they seem to be at variance with commonly known facts, decide which of the conclusions logically follow(s) from the statements. Statements: A. Some drivers are racers. B. Some racers are pilots. Conclusions: I. Some pilots are drivers. II. No pilot is a driver

A

Only conclusion II follows

B

Only conclusion I follows

C

Neither conclusion I nor II follows

D

Either conclusion I or II follows

An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):

A

data source.

B

driver manager.

C

driver.

D

API.

ODBC identifies two types of drivers: single tier and multiple-tier.

Related Questions