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

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

2316

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,

1977

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

Oracle,

4 7984

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

Oracle,

1 6181

Can a formula column referred to columns in higher group ?

Oracle,

2471

Can a formula column be obtained through a select statement ?

Oracle,

2278

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

Oracle,

2520

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

Honeywell, Oracle,

1 4035

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

Oracle,

1 4896

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

Oracle,

1 3602

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,

2255

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

Oracle,

1 6958

What is trigger associated with the timer ?

Oracle,

1 6640

What are the trigger associated with image items ?

Oracle,

1 6749

What are the different windows events activated at runtime ?

Oracle,

2848

Un-Answered Questions { Oracle }

Who is a database user?

488

How do you run ms_batch file in forms?

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2031

Explain the difference between replace() and translate() functions in oracle?

987

How to run queries on external tables?

999

If you have an example table, what is the best way to get sizing data for the production table implementation?

510

How to find the duplicate rows count from employees table in oracle?

1054

How do you tell what your machine name is and what is its IP address?

2021

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2327

State the difference between a primary key and foreign key?

897

What do you understand by lov and how can it be used?

1033

Explain what are the uses of rollback segment?

973

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1980

How do you set up tablespaces during an oracle installation?

568

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

528

For More Un-Answered { Oracle } Questions Click Here