interview questions

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

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 Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:57 PM
Points: 88, Visits: 410

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

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:24 PM
Points: 8,665, Visits: 4,943

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

- GSquared

"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

SSChampion

Group: General Forum Members
Last Login: Today @ 2:52 PM
Points: 17,103, Visits: 12,204

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

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

Post #482582

ashish.kuriyal

Posted Monday, February 08, 2010 2:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 9:39 PM
Points: 34, Visits: 765

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.

Regards
Ashish
(if drink and drive is prohibited, why pubs and bars have parking space??)

Post #861501

« Prev Topic | Next Topic »

Permissions