Are you familiar with user exits in reports?

1

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1386

Explain the hardware architecture used in oracle rac?

1

What is the difference between $oracle_base and $oracle_home?

1052

Are truncate and delete commands same? If so why?

1095

How to save query output to a local file?

986

What is a trigger and what are its types in oracle?

1022

What is coalesce function?

1028

what is the difference between substr and instr function in oracle?

1050

How do I become a data manager?

485

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2152

What is the relation of a user account and a schema?

1074

Explain the use of Merge statement in oracle 11g

989

How can Oracle users be audited?

1072

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

1