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

Oracle General Interview Questions

Questions Answers Views Company eMail

How to turn on or off recycle bin for the session?

1174

What are the logical operations?

1170

How to list all indexes in your schema?

1141

What is the data pump export utility?

1133

How to create a new table in your schema?

1129

What happens to the data files if a tablespace is dropped?

1107

How to see free space of each tablespace?

1082

How to use "out" parameter properly?

1124

Can you drop an index associated with a unique or primary key constraint?

1069

What are data pump export and import modes?

1111

How to generate query output in html format?

1211

Can sub procedure/function be called recursively?

1050

What happens if recursive calls get out of control?

1139

How to get a list of all background sessions in the database?

1040

How to get execution statistics reports on query statements?

1153

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a package in oracle?

1161

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4233

What are operators in oracle?

1102

Give the different types of rollback segments.

1080

Explain oracle left join with an example?

1063

What are the benefits of ordbms?

1137

How do we represent comments in oracle?

1097

What is data file?

1150

What is a schema in oracle?

1065

What are the set operators union, union all, minus & intersect meant to do?

1030

What is program global area (pga) in oracle?

1091

How to export data with a field delimiter?

1086

What is merge in oracle?

1096

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2191

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

2008

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