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 1270

Can we create trigger on materialized view in oracle?

950

Does oracle partitioning improve performance?

961

What are the different types of partitions in oracle?

929

What are the types of partitions in oracle?

993

What is a partition in oracle?

1061

How can I see all tables in oracle?

971

Can we store images in oracle database?

958

Does facebook use oracle?

996

What are the advantages of oracle 12c?

1136

What are the advantages of oracle?

981

What is oracle used for?

989

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

949

What is the use of oracle?

1003

Why is oracle so popular?

947

Un-Answered Questions { Oracle }

Explain the use of grant option in exp command.

1024

what does the no logging option do? Why would we use it?

523

List five most important parameter in 9i affecting performance?

523

What is an Oracle index?

1622

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

2885

Explain the blob datatype?

1035

How to convert characters to times in oracle?

979

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

547

How to use "in" parameter properly?

1018

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2061

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1062

What are the five functions of a database?

570

Explain oracle 12c new features for developers?

1007

How different is ms access and oracle?

997

What are some indications that you need to increase the shared_pool_size parameter?

529

For More Un-Answered { Oracle } Questions Click Here