RE: Oracle Interview questions for Implementation/Maintenence

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 24 Mar 2003 07:37:56 -0600
Message-Id: <24765.322891@fatcity.com>

Santosh

For maintenance, you might study recommended checklists of regular DBA activities. If you have time, you might pick up a copy of Oracle DBA Checklists Pocket Reference. www.orapub.com <http://www.orapub.com> has a DBA checklist available for free.

For implementation, here are some issues to consider:

Database Change Request

Date: __________ Change Request #: ______ Project: ____________________

Requester: __________________________ Requester Phone: ___________

Request is for instance: _______________ System: ________________

Reason for change:

Data model change approval: ________________ (authorized by division) Date:

Users/systems/teams affected by change, and

how:______________________________

Description of change(s):

Table Change

__________________ _______________________________________________

New tables: Size (# of rows) Growth pattern (static, load/purge, steady growth, other)

____________ _______ ___ static ___ load/purge ___ steady growth

Retain existing data? ____ yes ____ no Location of scripts: _______________

Requested Date / Time for change implementation: __________________________

Have users/systems/teams been notified? ______

This change was successfully implemented in production
______________________________ Date: _______________

-----Original Message-----
From: Santosh Varma [mailto:vsantosh_at_psi.soft.net] Sent: Monday, March 24, 2003 12:24 AM
To: Multiple recipients of list ORACLE-L Subject: Oracle Interview questions for Implementation/Maintenence

Hello list,

I will be attending interview on oracle..but the position is for Maintenance/Implementation of Software.
Could any one of you provide me with set of questions related to maintenance/Implementation issues in oracle ?

Regards,
Santosh

<http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3 Received on Mon Mar 24 2003 - 07:37:56 CST