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

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

Oracle Interview Questions

Questions Answers Views Company eMail

How to create a single index for multiple columns?

1086

How to assign query results to variables?

1101

What is a directory object?

1142

How to call a sub procedure?

1150

How to retrieve values from data fields in record variables?

1178

What are the general rules on data consistency?

1066

How to define a procedure inside another procedure?

1070

What to do if the binary spfile is wrong for the default instance?

1111

How to create a server parameter file?

1189

How to rename an existing table?

1225

What are the execution control statements?

1114

How to run create database statement?

1081

What happens if the update subquery returns multiple rows?

1173

How to use "startup" command to start default instance?

1103

What happens if the imported table already exists?

1081

Un-Answered Questions { Oracle }

How can we generate report output in excel format?

1041

What are the IKM types?

740

How to apply filtering criteria at group level in oracle?

1091

What is the difference between internal & external schema?

809

What is dba software?

696

How to create a new table in oracle?

1239

How do I reset a sequence in oracle?

1159

How do we get field details of a table?

1031

What is background process in Oracle?

1142

Can you have more than one content canvas view attached with a window ?

2374

Design database draw er diagram for a certain scenario ?

4635

What do you mean by group by clause?

1096

What are materialized views & where do we use them? What is a materialized view log?

Explain the blob datatype?

1125

What is oracle rownum?

1019

For More Un-Answered { Oracle } Questions Click Here