interview questions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » interview questions

interview questions

Rate Topic

Display Mode

Topic Options

Author

Message

sandhyarao49

Posted Wednesday, April 09, 2008 11:04 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

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.

Post #482499

GSquared

Posted Wednesday, April 09, 2008 11:14 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

If these are interview questions for you trying to get a job, I'd have to say the answer is, "I don't know, but I can look it up." If that's the honest answer, for you, then that's the answer to give.

(I have to admit, I don't understand question 4, and don't know the answer to 5, but the rest seem pretty basic. 5 I'd look up, 4 I'd have to ask for clarification.)

- 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

Post #482501

GilaMonster

Posted Wednesday, April 09, 2008 1:36 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:43 AM
Points: 37,678, Visits: 29,933

Is this for a written interview test, or did someone ask you these?

If you're trying to memorise answers for an interview, don't. A good interviewer can see through that very quickly.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #482582

crazy4sql

Posted Monday, February 08, 2010 2:32 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:10 PM
Points: 876, Visits: 3,731

sorry for late, might be you already got the answer. I am just answering on my behalf and you can judge how correct I am :-
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 :- Check the errorlog of sql. If 2005 then it will be good as you can filter based on database. Check data/log files are at its place. Worse scenario when power failure and transaction is corrupt which make this situation, start implementing disaster recovery.

2. how can we move a file from C drive to D drive, so that the file location in C drive is completely moved . :- take database offline/online. Use detach/attach. If the same configuration you want for all coming databse, make this setting in msdb.

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. :-
I think alter database can help. for perticular table, create index and mention the perticular filegroup.

4. can we install a sql server on a remote server so that it will not ask any inputs like domain name, authentication modes. .
even if you install on remote server, it will ask.

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
There are in total 5 ip used for cluster which are physical ip.

6. In 2000 we have DTs package.can we run the same DTS package in 2005.
yes, open the DTS using SSIS.

----------
Ashish

Post #861501

« Prev Topic | Next Topic »

Permissions