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

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1092

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1324

What is auto invoicing? Explain : oracle accounts receivable

1176

Explain the payment term in ar. : oracle accounts receivable

1155

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1485

What is the page protect in reports?

What is the sequence of firing in form level trigger?

How many types of canvases are there. Explain them

What are the system variables can be set by users? Explain them

Explain the types of record group.

What do you understand by format trigger?

What is secure property?

How many types of canvases are there.

What is confine mode and flex mode?

What is current record attribute property?

Un-Answered Questions { Oracle }

What are the different types of failures that occur in Oracle database?

1126

What is a read write transaction in oracle?

1136

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

What are the original export and import utilities?

1271

Explain a data segment?

1112

How to handle a single quote in oracle sql?

1101

Difference between 10g & 11g in odi?

826

Explain what does a control file contain?

1166

What is a nvl function?

1097

What are the types of profiles in ODI?

635

How to assign a tablespace to a users in oracle?

1092

What is snapshot is too old? Give and example for better understand.

1660

Which data loaded are in target db?

618

What is the exact use of Collections?

2197

For More Un-Answered { Oracle } Questions Click Here