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

Can we create trigger on view in oracle?

1 1326

Can we create trigger on materialized view in oracle?

992

Does oracle partitioning improve performance?

992

What are the different types of partitions in oracle?

978

What are the types of partitions in oracle?

1036

What is a partition in oracle?

1122

How can I see all tables in oracle?

1010

Can we store images in oracle database?

1009

Does facebook use oracle?

1031

What are the advantages of oracle 12c?

1180

What are the advantages of oracle?

1028

What is oracle used for?

1026

What is the max number of columns in an oracle table?

1000

What is the use of oracle?

1030

Why is oracle so popular?

997

Un-Answered Questions { Oracle }

Explain the use of full option in exp command.

1116

What privilege is needed for a user to query tables in another schema?

973

Is oracle the best database?

963

Mention how oracle flex asm works?

How to start a new transaction in oracle?

1088

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4522

How to rename an index?

1072

Why cursor variables are easier to use than cursors?

1094

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2131

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2098

How can a single instance environment be converted into rac environment and how will they be different?

What are the different types of backups that are available in oracle?

does odi support web services?

561

When you use CKM?

582

Describe an oracle table?

1049

For More Un-Answered { Oracle } Questions Click Here