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

What are the important difference between property clause and visual attributes?

1 7889

What is a Text_io Package?

4 10152

What is an User_exit?

2 7365

What is synchronize?

2 23916

What is forms_DDL?

2 10689

What is WHEN-Database-record trigger?

1 7213

What are the master-detail triggers?

1 6199

What is the difference between $$DATE$$ & $$DBDATE$$

1 10786

What is system.coordination_operation?

1 4116

What are the difference between lov & list item?

ESS,

1 9231

What are the different display styles of list items?

1 7686

What is pop list?

2 5280

What is a text list?

2 4195

What is a combo box?

2 6090

What are display items?

3 6427

Un-Answered Questions { Oracle }

What is StandAlone Agent and default port number?

764

How many redo logs should you have and how should they be configured for maximum recoverability?

606

what is load plans and types of load plans?

679

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2313

What is the difference between single instance environment and rac environment?

Explain master-detail relationship with some examples.

1063

How do you set up tablespaces during an oracle installation?

657

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2395

How do you generate file output from sql?

669

How will you write a query to get a 5th rank student from a table student_report?

1926

What is auto invoicing? : oracle accounts receivable

1242

Explain the difference between a procedure and a function?

1244

What are the execution control statements in oracle?

1139

How to connect to oracle using service name instead of sid?

1077

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2449

For More Un-Answered { Oracle } Questions Click Here