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 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?

514

How can be determining the size of the log files?

544

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

532

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?

547

How can you tell if a tablespace has excessive fragmentation?

557

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

549

What is a database instance?

548

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

511

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

611

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

542

Un-Answered Questions { Oracle }

What do you mean by Oracle MEDIA RECOVERY?

1180

What are the new features in release 11i?

How will you differentiate between varchar & varchar2?

1000

How do we display rows from the table without duplicates?

940

Difference between open_form and call_form in oracle.

1108

What is a cognitive schema?

921

Explain joins in oracle?

990

What is tkprof and how is it used?

561

What is an Oracle index?

1617

List the various oracle database objects?

1010

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1232

Mention what is the difference between instance recovery and crash recovery?

What is the difference between sharding and replication?

980

What is sharded cluster?

950

What is autocashrule set? : oracle accounts receivable

1314

For More Un-Answered { Oracle } Questions Click Here