Interview Questions

An app can get into InActive state when the user locks the screen or the system prompts the user to respond to some event e.g. SMS message, incoming call etc.

The reputation of a company controls its profit margins. A bad reputation means fewer customers. If you cannot handle difficult customers, that would be a major obstacle for you in a job where dealing with irritated members of the public will be routine. Start generally but select one incident soon afterwards and describe the outcome of that. Be very clear about the circumstance what happened and how you dealt with it, especially how you resolved any tricky issues that arose. The key words here are mutual respect, listening to the customer, being calm in the face of irritation and concluding the situation positively.

- Installing and upgrading the Oracle Server and application tools.

- Allocating system storage and planning future storage requirements for the database system.

- Managing primary database structures (tablespaces)

- Managing primary objects (table, views, indexes)

- Enrolling users and maintaining system security.

- Ensuring compliance with Oracle license agreement

- Controlling and monitoring user access to the database.

- Monitoring and optimizing the performance of the database.

- Planning for backup and recovery of database information.

- Maintain archived data on tape

- Backing up and restoring the database.

- Contacting Oracle Corporation for technical support.

Use the DBMS_SESSION.SET_SQL_TRACE or

Use ALTER SESSION SET SQL_TRACE = TRUE;

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.

Applicant should answer that as a supervisor he/she would analyze actual spend vs. forecast and plan future sales and retail storage. Provide sales adjustments/discounts reporting and analysis, which could be helpful in further analysis of the business. As a supervisor I would ensure, that I keep a track of all the finances and expenses incurred during the process of transportation, salaries and wages of drivers and other helpers in loading and unloading the goods and services. Maintain a ledger for the cost involved in storage and maintenance of goods and services.

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.