Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1789)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 21188

What is the difference between SQL, DDL, and DML?

BeBo Technologies, Wipro,

7 69147

What are inner join and outer join?

3 11388

What are joins..how many types of joins are there?

Amdocs, CSC, TCS,

29 74787

what are Triggers?

TCS,

7 13172

what are stored procedures?

TCS, Wells Fargo,

7 11583

what are indexes..how many types of index's are there and what are they?

Green Info Solutions, TCS,

7 16218

what are views?

TCS,

8 18628

what is the difference between oracle 81,91,11i

i2, Oracle,

2 17224

How client makes connection with server in client/server architecture?

CA,

1 4363

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 4988

For web applications from which version of Oracle is suitable?

1 4454

What are the main diff. between oracle 7.3 and oracle 8i?

1 4313

What is Statement Auditing ?

2 3892

What are the use of Roles ?

3 4542

Un-Answered Questions { Oracle }

Is rowid unique in oracle?

431

Oracle

1719

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1700

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1524

types of indexes and the rationale behind choosing a particular index for a situation.

1840

What are the tools for Oracle ?

508

What are the major difference between truncate and delete?

428

What is the finger command?

232

Why does Oracle not permit the use of PCTUSED with indexes?

1847

how do u setup a replication site?

1395

What is an agent and What are the types of agents?

243

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

520

What is a table index in oracle?

535

How to get a create statement for an existing table?

485

What are materialized views & where do we use them? What is a materialized view log?

For More Un-Answered { Oracle } Questions Click Here