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 required by oracle rac database to connect to a network?

What is the purpose of scan?

What is the function of cache fusion in oracle rac?

material view and view disadvantages?

1027

How many types of tables supported by oracle?

1033

How to select some rows from a table in oracle?

1026

How to connect to a local oracle 10g xe server?

953

How to use subqueries with the in operator using oracle?

1055

Can select statements be used on views in oracle?

1002

How to use "while" statements in oracle?

1257

How to sort the query output in oracle?

979

How to use null as conditions in oracle?

1026

How to use "for" statements in oracle?

1033

How to use group functions in the select clause using oracle?

1040

What is transport network substrate (tns) in oracle?

1003

Un-Answered Questions { Oracle }

What is auto invoicing? : oracle accounts receivable

1106

How can I combine multiple rows into a comma-delimited list in oracle?

1015

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1017

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2030

What is merge in oracle?

1008

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2235

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

534

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

548

What are the varoius components of physical database structure of oracle database?

964

How to test null values?

1057

How is clustered database important in oracle rac architecture?

Please explain compound trigger in oracle?

1009

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2257

where the dff data will be stored

2364

Mention how oracle flex asm works?

For More Un-Answered { Oracle } Questions Click Here