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?

1259

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

1197

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

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

1040

Explain the importance of .pll extension in oracle?

1011

Explain the use of indexes option in exp command.

1149

When do you get a .pll extension in oracle?

1146

Can we protect our pl/sql source code?

1043

What is analyze command used for?

1072

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain self joins in oracle?

1019

How to write date and time literals in oracle?

1002

What is the difference between Delete, Truncate and Drop in Oracle?

1131

What is difference between sid and service name in oracle?

956

How can I create database in oracle?

1026

how can we store any pdf file in oracle

2164

How many data types are supported?

1079

What is open database communication (odbc) in oracle?

1003

What is partitioned table in Oracle?

1189

What is the fastest query method to fetch data from the table?

1361

Explain the use of control file?

1113

What is flashback in Oracle?

1019

How many memory layers are in the oracle shared pool?

1181

How to drop a stored function?

1137

What are a query and state the different types of queries and their uses?

1015

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