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?

1013

Describe the types of sub query?

993

What are the attributes of the cursor?

1000

What is raw datatype in oracle?

1130

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

1026

Explain about the analyze command in oracle?

1048

Difference between cartesian join and cross join?

1033

Point the difference between translate and replace?

1083

What are the major difference between truncate and delete?

1054

What is a sub query? Describe its types?

1015

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

1002

Point out the difference between user tables and data dictionary?

978

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

948

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

1360

What do you mean by merge in oracle?

993

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1970

How does one get the view definition of fixed views/tables?

1019

What is meant by raw datatype?

1056

How to define a variable to match a table column data type?

982

Is there a function to split a string in plsql?

1053

How index is implemented in oracle database?

1002

What are the oracle differences between nvl and coalesce

1145

How to check your oracle database 10g xe installation?

984

Give syntax for SQL and ORACLE joins.

1092

How many types of tables supported by oracle?

1074

How do I find my oracle client driver version?

1038

Can you tell me how to add new column in existing views?how?How is possible?

1439

What do you understand by database schema and what does it hold?

1230

How to assign query results to variables?

1048

What are the ansi data types supported in oracle?

944

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