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?

1017

Describe the types of sub query?

999

What are the attributes of the cursor?

1004

What is raw datatype in oracle?

1136

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?

1046

Point the difference between translate and replace?

1088

What are the major difference between truncate and delete?

1058

What is a sub query? Describe its types?

1018

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

1007

Point out the difference between user tables and data dictionary?

983

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

948

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

1367

What do you mean by merge in oracle?

996

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do I connect to oracle?

1031

Can the query output be sorted by multiple columns in oracle?

992

How to assign query results to variables?

1050

How to create a new tablespace in oracle?

987

How to delete a column in an existing table in oracle?

1073

What is the Tune Query

2292

How to connect the oracle server as sysdba?

1078

How to delete a user account in oracle?

974

Please explain oracle data types with examples?

1073

How to connect to the server with user account: sys?

1022

What is the difference between truncate & delete command?

1183

defination of bitmap index

2126

How to work with data objects interactively?

984

What privilege is needed for a user to connect to oracle server?

994

Is oracle a programming language?

989

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