Interview Questions

ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>; 

Many times we would like to store information about the user locally in the computer. For example let’s say user has half-filled a long form and suddenly the internet connection breaks off. So the user would like you to store this information locally and when the internet comes back.He would like to get that information and send it to the server for storage.

Modern browsers have storage called as “Local storage” in which you can store this information.

You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.

Some of the standard Business Intelligence tools in the market According to there performance 

1)MICROSTRATEGY 

2)BUSINESS OBJECTS,CRYSTAL REPORTS 

3)COGNOS REPORT NET 

4)MS-OLAP SERVICES

In SQL, UNION  merges the contents of two structurally-compatible tables into a single combined table.

With a positive attitude you see the bright side of life, become optimistic, and expect the best to happen. It is certainly a state of mind that is well worth developing. Not only it enriches one’s experience of life, but it also paves the way for self-development leading one towards attaining the desired results. As regards employment, it is a valuable thing to maintain positive attitude. Whether you are a manager or a subordinate, maintaining positive attitude in the work place brings lots of benefits while allowing you to fulfill your objectives successfully.
A positive frame of mind can help you in many ways, such as:
- Making you feel inspired.
- Identification.
- Believing in yourself and in your abilities.
- You look for solutions, instead of dwelling on problems.
- The most important thing is building relations.

Business intelligence is a concept that covers development of warehousing and business intelligence applications and databases that assist in diagnosing and repairing user issues as well as performance ones. This is an extremely important set of procedures as it engenders quality end-user products and helps company representatives in understanding core issues and resolving them.