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

Explain the concept of the DUAL table.

2 6176

What are the ways tablespaces can be managed and how do they differ?

2457

From the database level, how can you tell under which time zone a database is operating?

1 3256

Whats the benefit of dbms_stats over analyze?

2068

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2196

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1990

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 3299

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

Wipro,

1 5901

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

Cisco,

2387

Respected sir, Please send me technical questions related to oracle apps..

1878

where the dff data will be stored

Infosys,

2546

key flexfield structure

Infosys,

2235

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

Punjab National Bank,

8014

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1931

How to retrieve first and last records from a table?

DELL, QSmart,

7 12282

Un-Answered Questions { Oracle }

How to invoke the original export import utilities?

1139

How you find which is the latest record in SCD type2 transformation?

657

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

646

in the package one interface got failed how to know which interface got failed if we no access to operator?

644

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2569

How many segment are present in Oracle Manufacturing

2376

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2290

Explain the use of compress option in exp command.

1073

Explain the purpose of forms_ddl.

How to apply filtering criteria at group level in oracle?

1091

how to write the sub-queries in odi?

751

What is oracle analytical function?

1242

What does an oracle dba do?

649

What is the load plans in odi?

691

How to establish administrator authentication to the server?

1101

For More Un-Answered { Oracle } Questions Click Here