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 16358

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 5735

what is the difference between table and veiw?

 4 5749

Which Department has MOST NUMBER of employees?

 8 47835

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 3180

how to retrive xml data for using sql query?

 3 5859

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 3942

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.

 1694

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

 1179

Post New IBM Oracle General Interview Questions


IBM Oracle General Interview Questions


Un-Answered Questions

Why do we use stringbuilder in c#?

512

What are sources in Tensorflow?

5

What kind of records can be stored in blockchain?

1

What is the importance of biofilms in a watery environment?

2839

What is the purpose of deferred tax liability?

297




What are zones in azure?

302

What does console readline do?

467

Tell me what happens when recursive functions are declared inline?

444

Why we use red hat linux?

460

Should we choose Netscape of Microsoft plateform ?

1649

Arrange The Letters In 4 Words forming a meaningful sentence- Y,S,S,R,O,I,F,L,U,M,E,I?

2776

Explain virtual image?

552

Can we use view in stored procedure?

506

electrical knowelge

732

Which language is used to calculate calculated/column field in power pivot?

5