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

Oracle General Interview Questions

Questions Answers Views Company eMail

What privilege is needed for a user to create views in oracle?

991

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

1121

How to experiment a data lock in oracle?

1008

How to write text literals in oracle?

1028

How to convert times to characters in oracle?

987

How to install oracle database 10g xe?

971

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

1041

How to convert numbers to characters in oracle?

982

How to delete a column in an existing table in oracle?

1025

What are transaction isolation levels supported by oracle?

1009

How to write a query with an inner join in oracle?

989

How to connect the oracle server as sysdba?

1023

What is a cursor in oracle?

1116

How to calculate date and time differences in oracle?

1001

What is a select query statement in oracle?

911

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to save query output to a local file?

980

What happens if you lost a data file?

989

Which is better Oracle or MS SQL? Why?

4846

Explain the use of file option in exp command.

1097

What is the difference between primary key and unique key and foreign key in oracle?

929

What are nested tables?

1118

What are temporal data types in oracle?

1076

Design database draw er diagram for a certain scenario ?

4540

How do we get field details of a table?

941

What is the use of oracle?

993

What is catalog in Oracle?

1285

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1600

How to generate query output in html format?

1051

Describe the types of sub query?

950

How to create a stored program unit?

1139

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