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

Differentiate between function and procedure in oracle.

1025

Give the constructs of a package, function or a procedure.

990

Which are the five query types available in oracle?

910

Explain parameter file in oracle.

981

Is a rollback possible to any savepoint?

1013

Give the various rollback segment states.

1006

Explain cascading triggers.

1019

What do you mean by oracle dba and what is its role?

544

What is the advantage of using rman?

670

What are the beneficial tools for administering the database?

508

Which files are vital that should be backed up?

559

What do you understand by a control file?

519

What do you understand by recovery catalog?

529

What do you understand by the term 'system change number (scn)'?

541

What is the difference between a database and instance?

652

Un-Answered Questions { Oracle }

how to do daily transactions with out sql* loader control file regesterd in apps?

1643

can u plz provide me oca sql dumps please i need them

1907

How to establish administrator authentication to the server?

991

Does a dba have to file taxes?

537

did u received a single file or multiple files

1982

how may join possible between (requisition with purchase order)

2176

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2092

How to create an initialization parameter file?

994

What is the placeholder column?

What are the types of profiles in ODI?

559

how the indexes are stored in the Oracle Database?

2219

how can we store any pdf file in oracle

2106

how to dynamically change the page size of d2k reports?

What does a dba stand for?

531

what is tripstop report?

1775

For More Un-Answered { Oracle } Questions Click Here