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

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1193

What causes the "snapshot too old" error? How can this be prevented or mitigated?

519

How many redo logs should you have and how should they be configured for maximum recoverability?

567

How to drop an oracle database?

570

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

589

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

542

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

526

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

610

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

794

While taking hot backup (begin end backup) what will happens back end?

559

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

590

If you are not sure what command does a particular unix function what is the best way to determine the command?

565

If you see contention for library caches how you can fix it?

564

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

571

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

541

Un-Answered Questions { Oracle }

Explain the use of control file?

1113

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1929

How many types of synonyms in Oracle?

1124

State the difference between a primary key and foreign key?

935

What is an index associated with a constraint?

1040

Which is faster join or subquery in oracle?

995

Does oracle database need java?

1006

Discuss row chaining, how does it happen?

569

Is there any function in oracle similar like group_concat of mysql?

1053

What is a synonym? What are its various types?

1110

How many types of v variables'? Where will appear for variables in odi?

574

What are the daily activities of oracle dba?

602

How do you tell what your machine name is and what is its IP address?

2096

What is the difference between conversions and interfaces? : oracle accounts receivable

1231

can we implement package in package?

582

For More Un-Answered { Oracle } Questions Click Here