Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

IBM Oracle General Interview Questions
Questions Answers Views Company eMail

How to Remove the 3rd highest salary person record from table?

 9 17668

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 6503

what is the difference between table and veiw?

 4 6485

Which Department has MOST NUMBER of employees?

 8 49508

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

 1 3527

how to retrive xml data for using sql query?

 3 6427

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

 1 4261

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

 1944

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'));

 1445

Post New IBM Oracle General Interview Questions


IBM Oracle General Interview Questions


Un-Answered Questions

Explain what is the architecture of abinitio?

935

Is it possible to combine asp.net webforms and asp.mvc and develop a single web application?

758

Explain about transactional logging?

5

How do I paste a list into a table?

429

How long to learn object oriented programming?

821

WHAT DO YOU WANT TO ACHIEVE IN YOUR LIFE IN MANAGEMENT FIELD?

2115

Explain how cookies work. Give an example of cookie abuse.

897

What is drupal hosting?

107

What are different type of Statements in SQL Logic?

77

Explain me is multiple inheritance supported in php?

778

Describe in brief system database.

774

What is Planning horizon and how does it impact MRP and MPS run results ?

3972

Laying bitumen concrete 40mm thick using 0.1372 cum of 13.2 10mm metal ,0.2387 cum of 10 5mm metal...what did it means please explain me how much cum of 10 mm metal need?

1673

How to configure second level cache in hibernate?

272

How to set position of a sencha touch component?

792