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 will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

Can you create a synonym without having a table?

1042

What are the components of logical database structure in oracle database?

1088

What is the usage of save points in oracle database?

964

What is the relationship among database, tablespace and data file?

989

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

1014

What is a system tablespace and when it is created?

972

What are the different types of database objects?

1062

What is logical backup in oracle?

1017

What are the extensions used by oracle reports?

1037

What is the meaning of recursive hints in oracle?

1046

What is bulk copy or bcp in oracle?

1124

What is the usage of control file in oracle?

1088

What is the usage of synonyms?

1143

What types of joins are used in writing subqueries?

983

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a table index in oracle?

1134

Explain the types of exception?

1143

How to divide query output into groups in oracle?

992

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

2049

Explain alias?

1151

How to change system global area (sga) in oracle?

1013

What are the general rules on data consistency?

1009

Can objects of the same schema reside in different tablespace?

1062

Explain how are indexes update?

1064

Does oracle database need java?

1007

What happens if recursive calls get out of control?

1082

What is the scope of a local variable?

1067

What is the meaning of recursive hints in oracle?

1046

What is bulk load in oracle?

1070

Does facebook use oracle?

1032

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