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 6121

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

2075

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 4943

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6387

i want department wise maxmum salary and empolyee name

9 29793

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 3966

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

1 3389

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 5468

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 8584

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?

2697

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.

2310

how to find count rows in table without count function?

Oracle,

3 7008

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 7797

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

Infosys,

4 8438

What is Tax Categories?

2112

Un-Answered Questions { Oracle }

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

575

What do database buffers contain?

1031

Is oracle a programming language?

986

What are the original export and import utilities?

1171

What is Undo Management Advisor in Oracle?

1098

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

What is transaction control statement and how many types of transaction control statement in Oracle?

1156

Explain about the analyze command in oracle?

1052

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

Whether any commands are used for months calculation? If so, what are they?

1097

Does a dba have to file taxes?

583

What happens to the data files if a tablespace is dropped?

1059

What is data block in Oracle?

1116

How to login to the server without an instance?

1162

what are actual and formal parameters?

1104

For More Un-Answered { Oracle } Questions Click Here