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 insert multiple rows with one insert statement in oracle?

1134

How to connect ms access to oracle servers?

1056

How to delete all rows a table in oracle?

1119

What is a parameter file in oracle?

1187

Can the query output be sorted by multiple columns in oracle?

1052

Can group functions be used in the order by clause in oracle?

1043

What is a static data dictionary in oracle?

1190

How to assign a tablespace to a users in oracle?

1088

How to drop an existing table in oracle?

1102

What is an oracle data file?

1157

How to revoke create session privilege from a user in oracle?

1068

What is a database table in oracle?

1069

What is an oracle recycle bin?

1062

How to use existing values in update statements using oracle?

1110

Can multiple columns be used in group by in oracle?

1037

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the max number of columns in an oracle table?

1046

List the types of joins used in writing subqueries?

1037

How to convert numbers to characters in oracle?

1077

Differentiate between post-database commit and post-form commit?

1092

Explain an index segment?

1158

What are the major difference between truncate and delete?

1130

What is the dynamic sql in oracle?

1130

What is the Tune Query

2345

Explain about your project and its relation to the current job position you are applying to?

1075

Why is oracle used?

978

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2077

what are bitmap indexes? How does they work?

2302

What is a cursor variable?

1213

How to install oracle database 10g xe?

1060

What is a cursor and what are the steps need to be taken?

1286

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