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 6081

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

2362

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

1 3175

Whats the benefit of dbms_stats over analyze?

1997

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

2138

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?

1923

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 3212

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

Wipro,

1 5814

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,

2321

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

1809

where the dff data will be stored

Infosys,

2430

key flexfield structure

Infosys,

2172

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,

7967

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

1861

How to retrieve first and last records from a table?

DELL, QSmart,

7 11999

Un-Answered Questions { Oracle }

Please explain drop constraint oracle?

1096

What is the quickest way to export a table to a flat file?

964

What are the variable types?

608

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2118

Explain the use of record length option in exp command.

1063

How to rename an index?

1069

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2391

What is the difference between oracle media recovery and crash recovery?

1171

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

Have you attend the client meetings?

609

What is oracle log switch?

612

What is object data modeling?

954

How to assign data of the deleted row to variables?

1070

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2254

What is a trigger and what are its types?

1220

For More Un-Answered { Oracle } Questions Click Here