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

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

577

How can you find your id on a system?

566

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

549

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?

575

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?

601

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

589

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?

617

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

643

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

558

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

649

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.

590

Can you remove an open file under unix?

694

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

559

When should you increase copy latches?

644

How to uncatalog backup?

567

Un-Answered Questions { Oracle }

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2906

Name the different triggers supported by oracle reports and their firing order.

1088

Mention what is the difference between instance recovery and crash recovery?

Any work done in oracle workflow builder. Did you customize or build a new workflow?

What is da in database?

543

What is oracle real application clusters?

What are the types of profiles in ODI?

595

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1382

How can I learn oracle dba?

563

Who is dba in dbms?

581

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

689

What is a user exit program in oracle reports?

1028

What is system global area (sga) in oracle?

991

What is data block in Oracle?

1116

What flow of MSExcel in odi?

587

For More Un-Answered { Oracle } Questions Click Here