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 10876

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 4025

what is the difference between table and veiw?

4 4258

Which Department has MOST NUMBER of employees?

8 38017

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 2382





how to retrive xml data for using sql query?

3 4579

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 3151

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.

1228

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

726

Post New IBM Oracle General Interview Questions




IBM Oracle General Interview Questions


Un-Answered Questions

I need the recommended size for a 3 phase transformer at 13.8 KV Primary and connected loads of 3000 kVA at 4200 volts and 2375 kVA @ 480 volts AC.

965


what is the role f financial analyst????

1681


What is blob storage in azure?

1


Can opening email give you virus?

1


What is absolute in excel?

4






What is the inorganic chemistry?

116


What is labor and material payment bond?

141


how much tempareture are required to make liquid state of pid leed

1202


What is the naming convention in cakephp?

3


how to calculate earth fault relay current and CBCT ratio

6704


What is spring and why it is used?

9


Which programming language is best?

85


regarding pointers concept

1052


Is python the best language for machine learning?

5


what is a jcl?

147