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?

1094

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

1224

How to experiment a data lock in oracle?

1113

How to write text literals in oracle?

1120

How to convert times to characters in oracle?

1073

How to install oracle database 10g xe?

1064

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

1148

How to convert numbers to characters in oracle?

1080

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

1131

What are transaction isolation levels supported by oracle?

1117

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

1097

How to connect the oracle server as sysdba?

1133

What is a cursor in oracle?

1232

How to calculate date and time differences in oracle?

1099

What is a select query statement in oracle?

1030

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is Trigger in Oracle?

1244

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2231

Explain what are the uses of rollback segment?

1068

How do I manually uninstall oracle client?

1153

What are the attributes that are found in a cursor?

1122

Can we protect our pl/sql source code?

1084

How will you write a query to get a 5th rank student from a table student_report?

1919

What is the sid in oracle?

1033

Difference between the “verify” and “feedback” command?

1429

How to retrieve values from data fields in record variables?

1174

How can we create the complete backup of data in the oracle.

2202

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2320

what is the difference between restoring and recovering?

1059

What is the difference between alert log file and tarce file ?

2233

How to load data through external tables?

1190

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