Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

interview questions Expand / Collapse
Author
Message
Posted Wednesday, April 09, 2008 11:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Wednesday, April 09, 2008 11:14 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

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
Posted Wednesday, April 09, 2008 1:36 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-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
Posted Monday, February 08, 2010 2:32 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!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 »

Add to briefcase

Permissions Expand / Collapse