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

1098

What suggestions do you have to reduce the network traffic?

961

Explain the use of grant option in imp command.

1030

Explain the dml?

981

Explain alias?

1150

Explain the use of constraints option in exp command.

1048

Explain index?

1258

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

1196

Difference between hot backup vs. Cold backup?

991

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

1148

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

1058

What do you mean by redo log file mirroring?

1032

Explain the use of compress option in exp command.

1021

Explain the use of parfile option in exp command.

1069

Explain the use of log option in exp command.

1121

Un-Answered Questions { Oracle }

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

How would you find total size of database in os level?

569

How to count duplicated values in a column in oracle?

1039

Where are the settings stored for each instance in oracle?

1105

How do I start tns listener?

1043

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

573

i am writing a query select EmpNo from Emp how can i call in after parameter form

2126

Can we write dml statement in function in oracle?

1081

How to rename a tablespace in oracle?

1086

What is the sequence of firing in form level trigger?

what is profile in odi?

649

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

How to use values from other tables in update statements using oracle?

1079

What are the advantages of oracle 12c?

1180

Difference between Row Id and Row Num?

686

For More Un-Answered { Oracle } Questions Click Here