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?

1180

What are the logical operations?

1174

How to list all indexes in your schema?

1148

What is the data pump export utility?

1137

How to create a new table in your schema?

1134

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

1110

How to see free space of each tablespace?

1084

How to use "out" parameter properly?

1127

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

1074

What are data pump export and import modes?

1117

How to generate query output in html format?

1216

Can sub procedure/function be called recursively?

1053

What happens if recursive calls get out of control?

1143

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

1047

How to get execution statistics reports on query statements?

1156

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

can u plz provide me oca sql dumps please i need them

1999

What is BBED in Oracle?

1201

How to create a table in a specific tablespace?

1029

What is the disadvantage of User defind function?

2347

How do I escape a reserved word in oracle?

1264

Who developed oracle & when?

1061

What are joins, explain all types of joins?

2366

What is define in oracle?

1114

Write a syntax for update query in oracle?

1076

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1126

How to run create database statement again?

1221

20. Using a set operator, display the client number of all clients who have never placed an order.

2252

What are the limitations of check constraint?

1078

State the difference between a primary key and foreign key?

999

What are dml statements in oracle?

1133

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