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

What does the no logging option do? Why would we use it? Why would we be careful of using it?

503

How do I call oracle stored procedures that take no parameters?

1025

How do I learn what codesets are available in oracle?

998

How do I use os authentication with weblogic jdriver for oracle and connection pools?

999

How do I limit the number of oracle database connections generated by weblogic server?

1007

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1047

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1015

Why does for update in oracle 8 cause an ora-01002 error?

934

How to find the duplicate rows count from employees table in oracle?

1041

Explain implicit cursor.

963

Explain mutating triggers.

974

Give the different types of rollback segments.

980

How can you use check constraints for self referential integrity?

920

How many types of database triggers exist?

1068

Give the various exception types.

949

Un-Answered Questions { Oracle }

What is a initialization parameter file in oracle?

989

What is Library Cache in Oracle?

1077

What is the difference between oracle media recovery and crash recovery?

1122

what is difference between inner join & nested query or subqueries

2969

what are savepoint mode and cursor mode properties ?

What is the volume management techniques used in oracle rac?

How to invoke the data pump export utility?

1117

What is a recovery catalog?

How to declare a local variable?

1054

What are the constraints in odi?

572

How to name query output columns in oracle?

1133

how to pass a variable more than one values?

613

Explain the use of record option in exp command.

948

Explain how you would restore a database using RMAN to Point in Time?

2097

what is the use of system.effective.date variable in oracle?

1056

For More Un-Answered { Oracle } Questions Click Here