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

Briefly explain what is literal? Give an example where it can be used?

1042

Explain about the analyze command in oracle?

1052

Difference between cartesian join and cross join?

1039

Point the difference between translate and replace?

1085

What are the major difference between truncate and delete?

1058

What is a sub query? Describe its types?

1017

What is the difference between count (*), count (expression), count (distinct expression)?

1005

Point out the difference between user tables and data dictionary?

982

What do you mean by merge in oracle and how can you merge two tables?

948

Difference between the “verify” and “feedback” command?

1362

What do you mean by merge in oracle?

996

Describe an oracle table?

1049

What are the differences between primary key and unique key?

1010

What is the difference between substr and instr?

1037

Describe varray?

1058

Un-Answered Questions { Oracle }

Have you used lexical parameters in reports?

what are the tools used for oracle 10g in real time.

2441

What is rich query?

981

Discuss row chaining, how does it happen? How do you correct it?

549

Can you assign multiple query result rows to a variable?

987

What is concurrency in oracle?

1008

what is the scripts in data base?

2154

what is oracle data integrator (odi)?

623

How can be determining the size of the log files?

583

Explain the term 'oracle grid architecture'?

587

How to login to the server without an instance?

1162

Explain the use of owner option in exp command.

1043

What is format trigger?

2070

How to use an explicit cursor without open statements?

1055

Explain about achiever in sql?

1035

For More Un-Answered { Oracle } Questions Click Here