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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to check your oracle database 10g xe installation?

1053

How to set a transaction to be read only in oracle?

1146

How to sort output in descending order in oracle?

1107

What are ddl statements in oracle?

1134

How to use attributes of the implicit cursor in oracle?

1068

How to name query output columns in oracle?

1247

What is oracle server autotrace in oracle?

1230

How to rename an index in oracle?

1177

How to update values in a table in oracle?

1084

How to call a stored function in oracle?

1068

How to increment dates by 1 in oracle?

1140

How to define an oracle sub procedure?

1234

How to define an oracle cursor variable?

1095

What is a user account in oracle?

1173

What are internal user account in oracle?

1057

Un-Answered Questions { Oracle }

Explain the use of control file?

1180

How to connect to the server with user account: sys?

1063

Which is faster join or subquery in oracle?

1050

What are the data management skills?

588

What is the use of the Service Knowledge module?

640

What are the built-in functions used for sending Parameters to forms ?

3442

Explain an exception and its types?

1142

What are transaction isolation levels supported by oracle?

1119

What is a user exit program in oracle reports?

1083

Explain cascading triggers.

1123

What is a oracle database?

1111

How to load excel data sheet to oracle database

1081

Is there any link between pr form(purchse requisition)and po form(purchase order)

2795

What is the difference between a primary key & a unique key?

1143

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1399

For More Un-Answered { Oracle } Questions Click Here