Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

What the is the diff between local index and global index. give some example.

TCS,

1638

What is snapshot is too old? Give and example for better understand.

TCS,

1601

Can u make a synonym for deptno=10 only from emp table.

TCS,

1 2694

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

Arrow Electronics,

1 2714

how to do daily transactions with out sql* loader control file regesterd in apps?

Arrow Electronics,

1683

1) Does oracle have any table which contain all the exceptions and it's code internally?

CTS,

1749

what is reindexing?

Tata Technologies,

1667

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

IBM,

1688

how to retrieve data from different tables ,place this data in different excel worksheets.

Gap Inc,

1 2790

how to handle exceptions in post production

1419

How to get maxsal , minsal, ename department wise in single query

1549

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1380

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.

1424

Can you tell me how to add new column in existing views?how?How is possible?

FIS,

1439

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

Infosys,

1345

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between substr & instr functions?

1223

Explain the use of indexes option in exp command.

1142

How to define a data field as not null?

1106

Explain the types of exception?

1143

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1927

How to work with data objects interactively?

976

Why cursor variables are easier to use than cursors?

1092

What do database buffers contain?

1023

How to add a new column to an existing table with a default value?

1016

Explain what are the different type of segments?

960

Why is oracle used?

936

How to create a new table in your schema?

1079

Who developed oracle & when?

999

What are the attributes of cursor?

1048

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5543

For More Un-Answered { Oracle General } Questions Click Here