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 6178

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

2459

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

1 3260

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 5904

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,

2391

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

1880

where the dff data will be stored

Infosys,

2547

key flexfield structure

Infosys,

2237

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,

8017

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 12300

Un-Answered Questions { Oracle }

What is where clause in oracle?

1082

What privilege is needed for a user to create indexes in oracle?

1090

What is the difference between sharding and replication?

1143

How to install oracle database 10g xe?

1068

What types of joins are used in writing subqueries?

1043

Can we store pictures in the database and if so, how it can be done?

1095

How to connect to oracle using service name instead of sid?

1077

What are property classes?

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

How to add a new column to an existing table in oracle?

1192

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2289

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

609

How to resolve the ORA-39133 error in Oracle?

1189

What is the difference between substr & instr functions?

1299

What is tkprof and how is it used?

662

For More Un-Answered { Oracle } Questions Click Here