Oracle ODBC connectivity

          

Oracle ODBC connectivity


<<Previous   Next>>
Oracle ODBC connectivity - June 17, 2010 at 12:30 PM by Babu Kunwar
What is ODBC? Explain its purposes

ODBC stands for Open Database Connectivity is an interface written in C program. Oracle ODBC Driver provides a standard interface that allows one application to access many different data sources................
Read Answer

Difference between ODBC and Net8.

ODBC is databasing independent where as NET8 is database dependent...............
Read Answer

What do I need to get ODBC to work?

First we need a client software such as SQL*Net or Net8 on the client machine. There is however 3rd party solutions that provide a "native Oracle OCI driver" that includes Oracle networking within the driver................
Read Answer

Explain how to create a Data Source.

In database terms, a data source is a specific set of data, and we can have one or more data sources active in our application at one time.................
Read Answer

Explain how to trace ODBC calls.

As I have configured this on the UNIX machine I don’t have any idea about Windows. Here are the details of tracing the ODBC call on UNIX platform.................
Read Answer

What is ODBC SQLPASSTHROUGH option?

We use SQLPASSTHROUGH options when we need applications to access data both in the front-end and back-end data servers with a single connection......................
Read Answer

How to attach an Oracle table in MS-Access?

Microsoft Access is part of the Office 2000 suite and has a strong ability to “link” to tables in other databases including Oracle. The connection is done through..................... 
Read Answer

Explain how to get Oracle data into MS-Excel

There are many techniques for doing this. I will present one non-programming technique. Just one thing we need is SQL Developer tool. SQL Developer is a tool which is used for querying Oracle database.................
Read Answer

<<Previous   Next>>
Explain how to start a new transaction in Oracle.

Oracle server implicitly starts a new transaction with the following two conditions: The first executable statement of a new user session automatically starts a new transaction.............

What are transaction isolation levels supported by Oracle?

READ COMMITTED: If row locks are obtained by a certain transaction, then any other transaction that contains DML needs to wait until the row locks have been released by that particular transaction.............

What is snapshot in oracle?

A recent copy of a table or a subset of rows or cols of a table is called as snapshot in oracle. A snapshot is more useful in distributed computing environment. We can create...........



Write your comment - Share Knowledge and Experience


 

 
Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring