InterviewUp is actively seeking partnerships. Inquire at business@interviewup.com

Flag this interview question as inappropriate Inappropriate
See Answer
We have to write some DTS packages for it.
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
BulkCopy is a tool used to copy huge amount of data from tables and views. But it won't copy the structures of the same.
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
For restoring the master db we have to stop the SQL Server first and then from command line we can type SQLSERVER -m which will basically bring it into the maintenance mode after which we can restore the master db.
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
Log shipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the log shipping. In log shipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
They get stored in master db in the sysxlogins table.
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
Windows mode and mixed mode (SQL & Windows).
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
First I will look to ensure that port settings are proper on server and client Network utility for connections. ODBC is properly configured at client end for connection --Make pipe & read pipe are utilities to check for connection. Make pipe is run on Server and Read pipe on client to check for any connection issues.
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
 SQL SERVER - is for running the databases
SQL AGENT - is for automation such as Jobs, DB Maintenance, Backups
DTC - Is for linking and connecting to other SQL Servers
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 


Check out our newest job listings!

Post a Job! $49 for 60 days



Suggestions & Comments




User Question Statistics
Questions Asked (52)
Questions Updated (0)
Questions Answered (52)
Answers Updated (0)
Share Your Interview Questions
Ask Interview Questions
View Unanswered Questions

















Advertise on this site