IBM Oracle General Interview Questions Answers, IBM Placement Papers, IBM Technical, HR Interview Questions, IBM Aptitude Test Questions, IBM Campus Placements Exam Questions

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 19128

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 7440

what is the difference between table and veiw?

4 7259

Which Department has MOST NUMBER of employees?

8 51168

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 3969

how to retrive xml data for using sql query?

3 7021

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 4687

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.

2185

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

1691

Post New IBM Oracle General Interview Questions

IBM Oracle General Interview Questions

IBM Oracle General Interview Questions (39)

Un-Answered Questions

What is mvc in php laravel?

806

Which case the data to be stored in columnar storage?

How to create short keys in vb.net

2194

What happens if strings are casted into wrong code pages in ms sql server?

1117

How do you use a repeater in actionscript?

783

What is the difference between overriding and overloading in systemverilog?

1002

Do you know what is lambda in python?

1031

What is knowledge representation and reasoning?

941

What the difference is between execute, execute Query, execute Update?

845

Can you redefine a table online?

1119

What is the use of rasp file?

1030

What is difference between server and database?

1095

What is tresurry bills ? how it works?

2877

Define sql delete statement.

1016

What is wrapper class html?

948