Interview Questions

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.

This question provides information on several important aspects of a compliance program. First, it may highlight risks that the compliance officer was unaware of or didn’t fully appreciate (risk assessment). Second, it assesses how well employees are able to apply corporate policies in the context of their role (policy comprehension/retention and training effectiveness). Third, it reiterates and reinforces the employee’s understanding of risks and policies specific to them (training). Interviewees frequently struggle with this question initially and the interviewer may need to provide an obvious example of such a challenge to help the interviewee get started (i.e. gift policy, etc).

The first step in the human resource planning process is Forecasting future human resource needs.

Being positive is important because often a person’s attitude to their work can come across in their writing and presentation. 

Example ::

An admin plays an important role in ensuring that diaries are properly managed and that all outgoing correspondence is well written and all incoming correspondence is read and delivered to the relevant managers quickly. Administrators sometimes provide the first impression a customer has of a business, so a positive and professional outlook is needed at all times.

ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>;