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

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

Wipro,

3 4998

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

1618

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 3954

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 5413

i want department wise maxmum salary and empolyee name

9 27172

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 3172

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

1 2662

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 4485

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 7047

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?

2249

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.

1857

how to find count rows in table without count function?

Oracle,

3 5635

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 6083

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

Infosys,

4 6909

What is Tax Categories?

1622

Un-Answered Questions { Oracle }

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

1951

What is save point in oracle database?

714

What is transport network substrate (tns) in oracle?

579

How to set a transaction to be read only in oracle?

572

What is oracle full backup?

269

What is the difference between formal parameters and actual parameters?

534

How to rename an index in oracle?

610

What are operators in oracle?

519

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

How can I create database in oracle?

557

Explain the characteristics of oracle dba?

628

What is oracle sid?

500

How to create sequence in odi?

349

What are the restrictions in a oracle read only transaction?

556

Explain cascading triggers.

564

For More Un-Answered { Oracle } Questions Click Here