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?

940

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

969

What is a system tablespace and when it is created?

928

What are the different types of database objects?

1008

What is logical backup in oracle?

976

What are the extensions used by oracle reports?

1006

What is the meaning of recursive hints in oracle?

1005

What is bulk copy or bcp in oracle?

1063

What is the usage of control file in oracle?

1038

What is the usage of synonyms?

1077

What types of joins are used in writing subqueries?

945

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

1125

What is blob data type in oracle?

1059

What is the usage of analyze command in oracle?

1048

What is an oracle table?

938

Un-Answered Questions { Oracle }

What are operators in oracle?

1020

Which are the five query types available in oracle?

915

How to write date and time interval literals in oracle?

989

How to list all user accounts in oracle?

987

What are the execution control statements?

1022

How to create a new table in oracle?

1086

How would you go about increasing the buffer cache hit ratio?

2558

Difference between varchar and varchar2 data types?

1133

How to divide query output into groups in oracle?

951

What is an oracle function?

1093

How can you find all the processes on your system?

529

How to use fetch statement in a loop?

988

Any work done in oracle workflow builder. Did you customize or build a new workflow?

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5354

What do you understand by a control file?

519

For More Un-Answered { Oracle } Questions Click Here