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?

1105

What are the logical operations?

1121

How to list all indexes in your schema?

1087

What is the data pump export utility?

1078

How to create a new table in your schema?

1078

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

1059

How to see free space of each tablespace?

1033

How to use "out" parameter properly?

1080

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

1017

What are data pump export and import modes?

1062

How to generate query output in html format?

1114

Can sub procedure/function be called recursively?

996

What happens if recursive calls get out of control?

1077

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

991

How to get execution statistics reports on query statements?

1086

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to define an oracle cursor variable?

1027

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2220

What is a subquery?

1120

How to delete a column in an existing table?

1072

What is the database name in oracle?

1018

What are transaction isolation levels supported by oracle?

1066

What is ceil and floor in oracle?

1069

What is a data lock in oracle?

1111

What is a schema in oracle?

1010

What is rowid and rownum in oracle?

1007

What are the differences between char and nchar in oracle?

1092

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1863

How to export your own schema?

1007

What is an Oracle Instance?

1118

How to join two tables in a single query using oracle?

992

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