1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

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

TCS,

1124

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

TCS,

1089

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

TCS,

1 1947

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

Arrow Electronics,

1 1873

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

Arrow Electronics,

1213

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

CTS,

1274

what is reindexing?

Tata Technologies,

1163

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,

1173

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

Gap Inc,

1 1992

how to handle exceptions in post production

 937

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

 1002

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?

 922

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.

 981

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

FIS,

921

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,

851

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1746

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1925

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??

1605

How do we represent comments in oracle?

618

What is background process in Oracle?

620




Will you be able to store pictures in the database?

629

What is data block in Oracle?

613

How can you merge two tables in oracle?

559

How do I know if oracle client is installed on windows?

488

How will you identify oracle database software release?

518

Explain a data segment?

639

How to create a new user account in oracle?

567

How do I limit the number of oracle database connections generated by weblogic server?

541

What is the difference between hot backup and cold backup in oracle?

518

What are the system predefined user roles?

579

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