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

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

Oracle Interview Questions

Questions Answers Views Company eMail

Oracle

2376

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1661

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1840

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1727

Is it possible to drop a column in a table which contains only one column? How?

1 3196

what is tripstop report?

1835

What is Oracle table?

1 2474

What is an Oracle view?

1 2541

What is an Oracle sequence?

1 2651

What are the types of synonyms?

1 2462

What is a private synonym?

1588

What is a public synonym?

1 2441

What is an Oracle index?

1655

How are the index updates?

1 2632

What does ROLLBACK do ?

1 2860

Un-Answered Questions { Oracle }

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

575

How to create a new table by selecting rows from another table?

1102

How to set up autotrace for a user account?

1059

What is oracle rownum?

952

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2970

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

601

What are active transformation / passive transformations?

What is difference between truncate and delete?

1040

How do you generate file output from sql?

619

What is recycle bin in Oracle?

1149

What are the various configuration files that are used by oracle forms?

1031

what is the difference between functional dependecy and multilevel dependency?

2462

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1947

What are the various constraints used in oracle?

1045

What is the Repository and how many types of repository?

575

For More Un-Answered { Oracle } Questions Click Here