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 7640Suppose 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 40641. 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 4750I 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.
2247src 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'));
1748Post New IBM Oracle General Interview Questions
within an emergency scenario what are the safe systems of work a coss can setup as part of is duties
Explain partial class in c#?
What is the difference in record set and dataset?
What is block in ios objective c?
What is the support of mobile devices for WMLScript?
What is an interface in angular?
“Gingerbread” is nickname of which version?
What is the carbon cycle?
Information regarding shop & establishment registration of propiertor ship & require document for this
Will there be a .net compact framework 3.0 release with release of .net framework 3.0?
Explain about NTFS volume.
swap 2 numbers without using third variable?
What is a node js developer?
how does a shunt reactor maintains the bus voltage???
how to create flat file datasubmission in qtp