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

What is difference between open_form and call_form?

2 14562

What is new_form built-in?

1 4109

What is a library?

1 3910

What is the advantage of the library?

2 4950

What is strip sources generate options?

1 3473

What are the vbx controls?

1 7488

What is a timer?

1 3748

What are built-ins associated with timers?

2 4291

what are difference between post database commit and post-form commit?

2 18728

What is a difference between pre-select and pre-query?

iFlex,

1 15744

What is trigger associated with the timer?

2 4582

What is the use of transactional triggers?

1 8206

What are the components of Physical database structure of Oracle Database?

4 13196

What are the components of Logical database structure of ORACLE database?

4 14802

What is a Tablespace?

5 9963

Un-Answered Questions { Oracle }

What are named parameters?

1090

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2325

What are the numeric comparison operations?

1112

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2261

How can we use tkprof?

What are the varoius components of physical database structure of oracle database?

1006

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2116

how to send file attachment from oracle forms

2551

Why is oracle used?

938

What are the file systems and volume management techniques used in oracle rac?

Explain integrity constraint?

1161

How much money does a dba make?

580

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

What is the anchoring in reports?

what is the difference between functional dependecy and multilevel dependency?

2462

For More Un-Answered { Oracle } Questions Click Here