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 7341Suppose 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 39271. 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 4627I 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.
2167src 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'));
1670Post New IBM Oracle General Interview Questions
How to insert an image or raw data into database?
Can any one send me the Sample sanity Test Cases??? Mail id:veerabhadrudu.p@gmail.com
What request type from a rest resource allows one update the contents of a file?
Please explain fork() system call?
What is dependency management tools?
What are the advantages of c++? Explain
what is amode(24), amode(31), rmode(24) and rmode(any)?
What are the Types Of Vg & Explain About Them?
What is ng stand for?
How to convert normal function module to bapi?
Which browsers provide native JSON support?
Define the Term 'workflow'?
What are the different roles involved in the scrum framework?
Tell me what is the function of simple thread poll in embedded system?
What is the distinction between a flimsy customer and thick customer?