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 r the various types of reports

2 8113

if u have one group can u create another from that

1 3358

did u p prepared complex report

2001

what is procedure like symbols of bind and lexical

1 3976

what is bit map and character mode

1 4262

what is place holder column

Oracle, PCS,

3 8385

hiding item in report how like that properly,thats manually but at runtime i want to do

1 3233

from where do u receive the information to develop report

2010

if u develop report do u ask for anything from u r team leader

1 3187

can u call procedure or function is sq l query in reports

1 4322

how will the report recognize the parameter

1 3146

what is difference between group above and group left report

Oracle,

3820

based on parameter value layout of report should change

1 4156

difference between place holder and formula column

Cognizant, IBM, Microsoft,

3 19275

difference between repeating frame and frame

IBM,

3 18130

Un-Answered Questions { Oracle }

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2026

What do you understand by row chaining?

What is recovery manager in Oracle?

1056

How to display employee records who gets more salary than the average salary in the department?

1065

Explain procedure to change characterset of a database.

633

What is set operator oracle?

979

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

601

Mention what are the tools provided in oracle enterprise manager?

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

2071

What is ora-1555 snapshot too old error? Explain in detail?

683

What is archive log in Oracle?

1134

What are the types of data contol?

614

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

649

What are the execution control statements?

1063

When you used JKM ?

587

For More Un-Answered { Oracle } Questions Click Here