dbTalk Databases Forums  

Interview type Question

comp.databases.sybase comp.databases.sybase


Discuss Interview type Question in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
raja
 
Posts: n/a

Default Interview type Question - 09-24-2008 , 09:54 AM






Hi,

I am learning Sybase, my PM asked me the following question, Please
help me on this :


You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.


Please give me ur step-by-step level to proceed for the above
scenario.


Thanks in Advance.
With Regards,
Raja.



Reply With Quote
  #2  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: Interview type Question - 09-27-2008 , 01:17 AM






raja wrote:
Quote:
I am learning Sybase, my PM asked me the following question, Please
help me on this :

You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
s/Sybase/Oracle/g - and the same question was asked in
comp.databases.oracle.server.

s/Sybase/DB2/g - and the same question was asked in comp.databases.ibm-db2

Methinks Raja is learning a lot of DBMS all at once.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-4326 whirlpool0 2008-09-27 06:00:06
E61A0DAD8E6326EDAD4E2B40680177A8DDBF21D099A7557F3D 326861F55ECA137676F3
CC89D63BA236FFCE9E9026CEFBE4AC2A987F5872ECDB3AF220 34AA449


Reply With Quote
  #3  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: Interview type Question - 09-27-2008 , 01:17 AM



raja wrote:
Quote:
I am learning Sybase, my PM asked me the following question, Please
help me on this :

You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
s/Sybase/Oracle/g - and the same question was asked in
comp.databases.oracle.server.

s/Sybase/DB2/g - and the same question was asked in comp.databases.ibm-db2

Methinks Raja is learning a lot of DBMS all at once.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-4326 whirlpool0 2008-09-27 06:00:06
E61A0DAD8E6326EDAD4E2B40680177A8DDBF21D099A7557F3D 326861F55ECA137676F3
CC89D63BA236FFCE9E9026CEFBE4AC2A987F5872ECDB3AF220 34AA449


Reply With Quote
  #4  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: Interview type Question - 09-27-2008 , 01:17 AM



raja wrote:
Quote:
I am learning Sybase, my PM asked me the following question, Please
help me on this :

You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
s/Sybase/Oracle/g - and the same question was asked in
comp.databases.oracle.server.

s/Sybase/DB2/g - and the same question was asked in comp.databases.ibm-db2

Methinks Raja is learning a lot of DBMS all at once.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-4326 whirlpool0 2008-09-27 06:00:06
E61A0DAD8E6326EDAD4E2B40680177A8DDBF21D099A7557F3D 326861F55ECA137676F3
CC89D63BA236FFCE9E9026CEFBE4AC2A987F5872ECDB3AF220 34AA449


Reply With Quote
  #5  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: Interview type Question - 09-27-2008 , 01:17 AM



raja wrote:
Quote:
I am learning Sybase, my PM asked me the following question, Please
help me on this :

You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
s/Sybase/Oracle/g - and the same question was asked in
comp.databases.oracle.server.

s/Sybase/DB2/g - and the same question was asked in comp.databases.ibm-db2

Methinks Raja is learning a lot of DBMS all at once.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-4326 whirlpool0 2008-09-27 06:00:06
E61A0DAD8E6326EDAD4E2B40680177A8DDBF21D099A7557F3D 326861F55ECA137676F3
CC89D63BA236FFCE9E9026CEFBE4AC2A987F5872ECDB3AF220 34AA449


Reply With Quote
  #6  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: Interview type Question - 09-27-2008 , 01:17 AM



raja wrote:
Quote:
I am learning Sybase, my PM asked me the following question, Please
help me on this :

You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
s/Sybase/Oracle/g - and the same question was asked in
comp.databases.oracle.server.

s/Sybase/DB2/g - and the same question was asked in comp.databases.ibm-db2

Methinks Raja is learning a lot of DBMS all at once.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-4326 whirlpool0 2008-09-27 06:00:06
E61A0DAD8E6326EDAD4E2B40680177A8DDBF21D099A7557F3D 326861F55ECA137676F3
CC89D63BA236FFCE9E9026CEFBE4AC2A987F5872ECDB3AF220 34AA449


Reply With Quote
  #7  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: Interview type Question - 09-27-2008 , 01:17 AM



raja wrote:
Quote:
I am learning Sybase, my PM asked me the following question, Please
help me on this :

You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
s/Sybase/Oracle/g - and the same question was asked in
comp.databases.oracle.server.

s/Sybase/DB2/g - and the same question was asked in comp.databases.ibm-db2

Methinks Raja is learning a lot of DBMS all at once.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-4326 whirlpool0 2008-09-27 06:00:06
E61A0DAD8E6326EDAD4E2B40680177A8DDBF21D099A7557F3D 326861F55ECA137676F3
CC89D63BA236FFCE9E9026CEFBE4AC2A987F5872ECDB3AF220 34AA449


Reply With Quote
  #8  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: Interview type Question - 09-27-2008 , 01:17 AM



raja wrote:
Quote:
I am learning Sybase, my PM asked me the following question, Please
help me on this :

You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
s/Sybase/Oracle/g - and the same question was asked in
comp.databases.oracle.server.

s/Sybase/DB2/g - and the same question was asked in comp.databases.ibm-db2

Methinks Raja is learning a lot of DBMS all at once.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-4326 whirlpool0 2008-09-27 06:00:06
E61A0DAD8E6326EDAD4E2B40680177A8DDBF21D099A7557F3D 326861F55ECA137676F3
CC89D63BA236FFCE9E9026CEFBE4AC2A987F5872ECDB3AF220 34AA449


Reply With Quote
  #9  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: Interview type Question - 09-27-2008 , 01:17 AM



raja wrote:
Quote:
I am learning Sybase, my PM asked me the following question, Please
help me on this :

You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
s/Sybase/Oracle/g - and the same question was asked in
comp.databases.oracle.server.

s/Sybase/DB2/g - and the same question was asked in comp.databases.ibm-db2

Methinks Raja is learning a lot of DBMS all at once.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-4326 whirlpool0 2008-09-27 06:00:06
E61A0DAD8E6326EDAD4E2B40680177A8DDBF21D099A7557F3D 326861F55ECA137676F3
CC89D63BA236FFCE9E9026CEFBE4AC2A987F5872ECDB3AF220 34AA449


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.