Need answers for interview questions...

Question

Post reply

Need answers for interview questions...

s1123

Mr or Mrs. 500

Points: 567
More actions
February 28, 2012 at 6:50 am

#251450

Hi guys

can u guys tell me the answers to these question …PLZ

1) What is the purpose of Msdb database? If you delete msdb database insatance is running or not?

2) Login cannot access? How can you trouble shoot?

3) What is the stored procedure for generate ERRORLOG?

4) What is proxy server? Why do u need it?

5) What is statistics and what do u get from statistics?

6) When updation & insertion is going on back job has to wait or not?

7) Sql server is stopped, Login got expired? How you will trouble shoot?

8) How many MDF & LDF we can create for Database?

9) How do you check the health of Sql server? Is there any automation plan?

10) What tool we use configure allow remote area connections?

11) What is the stored procedure to see no of instances?

12) What is the service pack & hotfix/ cumulative update?

13) Will log file contains pages?

14) T-log full what error you will get?

15) What are the service tickets?

16) Database went to suspect mode what will you do?

17) How do you find Databases in logshipping?

Thanku very much in advance

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 1

satishm94 (2/28/2012)

Hi guys

can u guys tell me the answers to these question …PLZ

At the risk of being rude, my answer is "No". Part of being a DBA or whatever is knowing these things and knowing how to find the answers to such things. Please learn to use Books Online and Google to find the answers to these rather standard interview questions.

--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.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 2

satishm94 (2/28/2012)

1) What is the purpose of Msdb database? If you delete msdb database insatance is running or not?

I know the answer to that is in Books Online

2) Login cannot access? How can you trouble shoot?

That question is getting at your troubleshooting methodology, not someone else's. They want to see how you work through a problem

3) What is the stored procedure for generate ERRORLOG?

Google or Book Online

4) What is proxy server? Why do u need it?

No such thing as a proxy server in SQL Server

5) What is statistics and what do u get from statistics?

Google or Book Online

6) When updation & insertion is going on back job has to wait or not?

Huh?

7) Sql server is stopped, Login got expired? How you will trouble shoot?

See question 2.

8) How many MDF & LDF we can create for Database?

That's definitely in Books Online

9) How do you check the health of Sql server? Is there any automation plan?

Google (and the term 'health' is a little vague.)

10) What tool we use configure allow remote area connections?

What is a remote area connection?

11) What is the stored procedure to see no of instances?

Google or Book Online

12) What is the service pack & hotfix/ cumulative update?

Seriously? Google this.

13) Will log file contains pages?

Maybe.

14) T-log full what error you will get?

Google this.

15) What are the service tickets?

Seriously? Google this.

16) Database went to suspect mode what will you do?

Google or Book Online

17) How do you find Databases in logshipping?

Google or Book Online

Interviews are about what you know, not what you memorise from someone else, and the first thing a DBA should know is how to research a topic, so being familiar with Books Online and google.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 3

Koen Verbeeck

SSC Guru

Points: 259015

February 28, 2012 at 7:24 am

#1452588

GilaMonster (2/28/2012)

satishm94 (2/28/2012)

4) What is proxy server? Why do u need it?

No such thing as a proxy server in SQL Server

Maybe proxy accounts in SQL Agent?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Brandie Tarvin SSC Guru Points: 172918 More actions · Answer 4

Koen Verbeeck (2/28/2012)

GilaMonster (2/28/2012)

satishm94 (2/28/2012)

4) What is proxy server? Why do u need it?

No such thing as a proxy server in SQL Server

Maybe proxy accounts in SQL Agent?

No. Based on the login expiration question, this is a mix of Windows OS and SQL Server questions to see how much the interviewee knows about how SQL Server functions within a Windows AD environment.

EDIT: In fact, looking at the later questions, it seems as if the interviewer realized his would-be employee knew nothing about SQL Server and wanted to see if this person had at least memorized answers to the exam questions.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

GSquared SSC Guru Points: 260824 More actions · Answer 5

satishm94 (2/28/2012)

Hi guys

can u guys tell me the answers to these question …PLZ

1) What is the purpose of Msdb database? If you delete msdb database insatance is running or not?

2) Login cannot access? How can you trouble shoot?

3) What is the stored procedure for generate ERRORLOG?

4) What is proxy server? Why do u need it?

5) What is statistics and what do u get from statistics?

6) When updation & insertion is going on back job has to wait or not?

7) Sql server is stopped, Login got expired? How you will trouble shoot?

8) How many MDF & LDF we can create for Database?

9) How do you check the health of Sql server? Is there any automation plan?

10) What tool we use configure allow remote area connections?

11) What is the stored procedure to see no of instances?

12) What is the service pack & hotfix/ cumulative update?

13) Will log file contains pages?

14) T-log full what error you will get?

15) What are the service tickets?

16) Database went to suspect mode what will you do?

17) How do you find Databases in logshipping?

Thanku very much in advance

Yes.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 6

Lynn Pettis

SSC Guru

Points: 442447

February 28, 2012 at 9:13 am

#1452684

GilaMonster (2/28/2012)

satishm94 (2/28/2012)

6) When updation & insertion is going on back job has to wait or not?

Huh?

Basically, do INSERTs and UPDATEs block a backup from running.

Brandie Tarvin SSC Guru Points: 172918 More actions · Answer 7

Lynn Pettis (2/28/2012)

GilaMonster (2/28/2012)

satishm94 (2/28/2012)

6) When updation & insertion is going on back job has to wait or not?

Huh?

Basically, do INSERTs and UPDATEs block a backup from running.

Depends. How poorly written is the code and what version of Windows 3.x are you running on?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

s1123 Mr or Mrs. 500 Points: 567 More actions · Answer 8

Hi.

actually i have 70 questions with me and i googled everything and foundout the answers..

and

i did found answers for some of the questions i posted but i didnt understand..

and

for others i couldnt found answers.....

and

some are come with real time experience.. as i dont have much real time experience , i thought one of u guys might know the answers..

thanks

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 9

satishm94 (2/28/2012)

Hi.

actually i have 70 questions with me and i googled everything and foundout the answers..

and

i did found answers for some of the questions i posted but i didnt understand..

and

for others i couldnt found answers.....

and

some are come with real time experience.. as i dont have much real time experience , i thought one of u guys might know the answers..

thanks

Here is the problem many of us have, giving others answers to memorize to possibly get a job for which they really aren't qualified.

We are willing to help people learn and become better at their chosen career.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 10

satishm94 (2/28/2012)

Hi.

actually i have 70 questions with me and i googled everything and foundout the answers..

and

i did found answers for some of the questions i posted but i didnt understand..

and

for others i couldnt found answers.....

and

some are come with real time experience.. as i dont have much real time experience , i thought one of u guys might know the answers..

thanks

Uh, no... I'm just not buying it for questions like...

1) What is the purpose of Msdb database?

--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.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

s1123 Mr or Mrs. 500 Points: 567 More actions · Answer 11

s1123

Mr or Mrs. 500

Points: 567

February 28, 2012 at 10:33 pm

#1452913

hi..

thanks Lynn Pettis,

Hi,

Jeff Moden,,

i know the purpose of msdb , but i dont know about the second part of the question..

i got questions from some of my friends...

and

i copied and pasted the questions i couldnt understand and found..

can any one inform moderator delete this thread....

thanks

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 12

satishm94 (2/28/2012)

i know the purpose of msdb , but i dont know about the second part of the question..

...

i copied and pasted the questions i couldnt understand and found..

First Google result for msdb database sql server:

msdb Database

First line:

The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as Service Broker and Database Mail.

At the bottom, in the section restrictions:

The following operations cannot be performed on the msdb database:

* Changing collation. The default collation is the server collation.

* Dropping the database.

* ...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

durai nagarajan SSCoach Points: 15719 More actions · Answer 13

durai nagarajan

SSCoach

Points: 15719

February 28, 2012 at 11:39 pm

#1452927

Hello,

Hope no need to delete the thread but they are suggest to ask help for problems happened in work rather than ask for answers for interview questions.

google is best help for some video tutorial as well.

Regards
Durai Nagarajan

s1123 Mr or Mrs. 500 Points: 567 More actions · Answer 14

s1123

Mr or Mrs. 500

Points: 567

February 28, 2012 at 11:44 pm

#1452929

hi koen..

sry ...

and

thanks for replys guys..