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.

1077

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

1045

Which are the five query types available in oracle?

949

Explain parameter file in oracle.

1029

Is a rollback possible to any savepoint?

1096

Give the various rollback segment states.

1052

Explain cascading triggers.

1074

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

586

What is the advantage of using rman?

722

What are the beneficial tools for administering the database?

543

Which files are vital that should be backed up?

603

What do you understand by a control file?

565

What do you understand by recovery catalog?

568

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

582

What is the difference between a database and instance?

694

Un-Answered Questions { Oracle }

What happens to the current transaction if the session is killed?

989

Why are recursive relationships bad? How do you resolve them?

591

Explain the payment term in ar. : oracle accounts receivable

1106

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

577

Do you know table based value sets?

Explain oracle’s server parameter file.

995

How to do a full database export?

1111

When system tablespace is created?

1041

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

589

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2370

What do we mean by record group in oracle forms?

1076

How do I become a data manager?

527

Can a formula column referred to columns in higher group ?

2506

How to rollback the current transaction in oracle?

1054

What is translate in oracle?

1100

For More Un-Answered { Oracle } Questions Click Here