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 16326

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 5712

what is the difference between table and veiw?

 4 5731

Which Department has MOST NUMBER of employees?

 8 47785

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 3172

how to retrive xml data for using sql query?

 3 5838

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 3933

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.

 1691

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

 1172

Post New IBM Oracle General Interview Questions


IBM Oracle General Interview Questions


Un-Answered Questions

What is ide with example?

537

How to fill data in recordset ?

685

What are the server requirements to install wordpress 5.2?

108

Which commands can be used to start jenkins manually?

1

What is the relation between xhtml and css?

466




What are the benefits of ajax?

522

Which is the most stable version of windows 10?

442

How to create a custom exception?

563

What are the user interfaces of interactive lists?

541

What are the options in sap when it comes to fiscal years?

664

sir/ madam i m apearing to rrb bhubaneswar for entrans exam please i want a help to get thruogh this

1727

How did you test the form you developed? How did you taken print?

603

Tell me something about your family background.

768

what defines herbs from other plants?

1399

Explain the examples of techno fossils?

433