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

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

Oracle,

2066

Can a field be used in a report without it appearing in any data group ?

Oracle,

4 8350

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

Oracle,

1 6349

Can a formula column referred to columns in higher group ?

Oracle,

2554

Can a formula column be obtained through a select statement ?

Oracle,

2382

Is it possible to insert comments into sql statements return in the data model editor ?

Oracle,

2638

Is it possible to disable the parameter from while running the report ?

Honeywell, Oracle,

1 4212

When a form is invoked with call_form, Does oracle forms issues a save point ?

Oracle,

1 5067

Can a property clause itself be based on a property clause ?

Oracle,

1 3725

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

Oracle,

2342

What are the sql clauses supported in the link property sheet ?

Oracle,

1 7115

What is trigger associated with the timer ?

Oracle,

1 6811

What are the trigger associated with image items ?

Oracle,

1 6930

What are the different windows events activated at runtime ?

Oracle,

2948

Un-Answered Questions { Oracle }

If you are working Microsoft excel, which type of file you used .excel or .csv?

684

Can we connect to ORACLE db using Windows Authentication?

1310

What is bind variables in oracle reports?

What are the steps involved in instance recovery in oracle?

594

How will you write a query to get a 5th rank student from a table student_report?

1926

What is difference between cartesian join and cross join?

1162

How to change user password in oracle?

1101

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2575

What is the difference between oracle media recovery and crash recovery?

1216

What is pct free/pct used/pct increase parameter in segment?

616

What is an oracle recycle bin?

1066

Can we invoke one form from another in a multi-forms application?

1179

Which is better Oracle or MS SQL? Why?

5043

How is mapping of name of dll and function done?

How would you begin to troubleshoot an ORA-3113 error?

2129

For More Un-Answered { Oracle } Questions Click Here