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

Oracle General Interview Questions

Questions Answers Views Company eMail

Describe an oracle table?

1049

What are the differences between primary key and unique key?

1006

What is the difference between substr and instr?

1034

Describe varray?

1056

How can you merge two tables in oracle?

996

How to store pictures on to the database?

969

Explain temporal data types in oracle

1093

List out the difference between commit, rollback, and savepoint?

1029

Does rowid change in oracle?

1 1390

Is rowid unique in oracle?

998

Is primary key indexed by default in oracle?

985

What are triggers in oracle?

1032

What is max rowid in oracle?

1023

What is oracle rowcount?

1080

What is oracle rownum?

947

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Which is better Oracle or MS SQL? Why?

4933

How to execute a stored procedure in oracle?

1084

What are the different types of partitions in oracle?

975

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

1032

How would you change old and new values in an insert, delete and update triggers?

1018

How do we get field details of a table?

978

How to install oracle database 10g xe?

1016

What is background process in Oracle?

1099

How many types of tables supported by oracle?

1074

How do I recompile a procedure in oracle?

962

What is the difference between substr and instr?

1034

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1930

What is oracle update statement with inner join ?

1055

How to write a query with a left outer join in oracle?

1061

How to call a sub procedure?

1093

For More Un-Answered { Oracle General } Questions Click Here