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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

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?

1086

What is the usage of synonyms?

1143

What types of joins are used in writing subqueries?

982

What is the difference between post-database commit and post-form commit?

1198

What is blob data type in oracle?

1123

What is the usage of analyze command in oracle?

1093

What is an oracle table?

988

Un-Answered Questions { Oracle }

Which files are vital that should be backed up?

603

Can you assign multiple query result rows to a variable?

987

What is oracle open database communication (odbc)?

1028

What are the limitations of check constraint?

1033

State the various uses of dbcc command?

1060

What are the ansi data types supported in oracle?

947

How different is ms access and oracle?

1038

Is it possible to split the print reviewer into more than one region ?

2280

How to lock and unlock a user account in oracle?

1106

Explain the process of recievables in oracle financials. : oracle accounts receivable

1155

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2021

Step by step explain for the Flat file?

672

How to select an oracle system id (sid)?

1064

What is sharded cluster?

1015

What is procedure overloading in oracle?

1061

For More Un-Answered { Oracle } Questions Click Here