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?

573

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)?

548

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?

585

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?

642

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?

566

Un-Answered Questions { Oracle }

How to generate query output in html format?

1116

where do u put the report file

2091

What is oracle server autotrace in oracle?

1166

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2321

What is Redo Log Buffer in Oracle?

1207

What is oracle open database communication (odbc)?

1028

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2220

What is the mandatory setup in cyclecount ?

2749

Explain the difference between repeating frame and frame.

What is a package in oracle?

1101

Teradata: How can we know the indexed column in a table?

1890

What do database buffers contain?

1028

What is coalesce function?

1068

How do you use automatic pga memory management with oracle 9i and above?

589

What are the various tools? - Name a few?

For More Un-Answered { Oracle } Questions Click Here