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?

977

What are the types of partitions in oracle?

1036

What is a partition in oracle?

1122

How can I see all tables in oracle?

1009

Can we store images in oracle database?

1008

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?

999

What is the use of oracle?

1030

Why is oracle so popular?

997

Un-Answered Questions { Oracle }

What is an oracle table?

988

Explain integrity constraints?

1104

Mention how can you determine what protocol is being used for interconnect traffic?

Is it possible to insert comments into sql statements return in the data model editor ?

2559

What are the execution control statements?

1063

What is a sub query? What are its various types?

1179

Explain coalesce function?

1201

Explain the use of record length option in exp command.

1067

What is the recommended interval at which to run statspack snapshots, and why?

2918

How to change program global area (pga) in oracle?

1092

How different is ms access and oracle?

1038

How to generate query output in html format?

1118

What do you understand by the term 'normalization'?

673

What is the usage of merge statement?

1154

How to count duplicated values in a column in oracle?

1039

For More Un-Answered { Oracle } Questions Click Here