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

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?

1237

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

554

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

606

How to drop an oracle database?

606

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?

628

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

590

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

576

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?

657

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?

841

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

608

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

642

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

602

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

612

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

637

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

583

Un-Answered Questions { Oracle }

What skills should a dba have?

620

What is the difference between restoring a database and recovering a database?

Explain the process of recievables in oracle financials. : oracle accounts receivable

1212

How to use select statement to count the number of rows in oracle?

1100

What are privileges and grants?

1111

How to revoke create session privilege from a user in oracle?

1073

why dont we assign not null constraint as table level constraint.

2800

What is Reduced List of Values?

2249

Mention what is cluster?

How many types of dimensions in oracle?

609

What are the variable types?

685

What are a collation and state the different types of collation sensitivity?

1252

What is the difference between view and materialized view in Oracle?

1208

How to test null values?

1159

what is the difference between substr and instr function in oracle?

1145

For More Un-Answered { Oracle } Questions Click Here