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?

1016

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?

982

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Where are the settings stored for each instance in oracle?

1105

What is rowid and rownum in oracle?

1011

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1032

How to connect to a remote server?

1124

Explain index?

1258

Why do we use coalesce function in oracle?

1118

How can we find out the duplicate values in an oracle table?

1046

please explain.. DB architecture ...

2020

What is the usage of analyze command in oracle?

1093

what is the difference between data migration and production migration.

2346

What is oracle used for?

1026

interview questions with answer for cts

2583

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1899

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2970

How to save query output to a local file?

1026

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