Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

Where do we use connected and un connected lookups?

How to determine what records to extract?

What are materialized views & where do we use them? What is a materialized view log?

How do you analyze the tables

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

590

How can be determining the size of the log files?

623

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

611

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

620

How can you tell if a tablespace has excessive fragmentation?

640

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

639

What is a database instance?

633

Which is the best option used to move database from one server to another serve on same network and why?

583

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

711

How can you determine the number of sqlnet users logged in to the unix system?

614

Un-Answered Questions { Oracle }

what are the new features introduced in oracle form services in 11g release 2?

1078

Discuss row chaining, how does it happen? How can you reduce it?

590

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2387

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2315

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2369

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1118

A scenario for amount correction & how to use amount correction functionality in AP invoices

2201

What the is the diff between local index and global index. give some example.

1688

How to loop through a cursor variable?

1130

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2471

What are the uses of Oracle Rollback Segment?

1179

What is connection pooling in oracle?

1022

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2376

What is oracle rowcount?

1152

What are four common errors found in an alert .log?

600

For More Un-Answered { Oracle } Questions Click Here