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 are the varoius components of physical database structure of oracle database?

965

Explain the use of online redo log files in oracle.

1007

Explain the use of grant option in exp command.

1024

What is a sub query? What are its various types?

1108

Explain enable novalidate constraint.

1048

What is a synonym? What are its various types?

1061

Explain the use of owner option in exp command.

1007

Explain integrity constraints?

1074

What do you mean by a deadlock?

1026

Will you be able to store pictures in the database?explain.

945

Explain the function of optimizer in oracle?

1082

What are the uses of synonyms?

1101

Explain the use of record option in exp command.

957

Explain the use of analyse option in exp command.

1082

List the types of joins used in writing subqueries?

957

Un-Answered Questions { Oracle }

What is bulk load in oracle?

1025

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1954

Can we create trigger on materialized view in oracle?

950

I have applied the following commands: now what will happen, will the database will give an error / it will work?

519

If you see statistics that deal with "undo" what are they really talking about?

614

What is index in Oracle?

1029

How to define Data Block size in Oracle?

1084

Where do we use decode and case statements?

960

Which files are vital that should be backed up?

563

What is a subquery in oracle?

1065

Explain prerequisites and post activities of oracle database installation

2091

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2280

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

584

What is oracle update statement with inner join ?

1009

What is oracle database 10g express edition?

1088

For More Un-Answered { Oracle } Questions Click Here