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 7414Suppose 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 39631. 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 4678I 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.
2181src 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'));
1688Post New IBM Oracle General Interview Questions
What are the mechanical properties required to know before performing maintenance?
what are the differences between and exec cics xctl and exec cics start command?
What is journaling in mongodb?
Which interface change sql requirements in the sap development system to those of the database?
Explain class invariant.
Which parts of lightning components are server-side and which are client-side ?
How do you total a column in excel?
Do you use stored procedure in ado.net?
Can we kill init process?
What is eapps.cfg file?
what is a Depository Participant?
Is it possible for a yielded thread to get chance for its execution again?
What is ngx bootstrap?
Explain what is the transparent?
Tell me how to create an artistic border in adobe photoshop?