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 the use of Printer Definition file (PRT) in Reports ?

Epson, GE,

1 5943

What is the difference between Anchoring Object and Enclosing Objects ?

GE, Netsoft,

1 19290

What is the use of Page Protect Property?

GE,

1 10320

What is the usage of frame ?

Convergys,

1 4534

What are the type of triggers available in Oracle Reports ?

Convergys, IBM, KPIT, Oracle, TCS,

3 86217

running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?

Convergys,

1 5391

How can you format a character field in a report Layout editor ?

Convergys,

1 4590

What is the use of Data Link in Reports?

BN, Convergys,

3 7228

What is the usage of the confine mode in Layout Editor ?

Convergys,

2 7264

What is the usage of the Flex mode in Layout Editor ?

Convergys,

2 6070

How to solve the error ?Frequency below its group? while running the report. Why it is happened and How to solve that?

Convergys,

2 13465

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

Convergys,

1982

what is the source file of po report?

Convergys,

1 4381

explain tkprof?

Convergys,

1 4968

all steps of bitmap report?

Convergys,

2354

Un-Answered Questions { Oracle }

what is port in oracle? how is it related to database application.

1949

What are different types of transactions in ar? : oracle accounts receivable

1296

types of receipts and detail desription about recipts and tables effected by receipts?

2075

What is a table in oracle?

981

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1044

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2108

State and explain the different types of data models?

944

Explain the difference between sap and oracle?

1029

What are the differences between blob and clob in oracle?

1089

What is oracle datasource?

985

Which database is best to learn?

567

Explain the use of consistent option in exp command.

1066

What is ODI console?

671

What is the use solutions?

591

Have you created sequence? When will you use?

561

For More Un-Answered { Oracle } Questions Click Here