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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How can we monitor the space allocations in a database?

How do you recover a lost control file?

What do you mean by database normalization and why is it important?

How is rman better than user-managed backup recovery process?

How is clustered index different from non-clustered index?

Write a trigger example in oracle?

996

Explain the difference between sql and oracle?

1040

Please explain oracle left join with an example?

976

Explain the truncate in oracle?

922

How to execute the package in oracle?

1051

Explain oracle insert into command?

1069

Explain the difference between replace() and translate() functions in oracle?

987

Explain the features of oracle?

994

How to convert raw data type into text in oracle? Explain

960

Why oracle is used?

1010

Un-Answered Questions { Oracle }

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

532

How can I get column names from a table in oracle?

1003

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

548

What is a sub query? Describe its types?

973

How to apply filtering criteria at group level in oracle?

1004

How to connect ms access to oracle servers?

954

What are the file systems and volume management techniques used in oracle rac?

if u want to delete all these detail block etc what will happen in form

1941

Can we insert data in view oracle?

977

How to check your oracle database 10g xe installation?

942

How to rollback the current transaction in oracle?

998

What is oracle rownum?

897

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

611

What are the functions of administration?

506

why the Ctl file u put only in bin folder why not in other folder

2010

For More Un-Answered { Oracle } Questions Click Here