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 6090

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

2373

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

1 3188

Whats the benefit of dbms_stats over analyze?

2005

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

2149

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?

1930

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 3223

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

Wipro,

1 5833

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,

2327

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

1815

where the dff data will be stored

Infosys,

2450

key flexfield structure

Infosys,

2183

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 ?

1868

How to retrieve first and last records from a table?

DELL, QSmart,

7 12047

Un-Answered Questions { Oracle }

What is oracle full backup?

574

what are archived logs?

2205

Where is the export dump file located?

1164

Explain a data segment?

1074

What is redo log?

1071

How to create an oracle database?

1053

What are the parameters that we can pass through a stored procedure?

1069

does odi support web services?

567

Can objects of the same schema reside in different tablespace?

1067

Can the query output be sorted by multiple columns in oracle?

995

What is an Integrity Constrains in Oracle?

1191

How to execute the package in oracle?

1086

What is the difference between a primary key & a unique key?

1092

List the parts of a database trigger.

1054

What is bulk copy or bcp in oracle?

1126

For More Un-Answered { Oracle } Questions Click Here