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

Oracle General (1803)
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 6249

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

2124

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 5043

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6497

i want department wise maxmum salary and empolyee name

9 30145

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 4069

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

1 3464

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 5571

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 8805

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?

2764

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.

2369

how to find count rows in table without count function?

Oracle,

3 7132

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 7989

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

Infosys,

4 8572

What is Tax Categories?

2162

Un-Answered Questions { Oracle }

How to create a single index for multiple columns?

1087

What is a private synonym?

1647

What are the constraints in odi?

664

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3028

Explain oracle 12c new features for developers?

1127

How to create a new table in your schema?

1134

Where do you use decode and case statements?

1047

What is flashback in Oracle?

1065

Tell me some differences between ODI 10g and ODI 11g?

610

State and explain about oracle instance?

1053

What is the simplest tool to run commands on oracle servers?

1057

What are the different types of database users?

623

Explain the oracle real application clusters architecture?

What is oracle datasource?

1042

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1485

For More Un-Answered { Oracle } Questions Click Here