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

when do u go for hash partitioning?

1 3750

what is RAID technology?which is better RAID 0+1 OR RAID 5?

CSC,

2 16829

how do get database name at sql prompt?

3 7077

what is the scenario where you take the database to NoArchivelog mode?

2330

does the query needs a hint to access a materialized view?

1857

what is analyze command ? what kind of statistics does it generate?

2 5000

how do u know the total no of rows in a table?

6 9087

what are archived logs?

2199

what are bitmap indexes? How does they work?

2244

what are the database links ?

2 4763

does the query needs a hint to access a materialized view?

1 3863

what are different types of locks?

6 8596

master table and child table performances and comparisons in Oracle ?

2138

what are the different types of cursors? explain?

4 10218

what are different types of deletes?

1 3755

Un-Answered Questions { Oracle }

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

Explain the use of rows option in exp command.

1090

What is the difference between raid 5 and raid 10? Which is better for oracle?

589

Why more redos are generated when the oracle database is in begin backup mode?

1120

Difference between oracle's plus (+) notation and ansi join notation?

1100

Explain the oracle grid infrastructure?

What are the numeric comparison operations?

1111

how do u compile a form i.e .fmb file in Unix or in dos

4569

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2460

What are the types of profiles in ODI?

595

can u give guidance abt packages of plsql

2174

How do I spool to a csv formatted file using sqlplus?

1033

Where are the settings stored for each instance in oracle?

1105

What is the difference between recovery and restoring of the oracle database?

1220

How to create additional tablespaces for an new database?

1026

For More Un-Answered { Oracle } Questions Click Here