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?

1306

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

1238

Difference between hot backup vs. Cold backup?

1036

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

1197

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

1139

What do you mean by redo log file mirroring?

1067

Explain the use of compress option in exp command.

1066

Explain the use of parfile option in exp command.

1138

Explain the use of log option in exp command.

1181

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

1086

Explain the importance of .pll extension in oracle?

1057

Explain the use of indexes option in exp command.

1206

When do you get a .pll extension in oracle?

1189

Can we protect our pl/sql source code?

1080

What is analyze command used for?

1122

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the various constraints used in oracle?

1093

What is the best way to do multi-row insert in oracle?

1105

What is recovery manager in Oracle?

1108

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5473

How do I connect to oracle?

1078

What is proxy method?

1020

What do you know about normalization? Explain in detail?

996

Does facebook use oracle?

1079

What are the limitations oracle database 10g xe?

1089

How to convert character types to numeric types?

1191

Can sub procedure/function be called recursively?

1045

how to join query for one source type is oracle another source type is sql server ?

2478

How to pass a cursor variable to a procedure?

1153

What is connection pool in oracle?

1033

What is the difference between alert log file and tarce file ?

2223

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