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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is a table index?

1168

How a database is related to tablespaces?

1083

How to define a specific record type?

1136

How to estimate disk space needed for an export job?

1105

How to use "if" statements on multiple conditions?

1217

What is the data pump import utility?

1074

How to update a table row with a record?

1065

What is an index associated with a constraint?

1089

What are the numeric comparison operations?

1167

How to delete a column in an existing table?

1130

How to use an explicit cursor without open statements?

1102

Can multiple cursors being opened at the same time?

1117

How to invoke the data pump import utility?

1228

How to pass a cursor variable to a procedure?

1158

How to view the data files in the current database?

1148

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a trigger and what are its types in oracle?

1152

Explain the use of parfile option in exp command.

1138

Explain the use of full option in exp command.

1175

What is using clause and give example?

1108

Explain what are the uses of rollback segment?

1067

How to update a table row with a record?

1065

What is an oracle transaction?

1228

How to check your oracle database 10g xe installation?

1048

Explain alias?

1193

How do I find my oracle client driver version?

1094

Explain integrity constraint?

1209

Is there any function in oracle similar like group_concat of mysql?

1106

What is a user role in oracle?

1183

How to export data with a field delimiter?

1085

Whats the benefit of dbms_stats over analyze?

2064

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