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?

1103

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?

1095

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?

1011

What are privileges and grants?

1067

How to display row numbers with the records?

1080

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

1061

Un-Answered Questions { Oracle }

What do you understand by oracle forms?

1044

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3053

3. Steps in UAT?

2432

What are the oracle differences between nvl and coalesce

1149

What is a database schema in oracle?

1110

How to rename a column in an existing table?

1035

Can we connect to ORACLE db using Windows Authentication?

1257

What are dba privileges?

534

How to create an oracle testing table?

1069

How to rename an existing table?

1129

How to write a query with a left outer join in oracle?

1065

What is the max number of columns in an oracle table?

1001

What is oracle rownum?

953

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7674

List out the difference between commit, rollback, and savepoint?

1033

For More Un-Answered { Oracle } Questions Click Here