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?

1049

State and explain the different types of data models?

906

What is key preserved table?

970

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

1083

What are the different pseudo commands? Explain in general?

1034

Explain the different normalization forms?

1028

State the various uses of dbcc command?

1001

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

1112

State the difference between a primary key and foreign key?

896

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

1026

Explain about functional dependency and its relation with table design?

966

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

953

What are privileges and grants?

1011

How to display row numbers with the records?

1037

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

1015

Un-Answered Questions { Oracle }

What are active transformation / passive transformations?

What are the main functions of dba?

540

What is mrc and what is its use? : oracle accounts receivable

1124

As an oracle dba what are the entire unix file you should be familiar with?

547

What is a matrix report and how many minimum groups are required to prepare the same?

1073

What is path setting for dll?

List out the oracle forms configuration files?

1019

What happens when the default and temp tablespace clauses are left out from create user statements?

543

How to use fetch statement in a loop?

988

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1907

How do I manually create a database in oracle?

973

How to assign data of the deleted row to variables?

1021

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7586

How view is different from a table?

980

What is the difference between online and offline backups?

994

For More Un-Answered { Oracle } Questions Click Here