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

Mention what is the function of cache fusion in oracle rac?

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

Mention what is oracle real application clusters?

Mention what is olr?

Mention in rac what files should be created on shared storage?

Mention what is cluster?

Mention what is the difference between single instance environment and rac environment?

Mention what is the difference between instance recovery and crash recovery?

Mention how oracle flex asm works?

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

Mention what are the tools provided in oracle enterprise manager?

Mention what are the key characteristics of rac or why to use rac?

Mention where does the clusterware write when there is a network or storage issue?

Mention what is new feature in oracle asm 12c?

Mention what is split brain syndrome in rac?

Un-Answered Questions { Oracle }

How many anonymous blocks can be defined?

1259

How do you analyze table partition using oracle provided package?

559

What is the difference between truncate and delete? Why is one faster?

704

How to export your connection information to a file?

1180

How does one coalesce free space?

599

Respected sir, Please send me technical questions related to oracle apps..

1876

How many types of v variables'? Where will appear for variables in odi?

637

What are nested tables?

1227

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2148

What are materialized views & where do we use them? What is a materialized view?

What is CKM and when we will use this CKM?

624

please send me oracle pl/sql exp resume. and also faqs...

2550

What is meant by joins? List out the types of joins.

1110

What skills do you need to be an administrator?

614

what are the default admin accounts in Oracle 10g ?

1026

For More Un-Answered { Oracle } Questions Click Here