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?

1243

Difference between hot backup vs. Cold backup?

1043

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?

1073

Explain the use of compress option in exp command.

1073

Explain the use of parfile option in exp command.

1149

Explain the use of log option in exp command.

1191

Un-Answered Questions { Oracle }

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

611

Explain procedure to change characterset of a database.

683

What is the history of ODI?

701

What are the roles and responsibilities of oracle dba?

704

List the types of joins used in writing subqueries?

1042

What to do if the startbd.bat failed to start the xe instance?

1132

What is oracle data type?

1013

What is oracle forms system.currentblock?

How many types of km's?

628

How to create a stored program unit?

1325

What do database buffers contain?

1083

What do you mean by oracle dba?

609

What are the oracle built-in data types?

1143

What is an oracle table?

1037

What is oracle full backup?

617

For More Un-Answered { Oracle } Questions Click Here