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 a trigger and what are its types?

1136

List out the types of joins.

1098

What are the parameters that we can pass through a stored procedure?

1007

What is a nested table?

1012

How view is different from a table?

980

What do you understand by a database object?

997

What is meant by raw datatype?

1017

When do we use group by clause in a sql query?

1000

Where do we use decode and case statements?

954

How can we find out the duplicate values in an oracle table?

1008

What is the difference between truncate & delete command?

1141

How will you identify oracle database software release?

955

What are the attributes that are found in a cursor?

1023

What do you understand by a database object? Can you list a few of them?

982

What is a nvl function?

968

Un-Answered Questions { Oracle }

What is the function of having virtual internet protocol address (vip) in oracle rac?

How to define an anonymous procedure without variables?

1040

What is Redo Log Buffer in Oracle?

1148

Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

597

How will you run ms_batch file in forms?

What are the skills required for oracle dba?

606

What is an oracle wallet?

894

What is a tns file?

949

Is there any function in oracle similar like group_concat of mysql?

1002

What is system tablespace?

1052

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2064

What is the best way to do multi-row insert in oracle?

1026

Where does the clusterware write when there is a network or storage issue?

What happens if the constraint name is left out of a constraint clause?

509

What do you mean by dba?

533

For More Un-Answered { Oracle } Questions Click Here