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?

1061

Explain the difference between sql and oracle?

1076

Please explain oracle left join with an example?

1045

Explain the truncate in oracle?

966

How to execute the package in oracle?

1081

Explain oracle insert into command?

1110

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

1036

Explain the features of oracle?

1043

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

993

Why oracle is used?

1054

Un-Answered Questions { Oracle }

What is db_recovery_file_dest in oracle? When do you need to set this value?

1124

What happens if you set the sga too low in oracle?

1147

What are Oracle Schema Objects?

1111

How to define a specific record type?

1084

What are the various benefits of using rac architecture?

How to write a left outer join with the where clause in oracle?

1084

Difference between transaction type and transaction sources. : oracle accounts receivable

1032

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2286

What is the difference between truncate and delete? Why is one faster?

648

How to count duplicated values in a column in oracle?

1039

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1927

How to create a table interactively?

1087

Who developed oracle & when?

1003

i am writing a query select EmpNo from Emp how can i call in after parameter form

2123

What do you know about normalization? Explain in detail?

951

For More Un-Answered { Oracle } Questions Click Here