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

548

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 is the use of system.effective.date variable in oracle?

1069

what are basic modules required to implement oracle application in any oraganisation?

2159

How can we generate report output in excel format?

950

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

511

If you are working Microsoft excel, which type of file you used .excel or .csv?

606

What is coalesce function?

1027

What if your ocr (oracle cluster registry) is corrupted?

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1838

What are functions of dba?

517

Difference between oracle's plus (+) notation and ansi join notation?

1052

How to build data dictionary view an new database?

972

Can we store images in oracle database?

955

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

523

What are the execution control statements?

1024

What is the volume management techniques used in oracle rac?

For More Un-Answered { Oracle } Questions Click Here