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

can we pass two out parameters at a time in function?please answer to my question

Wipro,

3 6109

types of receipts and detail desription about recipts and tables effected by receipts?

2070

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 4929

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6377

i want department wise maxmum salary and empolyee name

9 29740

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

IBM,

1 3951

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 3381

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

Zensar,

2 5454

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

Zensar,

5 8569

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2691

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2308

how to find count rows in table without count function?

Oracle,

3 6991

i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

Oracle,

5 7772

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

Infosys,

4 8417

What is Tax Categories?

2104

Un-Answered Questions { Oracle }

How is clustered index different from non-clustered index?

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1907

What are different types of transactions in ar? : oracle accounts receivable

1285

What are functions of dba?

548

Does dba need to know programming?

565

Difference between cartesian join and cross join?

1031

Explain each trigger related to mouse.

What is oracle instant client?

1022

How to delete a column in an existing table in oracle?

1067

Explian File steps in ODI?

618

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1044

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2394

When configuring sqlnet on the client what files need to be set up?

640

What is a system tablespace and why do we need it?

What is tns name?

977

For More Un-Answered { Oracle } Questions Click Here