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 7450Suppose 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 39781. 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 4697I 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.
2193src 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'));
1697Post New IBM Oracle General Interview Questions
Why were the Gothic Churches able to have large stain glass windows?
List out some basic elements in html5?
What is microsoft register server?
How do you create a reference in excel?
Difference between obj-validate and edit-validate?
What are the types of constructor's in ooabap ?
What is an auto-encoder?
What is the css3 hsl() function?
What is the use of stop statement?
Explain lock escalation? : Transact sql
What is deployer?
Can we avoid deletion of records through validation rules? : salesforce validation rules
What is active directory? How it works?
How to calculate the crank rod in slab
What are the main error types in php and how do they differ?