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?

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?

982

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

1199

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 }

Explain the benefits and uses lexical parameter.

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2149

Mention what are the benefits of oracle rac?

What is an oracle transaction?

1146

What are the IKM types?

676

Explain oracle 12c new features for developers?

1058

What does database administrator do?

570

what are bitmap indexes? How does they work?

2245

What is a package in oracle?

1102

How to apply filtering criteria at group level in oracle?

1042

what is dynamic SGA and static SGA

4417

How to define Data Block size in Oracle?

1110

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

5410

Explain a data segment?

1068

What is the easiest method to create a file on unix?

570

For More Un-Answered { Oracle } Questions Click Here