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.

1022

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

984

Which are the five query types available in oracle?

897

Explain parameter file in oracle.

974

Is a rollback possible to any savepoint?

1002

Give the various rollback segment states.

1000

Explain cascading triggers.

1013

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

537

What is the advantage of using rman?

661

What are the beneficial tools for administering the database?

503

Which files are vital that should be backed up?

548

What do you understand by a control file?

506

What do you understand by recovery catalog?

518

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

528

What is the difference between a database and instance?

647

Un-Answered Questions { Oracle }

Where in the Oracle directory tree structure are audit traces placed?

2577

How to loop through a cursor variable?

1013

Is there an oracle sql query that aggregates multiple rows into one row?

934

How to list all user accounts in oracle?

981

how to write the procedures in odi?

675

What are the benefits of oracle rac?

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2145

Give the advantages and disadvantages of clusters.

997

What does a dba stand for?

522

What is the relation of a user account and a schema?

1064

What's dateware house and what's clustor with practicle example

2128

how to dynamically change the page size of d2k reports?

What is the scope of a local variable?

998

How I can use srw.run_report in reports6i?

What is the difference between truncate and delete? How would a full table scan behave after?

508

For More Un-Answered { Oracle } Questions Click Here