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 16355

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 5729

what is the difference between table and veiw?

 4 5749

Which Department has MOST NUMBER of employees?

 8 47832

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 5854

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 3941

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

Can we use THIS Pointer in static function – Reason in C++?

334

Why trim span ? How?

1080

Define redefine and its syntax?

539

Recurring Problem Posting i have Journals for sep 2018 that i approved but they are not available to post even though the period is open in Oracle R12 Issues

1253

How to troubleshoot the errors if any issue comes in process builder? : salesforce process builder

199




Will the windows 32-bit applications run if I switch to 64-bit variant of windows 7

440

What is xsi type?

445

viewing entire results after the batch run in qtp Is there is a easier way view the complete results with out opening one by one test scripts

1574

How to concatenate two strings in php?

530

How does the google ranking works?

455

What is CAS and CCS?

209

How do I make powerpoint 16 9?

103

can a network interface in one vpc be attached to an instance that is present in another vpc?

110

You are Amazon and Samsung offers you 10,000 Samsung Galaxy S3s at a 34% discount. Is that a good deal?

1009

How to define the contract groups and maintain?

1156