SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Interview Questions


Interview Questions

Author
Message
komal145
komal145
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4753 Visits: 1240
Hi..I had an interview and had few questions:

Can anyone please help me finding out answers for the below questions?

1) Design table to track phone?
2) how to troubleshoot high volume data?
3)How to identify performance issues.
4)Which statement is running slow, how to find it.
5) How to Optimize stored procedures ?
6)Suppose I hv 3 SP. SP A, SP B and SP C. SP A calls SP B and SP B calls SP C. If there is a problem with SP C then how we gonna use TRY and CATCH?


Thanks,
komal
Sean Lange
Sean Lange
SSC Guru
SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)

Group: General Forum Members
Points: 149233 Visits: 18575
Questions 1 and 5 do not have enough details to provide an answer. I would be asking for a lot of clarity about what those mean. 2, 3 and 4 are not questions that have an answer. They are intended to start a discussion about how to do those things. This is more of a role playing technique than anything else. If you can discuss a number of things you would do that is what they are after. Of all of those I find the "how do you optimize a procedure" to be the most outlandish of them all. The interviewer wants to see if you know that the question is loaded. There is not a formula for this. It is more of an art than a science. Optimizing queries takes the culmination of all your knowledge in one location. Even worse is that you might optimize a query today and in a year you go back and realize a number of improvements you could make because you have learned new things.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
ravulas2007
ravulas2007
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 68
design table to track phone? HeheCrazy
what kind of question is that?
komal145
komal145
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4753 Visits: 1240
Sorry the questions is like this: Design a table, how to track phone call.
Sean Lange
Sean Lange
SSC Guru
SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)

Group: General Forum Members
Points: 149233 Visits: 18575
komal145 (12/4/2012)
Sorry the questions is like this: Design a table, how to track phone call.


I stand by my comment that this entirely too vague to provide an answer. What does that mean? Do you want to know from the perspective of a cell phone provider? billing? etc. Track what? Do you need to know which towers the calls is handled from? Do you need to know the total time spent on a given providers network? Or do you want to track a phone call from the perspective of one end of the phone call. Maybe from the perspective of a amusement park you want to track the phone call so you can monitor traffic flow of pedestrians. Maybe you just want to know the number called and the call duration. See my point?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Your Name Here
Your Name Here
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1077 Visits: 873
Sorry to be a bit off-topic but this thread flashed me back to an interview I had years ago. The 'technical' questions about troubleshooting were surprisingly specific and detailed. After more than a few - all along the same basic problem - I stopped the interview and asked why all the questions centered around one type of issue. After a few moments of dead air, they finally admitted they had a problem with one of their production databases and was looking for ways to fix it.

I left shortly after.
rhythm.varshney
rhythm.varshney
Mr or Mrs. 500
Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)Mr or Mrs. 500 (598 reputation)

Group: General Forum Members
Points: 598 Visits: 195
komal145 (12/4/2012)
Hi..I had an interview and had few questions:

Can anyone please help me finding out answers for the below questions?

1) Design table to track phone?

It totally deppends on the business requirements means what data they want to store.


2) how to troubleshoot high volume data?
3)How to identify performance issues.
4)Which statement is running slow, how to find it.
5) How to Optimize stored procedures ?

For above question as Sean suggested these are topic for discussion and you can find out lot of articles on little google search.


6)Suppose I hv 3 SP. SP A, SP B and SP C. SP A calls SP B and SP B calls SP C. If there is a problem with SP C then how we gonna use TRY and CATCH?
Thanks,
komal

May be I did not understand the question because what does mean how to use TRY and CATCH or what is the relation of having child procs with TRY-CATCH.
Alan Burstein
Alan Burstein
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32572 Visits: 8578
Your Name Here (12/5/2012)
Sorry to be a bit off-topic but this thread flashed me back to an interview I had years ago. The 'technical' questions about troubleshooting were surprisingly specific and detailed. After more than a few - all along the same basic problem - I stopped the interview and asked why all the questions centered around one type of issue. After a few moments of dead air, they finally admitted they had a problem with one of their production databases and was looking for ways to fix it.

I left shortly after.


That is a great story. Hilarious! Its a shame that they wasted your time but you got a good story out of it.

-- Alan Burstein


Helpful links:

Best practices for getting help on SQLServerCentral -- Jeff Moden
How to Post Performance Problems -- Gail Shaw

Nasty fast set-based string manipulation functions:
For splitting strings try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL Server 2012+)
To split strings based on patterns try PatternSplitCM
Need to clean or transform a string? try NGrams, PatExclude8K, PatReplace8K, DigitsOnlyEE, or Translate8K

I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. -- Itzik Ben-Gan 2001

toddasd
toddasd
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3330 Visits: 3820
Alan.B (12/5/2012)
Your Name Here (12/5/2012)
Sorry to be a bit off-topic but this thread flashed me back to an interview I had years ago. The 'technical' questions about troubleshooting were surprisingly specific and detailed. After more than a few - all along the same basic problem - I stopped the interview and asked why all the questions centered around one type of issue. After a few moments of dead air, they finally admitted they had a problem with one of their production databases and was looking for ways to fix it.

I left shortly after.


That is a great story. Hilarious! Its a shame that they wasted your time but you got a good story out of it.


I can hear the IT manager yelling down the hall, "Hey Bob, we have another issue on the production database, schedule some more interviews!"

______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (509K reputation)SSC Guru (509K reputation)SSC Guru (509K reputation)SSC Guru (509K reputation)SSC Guru (509K reputation)SSC Guru (509K reputation)SSC Guru (509K reputation)SSC Guru (509K reputation)

Group: General Forum Members
Points: 509593 Visits: 44288
komal145 (12/4/2012)
Hi..I had an interview and had few questions:

Can anyone please help me finding out answers for the below questions?

1) Design table to track phone?
2) how to troubleshoot high volume data?
3)How to identify performance issues.
4)Which statement is running slow, how to find it.
5) How to Optimize stored procedures ?
6)Suppose I hv 3 SP. SP A, SP B and SP C. SP A calls SP B and SP B calls SP C. If there is a problem with SP C then how we gonna use TRY and CATCH?


Thanks,
komal


These are questions that have a very broad scope and are part of the basic skill set required of the person holding the Role of "DBA". They don't have simple answers and they require actual experience doing all of those things. I apologize for the way this is going to sound, but if you can't answer these questions, then you're simply not ready to be a DBA.

Use this as an opportunity to become ready to be a DBA. Buy a copy of the "Developer Edition" and use the questions above as a part of your study guide. Books Online and Google should become close friends. Once you dig into the complexity of how to do the things in the questions you've been asked, you'll understand why it would be difficult for someone on this forum to answer all of your questions to your satisfaction because it would involve the long process of actually teaching you how to be a good DBA.

You should also Google for what a DBA actually is responsible for by searching for DBA job descriptions. Whether you pursue getting certified or not is up to you but the certification books identified by Microsoft are pretty good teaching tools so you might want to invest in a couple of those, as well. Google for Microsoft Certification SQL Server to find more information on those.

Last, but not least, don't expect free love on these types of questions. Like I said, they form a part of the very backbone of becoming a DBA. Becoming a real DBA isn't easy. It's going to take a lot of work on your part. If you believe that you'll enjoy the job and the sometimes very long hours and taking "the heat" when something goes wrong, then it'll all be worthwhile. Just don't expect it to happen overnight because there's a lot to it. You should probably aim first at being an SQL Server Developer and get really good at T-SQL, indexes, and have a really good grasp on all of the idfferent types of objects.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search