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 apply filtering criteria at group level in oracle?

1091

How to define and use table alias names in oracle?

998

What is the relation of a user account and a schema in oracle?

1132

How to start a new transaction in oracle?

1138

How to connect asp pages to oracle servers?

1125

How to create a new tablespace in oracle?

1041

How oracle handles dead locks?

1131

How to convert characters to dates in oracle?

1152

How to create an oracle database manually?

1136

What is a procedure in oracle?

1290

How to create a stored function in oracle?

1158

How to use regular expression in pattern match conditions in oracle?

1079

How to rename a tablespace in oracle?

1130

How to create a new oracle data file?

1078

What is oracle database 10g express edition?

1173

Un-Answered Questions { Oracle }

How to display employee records who gets more salary than the average salary in the department?

1128

What does an oracle dba do?

649

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1996

How to delete a user account in oracle?

1027

what are steps for interface? where is exchange rate defined in which table?

2245

Explain oracle instance.

1234

How to convert characters to dates in oracle?

1152

How to check database size in Oracle?

1259

What is an Oracle Data Segment?

1100

What are the different types of backup available in the oracle?

622

Explain the oracle grid infrastructure?

Difference between inner join vs where ?

1096

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3387

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2395

What is a static data dictionary in oracle?

1197

For More Un-Answered { Oracle } Questions Click Here