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

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

624

How can you find your id on a system?

607

What os user should be used for the first part of an oracle installation (on unix)?

591

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

612

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

640

Why are recursive relationships bad? How do you resolve them?

629

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

656

When configuring sqlnet on the client what files need to be set up?

700

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

612

How can you determine the space left in a file system?

692

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

634

Can you remove an open file under unix?

730

How can you determine if an oracle instance is up from the operating system level?

606

When should you increase copy latches?

682

How to uncatalog backup?

608

Un-Answered Questions { Oracle }

What is the usage of save points in oracle database?

1021

what is the difference between restoring and recovering?

1062

How can you tell if an index on particular table is used or not used in 9i?

598

How do we create privileges in oracle?

1103

What is a system tablespace and why do we need it?

What is the purpose of scan?

What is bulk load in oracle?

1135

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

1212

What is the purpose of a staging area?

What is a proxy object?

1111

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

did u received a single file or multiple files

2063

What is supporting issues GL AP and AR?

2623

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

3104

What do you understand by lov?

1081

For More Un-Answered { Oracle } Questions Click Here