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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is the difference between a hot backup and a cold backup in oracle?

961

Describe the types of sub query?

939

What are the attributes of the cursor?

937

What is raw datatype in oracle?

1052

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

975

Explain about the analyze command in oracle?

998

Difference between cartesian join and cross join?

960

Point the difference between translate and replace?

1028

What are the major difference between truncate and delete?

984

What is a sub query? Describe its types?

965

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

966

Point out the difference between user tables and data dictionary?

932

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

907

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

1309

What do you mean by merge in oracle?

939

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

WHAT IS ecc 6.0

2103

What do you know about normalization? Explain in detail?

882

How to display row numbers with the records?

1025

What are the predefined tablespaces in a database?

1011

When do you get a .pll extension in oracle? Explain its importance

987

Explain the use of owner option in exp command.

994

What is key preserved table?

961

How would you go about verifying the network name that the local_listener is currently using?

1996

Name the various constraints used in oracle?

971

What is literal?

957

How to convert csv to table in oracle?

924

What is a procedure in oracle?

1076

How do we get field detail of a table?

1022

What is the order of defining local variables and sub procedures/functions?

1006

Give syntax for SQL and ORACLE joins.

1042

For More Un-Answered { Oracle General } Questions Click Here