Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain index?

1256

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

1178

Difference between hot backup vs. Cold backup?

988

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?

1050

What do you mean by redo log file mirroring?

1024

Explain the use of compress option in exp command.

1019

Explain the use of parfile option in exp command.

1063

Explain the use of log option in exp command.

1115

Use of an integrity constraint is better to validate data. Explain

1040

Explain the importance of .pll extension in oracle?

1003

Explain the use of indexes option in exp command.

1141

When do you get a .pll extension in oracle?

1144

Can we protect our pl/sql source code?

1042

What is analyze command used for?

1070

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the varoius components of physical database structure of oracle database?

1004

What is data type in oracle?

1118

What is clustered table in Oracle?

1190

What is a relational database management system?

1118

What is enter substitution variable in oracle?

1050

How to insert a record into a table?

1066

What are the uses of Database Trigger ?

1713

Explain about achiever in sql?

1032

What is the data type of dual table?

991

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

How to turn on or off recycle bin for the session?

1105

Differentiate between translate and replace?

1110

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

1148

Hi Can any one tell me what are the API's used in requisition import.

1920

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2059

For More Un-Answered { Oracle General } Questions Click Here