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

Oracle General (1809)
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 35502

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

BeBo Technologies, Wipro,

7 73592

What are inner join and outer join?

3 25255

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

Amdocs, CSC, TCS,

29 95817

what are Triggers?

TCS,

7 28152

what are stored procedures?

TCS, Wells Fargo,

7 26538

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

Green Info Solutions, TCS,

7 31141

what are views?

TCS,

8 34607

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

i2, Oracle,

2 30762

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

CA,

1 17549

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

2 6582

For web applications from which version of Oracle is suitable?

1 6047

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

1 5478

What is Statement Auditing ?

2 5373

What are the use of Roles ?

3 6124

Un-Answered Questions { Oracle }

as a technical developer in oracle applications which type errors feced in your experience sofar

2272

What is the difference between media recovery & crash recovery?

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1890

what is the difference between call_form, new_form and open_form?

1213

List out the oracle forms configuration files?

1004

Give the advantages and disadvantages of clusters.

996

What do you mean by database normalization and why is it important?

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1590

List out the difference between commit, rollback, and savepoint?

985

How to define a variable to match a table column data type?

936

Can you remove an open file under unix?

639

What is the easiest method to create a file on unix?

522

How to use "if" statements on multiple conditions?

1110

Teradata: How can we know the indexed column in a table?

1842

How to view all columns in an existing table?

872

For More Un-Answered { Oracle } Questions Click Here