Interview Questions

UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Even if you are a fresh graduate, you likely have some experience as an extern. Prepare for this question in advance by thinking of all procedures in which you have assisted. When answering the question, give a detailed but succinct account of your experience and your contribution to the experience.

There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers.

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.

You should have a pretty good idea of what your particular market will bear.If you don't know the particular salary ranges in your area (city and state) and industry,do some research. Make sure you know whether these figures represent just dollars or a compensation package, which may include insurance, retirement pograms, and other value-added benefits.

If you're a woman, make sure you know what men are making doing the same job. You're bound to find a discrepancy. But you should request and expect to earn an equivalent salary, regardless of what female predecessors may have earned.

A Control file records the physical structure of the database. It contains the following information. Database Name ,Names and locations of a database’s files and redolog files. Time stamp of database creation.

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.

The interviewer is attempting to assess how closely your ideal fits with the reality of their organisation. A positive work environment makes employees feel good about coming to work, and this provides the motivation to sustain them throughout the day. When you can find the ideal working environment that best suits your work ethics and personality, you will become more productive and lead a fulfilling life.

- Before answering, take into account how their company is structured in terms of work days, formality, small start-up verses large corporation, etc.
- Focus on wanting an environment that allows for the use and growth of your established skills and qualities.
- Highlight your desire to work in a team-oriented workplace.
- Talk about your work-style and that it blends in well with the company’s vision.