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 use of show option in imp command.

1155

What suggestions do you have to reduce the network traffic?

1026

Explain the use of grant option in imp command.

1085

Explain the dml?

1051

Explain alias?

1193

Explain the use of constraints option in exp command.

1086

Explain index?

1314

How to create lov dynamically at runtime & attach to text field?

1241

Difference between hot backup vs. Cold backup?

1041

How can we force the database to use the user specified rollback segment?

1202

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

1151

What do you mean by redo log file mirroring?

1072

Explain the use of compress option in exp command.

1073

Explain the use of parfile option in exp command.

1146

Explain the use of log option in exp command.

1189

Un-Answered Questions { Oracle }

Mention what is the difference between instance recovery and crash recovery?

Explain the use of parfile option in exp command.

1146

What is the use of lockboxes? : oracle accounts receivable

1270

How to loop through a cursor variable?

1129

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1995

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1194

How to write date and time interval literals in oracle?

1087

How do I limit the number of rows returned by an oracle query after ordering?

1228

What is the difference between media recovery & crash recovery?

How do I become a data manager?

569

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2129

What is redo log?

1117

How can we monitor the space allocations in a database?

How to add another datafile to a tablespace?

1095

What are some indications that you need to increase the shared_pool_size parameter?

615

For More Un-Answered { Oracle } Questions Click Here