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?

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

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?

1042

What is analyze command used for?

1072

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a system tablespace and when it is created?

972

What is an oracle tablespace?

1043

What is enter substitution variable in oracle?

1052

How many types of table in Oracle?

1121

What is Trigger in Oracle?

1171

What is the difference between postgresql and oracle?

1048

Difference between the “verify” and “feedback” command?

1362

Explain integrity constraint?

1161

How much memory your 10g xe server is using?

1103

How to define a variable of a specific record type?

1078

Who developed oracle & when?

1003

What is blob datatype?

1128

State some uses of redo log files?

1007

What is an oracle transaction?

1146

How to bring a tablespace online?

1079

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