Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 1419

Can we create trigger on materialized view in oracle?

1047

Does oracle partitioning improve performance?

1053

What are the different types of partitions in oracle?

1037

What are the types of partitions in oracle?

1083

What is a partition in oracle?

1207

How can I see all tables in oracle?

1063

Can we store images in oracle database?

1068

Does facebook use oracle?

1086

What are the advantages of oracle 12c?

1239

What are the advantages of oracle?

1078

What is oracle used for?

1075

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

1053

What is the use of oracle?

1080

Why is oracle so popular?

1055

Un-Answered Questions { Oracle }

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

719

Can a formula column be obtained through a select statement ?

2382

Which dba certification is best?

613

How does Oracle guarantee data integrity of data changes?

2460

Explain about your project and its relation to the current job position you are applying to?

1080

How to bring a tablespace online?

1147

Explain how to convert a report into excel sheet.

How can you tell if a tablespace has excessive fragmentation?

638

What is the usage of save points in oracle database?

1018

What are the attributes that are found in a cursor?

1125

Write a trigger example in oracle?

1122

Why do we need object libraries?

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

615

Please explain drop constraint oracle?

1161

How can you determine if an index needs to be dropped and rebuilt?

605

For More Un-Answered { Oracle } Questions Click Here