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

What is an oracle data file?

1103

How to revoke create session privilege from a user in oracle?

1018

What is a database table in oracle?

1022

What is an oracle recycle bin?

1009

How to use existing values in update statements using oracle?

1067

Can multiple columns be used in group by in oracle?

988

How to write a query with a left outer join in oracle?

1065

How many categories of data types in oracle?

1029

What are the oracle built-in data types?

1065

What is a read write transaction in oracle?

1093

How to create an oracle database?

1041

How to count groups returned with the group by clause in oracle?

1076

What is an oracle tablespace?

1044

What is a dynamic performance view in oracle?

991

How to execute a stored procedure in oracle?

1091

Un-Answered Questions { Oracle }

What is the purpose of a staging area?

Why is oracle so popular?

997

What is tns service name?

1126

Difference between varchar and varchar2 data types?

1184

How to synchronize 2 schema's objects?

2181

Difference between open_form and call_form in oracle.

1161

What is oracle archived redo log?

593

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

1661

What is the history of ODI?

652

What are the file storage options provided by oracle database for oracle rac?

Explain the use of control file?

1113

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3935

How many file formats are supported to export data?

1220

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

590

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5410

For More Un-Answered { Oracle } Questions Click Here