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?

1155

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

484

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

533

How to drop an oracle database?

514

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?

551

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

513

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

485

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?

555

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?

755

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

528

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

562

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

522

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

524

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

527

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

500

Un-Answered Questions { Oracle }

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2319

Explain an exception?

943

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2784

How to export data with a field delimiter?

988

What privilege is needed for a user to create tables in oracle?

917

State some uses of redo log files?

961

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1686

What is auto invoicing? Explain : oracle accounts receivable

1072

material view and view disadvantages?

1023

What is the sql query to find the employee who has Nth maximum salary?

5243

Is there any link between pr form(purchse requisition)and po form(purchase order)

2673

How is it different from a normal table?

983

Explain an exception and its types?

1033

Mention what is the function of cache fusion in oracle rac?

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2316

For More Un-Answered { Oracle } Questions Click Here