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 simple and complex, snapshots ?

2 5031

What dynamic data replication ?

2 6473

How can you Enforce Refrencial Integrity in snapshots ?

1 4209

What are the options available to refresh snapshots ?

2 5909

what is snapshot log ?

2 7553

When will the data in the snapshot log be used ?

2 5243

What are the benefits of distributed options in databases ?

1 4390

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33047

Define Transaction ?

5 10439

When does a Transaction end ?

2 7413

What does COMMIT do ?

4 10380

What is SAVE POINT ?

5 9435

What is Read-Only Transaction ?

3 6434

What is the function of Optimizer ?

1 4383

What are the different approaches used by Optimizer in choosing an execution plan ?

2 5112

Un-Answered Questions { Oracle }

How do you store pictures in a database?

964

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1951

What do you mean by a tablespace?

993

What is a flashback query and when should it be used?

How to use subqueries in the from clause in oracle?

1060

How to assign values to variables?

1061

How to turn on or off recycle bin for the instance?

1023

How to use attributes of the implicit cursor in oracle?

964

What is a user role in oracle?

1075

How to open and close an explicit cursor in oracle?

1014

is there a tool to trace queries, like profiler for sql server?

1099

How to make the project as .exe file in oracle forms & reports(d2k)?

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2303

What do you mean by oracle database?

542

What are the benefits of ordbms?

1041

For More Un-Answered { Oracle } Questions Click Here