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

Which of the above methods is the faster method?

1 4385

What is the frame & repeating frame?

1 6043

What buil-in routines are used to display editor dynamicaly?

1 3569

What is the main difference between Reports 2.0 & Reports 2.5?

1 3306

List the editors availables in forms 4.0?

1 3773

What are the menu items that oracle forms 4.0 supports?

1 3932

How is link tool operation different between reports 2 & 2.5?

1 3646

The join defined by the default data link is an outer join yes or no?

1 3733

How do you pass the parameters from one form to another form?

2 4927

Do user parameters appear in the data modal editor in 2.5?

1 4005

Explain about horizontal, Vertical tool bar canvas views?

1 4967

What are modal windows?

1 3816

What are the different modals of windows?

1 4634

What is an Lov?

2 5237

Is it possible to split the printpreviewer into more than one region?

1 3655

Un-Answered Questions { Oracle }

Difference between pre-select and pre-query

1047

How can you determine the space left in a file system?

599

How to connect ms access to oracle servers?

949

How to store only time; not date and time?

971

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

540

What is the difference between sharding and partitioning?

942

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

570

How to define a record variable to store a table row?

1019

How to use subqueries with the exists operator in oracle?

981

What is chargeback invoice? How do we create it? : oracle accounts receivable

1298

What is a server parameter file in oracle?

1013

How to use values from other tables in update statements using oracle?

1035

What is the importance of batch source set up in ar? : oracle accounts receivable

1204

When do I need to use a semicolon vs a slash in oracle sql?

1038

How to select some columns from a table in oracle?

1017

For More Un-Answered { Oracle } Questions Click Here