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?

943

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

973

What is a system tablespace and when it is created?

933

What are the different types of database objects?

1013

What is logical backup in oracle?

982

What are the extensions used by oracle reports?

1006

What is the meaning of recursive hints in oracle?

1007

What is bulk copy or bcp in oracle?

1073

What is the usage of control file in oracle?

1043

What is the usage of synonyms?

1083

What types of joins are used in writing subqueries?

948

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

1127

What is blob data type in oracle?

1061

What is the usage of analyze command in oracle?

1051

What is an oracle table?

948

Un-Answered Questions { Oracle }

What is oracle sid?

903

How to rebuild an index in oracle?

990

Explain the different normalization forms?

1032

What do you understand from cache fusion?

How to create a single index for multiple columns?

992

How to shutdown your 10g xe server from command line?

1032

What is the difference between a user and a schema in oracle?

1002

What skills do you need to be an administrator?

511

What are the different types of trigger and explain its various uses and functions?

1028

How do I start tns listener?

999

Explain what are the different type of segments?

920

Explain mutating triggers.

990

What are the differences between char and varchar2 in oracle?

1098

What operating systems are supported by oracle database 10g xe?

998

What is the function of grid naming service used in oracle rac

For More Un-Answered { Oracle } Questions Click Here