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?

1204

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

1098

Difference between hot backup vs. Cold backup?

949

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

1069

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

974

What do you mean by redo log file mirroring?

977

Explain the use of compress option in exp command.

969

Explain the use of parfile option in exp command.

991

Explain the use of log option in exp command.

1049

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

978

Explain the importance of .pll extension in oracle?

956

Explain the use of indexes option in exp command.

1066

When do you get a .pll extension in oracle?

1077

Can we protect our pl/sql source code?

994

What is analyze command used for?

1012

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the oracle implicit cursor?

1001

How to count duplicated values in a column in oracle?

985

How to view the data files in the current database?

1045

Difference between hot backup vs. Cold backup?

949

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2130

What are the general rules on data consistency?

960

How to load data through external tables?

1074

What is a nvl function?

958

What is difference between truncate and delete?

977

What is Redo Log Buffer in Oracle?

1127

What is connection pool in oracle?

930

How to load data from external tables to regular tables?

989

Why do we use coalesce function in oracle?

1053

How to check the server version in oracle?

1035

Can we call procedure inside function in oracle?

1021

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