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?

550

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

1115

How do I learn what codesets are available in oracle?

1038

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

1051

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

1070

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

1087

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

1078

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

1003

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

1090

Explain implicit cursor.

1028

Explain mutating triggers.

1028

Give the different types of rollback segments.

1031

How can you use check constraints for self referential integrity?

969

How many types of database triggers exist?

1133

Give the various exception types.

991

Un-Answered Questions { Oracle }

Why oracle forms required?

1039

What is the difference between PFILE and SPFILE in Oracle?

1060

How to rename an index in oracle?

1113

What are functions of dba?

551

Please explain compound trigger in oracle?

1057

What privilege is needed for a user to create indexes in oracle?

1026

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2396

what is IDE,DMV in sql server?

2818

can we use lexical perameter in oracle plsql if yes how

2313

What is an Oracle Data Dictionary?

1109

what is difference between sql plus and sql*plus? (not sql and sql plus).

3897

Why do we need to rebuild indexes?

What is ASM (Automatic Storage Management) in Oracle?

1196

what are bind variables?

1087

what is the difference between functional dependecy and multilevel dependency?

2459

For More Un-Answered { Oracle } Questions Click Here