interview questions

Question

Post reply

interview questions

sandhyarao49

SSCrazy

Points: 2215
More actions
April 10, 2008 at 5:57 am

#123291

Hi Could any one tell me the answers for these questions.
1. how do we troubleshoot a datbase if it is in suspect mode.What is the reason for a database to be in suspect mode.
2. how can we move a file from C drive to D drive, so that the file location in C drive is completely moved .
3.In a particular primary file group there are many objects.
How can we move some of the objects from this primary file group in to another file group.
4. can we install a sql server on a remote server so that it will not ask any inputs like domain name, authentication modes. .
5.If we want to implement clustering , can we use the virtual ip address on clustering as the ip address of our system or we have to use another ip address for clustering
6. In 2000 we have DTs package.can we run the same DTS package in 2005.

Viewing 6 posts - 1 through 5 (of 5 total)

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

Anipaul SSC-Insane Points: 24681 More actions · Answer 1

Q1: go thru http://www.codeproject.com/KB/reporting-services/SQL_2005_Suspect_Database.aspx

Q4: Go thru

http://technet.microsoft.com/en-us/library/ms144296.aspx

thasteve SSCrazy Points: 2707 More actions · Answer 2

q2: alter database ... file = new directory and filename

q3: alter index and table with option on to select on which filegroup it should be stored

q5: the cluster itself will have a virtual address which can be used

q6: yes most can still be run there is an integration services migration wizard avaiable

CodeGuys SSC Enthusiast Points: 112 More actions · Answer 3

Please gothrough below link,

SQL interview Questions and answers

-------------------------------------------------------------------------------------
CodeGuys,

Check my website for frequently asked interview questions and answers.

http://www.techieclues.com

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

CodeGuys (5/14/2015)
Please gothrough below link,
SQL interview Questions and answers

There are a number there that are wrong. They're great for figuring out who, in an interview, went memorising questions from the internet and who actually knows their stuff.

For example, DBCC stands for Database Console Command, not Database Consistency Checker.

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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 5

sandhyarao49 (4/10/2008)
Hi Could any one tell me the answers for these questions.
1. how do we troubleshoot a datbase if it is in suspect mode.What is the reason for a database to be in suspect mode.
2. how can we move a file from C drive to D drive, so that the file location in C drive is completely moved .
3.In a particular primary file group there are many objects.
How can we move some of the objects from this primary file group in to another file group.
4. can we install a sql server on a remote server so that it will not ask any inputs like domain name, authentication modes. .
5.If we want to implement clustering , can we use the virtual ip address on clustering as the ip address of our system or we have to use another ip address for clustering
6. In 2000 we have DTs package.can we run the same DTS package in 2005.

These look like DBA interview questions.

If we told you, you would simply memorize, perhaps badly. You need to do all these things to understand them. Get yourself a copy of the Developer's Edition and start learning.

To be honest, if you haven't done the first 3 a dozen times each before you apply for a job in the world of SQL Server, you need to study a whole lot more before you consider applying for the job.

You should also learn how to use Google. 😉

--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)