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 7188Suppose 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 38731. 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 4568I 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.
2130src 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'));
1617Post New IBM Oracle General Interview Questions
Your project progressed as planned up until yesterday. Suddenly, an unexpected risk event occurred. You quickly devised a response to deal with this negative risk event using which of the following tools and techniques of Risk Monitoring and Control? A. Risk management plan updates B. Workarounds C. Corrective action D. Additional risk identification
Explain the functionality of yield?
How will you decide to choose the storage volume type while creating it for your application?
What salary are you seeking at Burlington Coat Factory?
Why to choose python over java in selenium?
How can image properties be retrieved in php?
Program lines for the radio button selection and unabling some input variables in section screen
What is double c#?
How to get servletcontext in apache-wicket application?
The area of the h chain, which is between ch1 and ch2 domain, is called as?
Explain the JDBC Architecture?
Why is javascript good for websites?
Give ide's main parts and components?
What is the difference between Hash table and Array list?
What are system tools and applications of windows operating system?