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

Explain the concept of the DUAL table.

2 6085

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

2367

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

1 3180

Whats the benefit of dbms_stats over analyze?

2002

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

2144

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?

1929

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 3218

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

Wipro,

1 5823

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,

2322

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

1813

where the dff data will be stored

Infosys,

2439

key flexfield structure

Infosys,

2176

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,

7972

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

1865

How to retrieve first and last records from a table?

DELL, QSmart,

7 12022

Un-Answered Questions { Oracle }

What are the important tasks of common oracle dba?

560

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1980

Differences between package and loadplans?

590

What is a trace file and how is it created in oracle?

1058

how can you pass values to-and-fro from foreign function?

Mention what are the tools provided in oracle enterprise manager?

What is the minimum client footprint required to connect c# to an oracle database?

1093

How many types of database software are there?

587

How many anonymous blocks can be defined?

1184

Briefly explain what is literal? Give an example where it can be used?

1042

What is a read write transaction in oracle?

1093

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1110

What is db_recovery_file_dest in oracle? When do you need to set this value?

1125

What is the main function of database?

610

Explain the use of indexes option in imp command.

1179

For More Un-Answered { Oracle } Questions Click Here