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?

611

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 }

What is oracle full backup?

570

What is Restricted Mode of Instance Startup in Oracle?

1199

Explain about the analyze command in oracle?

1052

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1988

Is oracle an open source?

1078

Explain the use of consistent option in exp command.

1067

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2108

Can we call procedure inside function in oracle?

1093

How to create id with auto_increment on oracle?

990

How to define an oracle cursor variable?

1027

What does a dba do all day?

553

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

What are parameter files? Where do we use them?

Can select statements be used on views in oracle?

1027

Explain alias?

1151

For More Un-Answered { Oracle } Questions Click Here