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 assign values to variables?

1168

How to retrieve data from an cursor to a record?

1162

How to save query output to a local file?

1089

How to export your own schema?

1051

How to convert character types to numeric types?

1196

What are the system predefined user roles?

1100

How to create a table in a specific tablespace?

1029

How to create a table interactively?

1169

How to drop a stored function?

1187

How to export data to a csv file?

1392

What are the differences between interval year to month and interval day to second?

1070

How to bring a tablespace offline?

1118

What is the order of defining local variables and sub procedures/functions?

1117

How to retrieve data from an explicit cursor?

1111

What are the arithmetic operations?

1154

Un-Answered Questions { Oracle }

How to rename a column in an existing table?

1089

What is the use of lockboxes? : oracle accounts receivable

1270

What is archive log in Oracle?

1187

How to assign data of the deleted row to variables?

1120

Explain the use of file option in exp command.

1180

When configuring sqlnet on the server what files must be set up?

686

What are the advantages of oracle?

1078

What is the usage of merge statement?

1210

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2348

Explain the use of dde package in d2k.

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1208

What is background process in Oracle?

1142

Can we call procedure inside function in oracle?

1153

What are the uses of Oracle Rollback Segment?

1179

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2173

For More Un-Answered { Oracle } Questions Click Here