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

What is the difference between $oracle_base and $oracle_home?

1089

State and explain the different types of data models?

944

What is key preserved table?

1021

What is a sub query and what are the different types of subqueries?

1125

What are the different pseudo commands? Explain in general?

1080

Explain the different normalization forms?

1098

State the various uses of dbcc command?

1060

What are a collation and state the different types of collation sensitivity?

1170

State the difference between a primary key and foreign key?

935

What are the different types of trigger and explain its various uses and functions?

1093

Explain about functional dependency and its relation with table design?

1010

Explain about your project and its relation to the current job position you are applying to?

1006

What are privileges and grants?

1067

How to display row numbers with the records?

1079

What are the uses of linked server and explain it in detail?

1059

Un-Answered Questions { Oracle }

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

794

State the various uses of dbcc command?

1060

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1024

What are the types of locks in database?

619

How to pass a parameter to a cursor in oracle?

1179

Can we save images in a database and if yes, how?

1065

Can we create database in oracle using command line ?

1085

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

What is materialized view in Oracle?

1074

Point out the difference between user tables and data dictionary?

982

I have applied the following commands: now what will happen, will the database will give an error / it will work?

549

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

1048

Please explain oracle left join with an example?

1045

Explain an exception?

994

which one is currently in used software cmpanies.

2153

For More Un-Answered { Oracle } Questions Click Here