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

Oracle General Interview Questions

Questions Answers Views Company eMail

Will you be able to store pictures in the database?

1153

Whether any commands are used for months calculation? If so, what are they?

1125

What is difference between truncate and delete?

1077

What are the benefits of ordbms?

1124

What is a oracle database?

1091

What are the various oracle database objects?

1182

Explain the characteristics of oracle dba?

1159

Explain integrity constraint?

1192

In which language oracle has been developed?

1114

Difference between varchar and varchar2 data types?

1230

What is hash cluster in oracle?

1223

What is the parameter mode that can be passed to a procedure?

1088

How many memory layers are in the oracle shared pool?

1229

What are nested tables?

1200

How do we get field detail of a table?

1112

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is an oracle tablespace?

1083

what is meant by magic query

2217

Please explain compound trigger in oracle?

1082

How do I call oracle stored procedures that take no parameters?

1169

How to select some rows from a table in oracle?

1106

How would you begin to troubleshoot an ORA-3113 error?

2115

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

2214

Explain oracle instance.

1212

Why cursor variables are easier to use than cursors?

1118

What is Segment Advisor in Oracle?

1127

What is MTTR advisor in Oracle?

1121

What happens if you set the sga too low in oracle?

1200

How to work with data objects interactively?

1030

What is control file used for?

1270

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

1202

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