What type of connectivity does the readpipe/make

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What type of connectivity does the readpipe/makepipe utility test?

Answer
Named Pipes
Explanation
The readpipe and makepipe utility combination will test named pipe connectivity.

(Continued on next question...)

Other Job Interview Questions

• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• How many of these servers can you consolidate?
• What is the best way to have your junior DBA do this?
• Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?
• To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?
• Is it possible to build an index on a view
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• You have just upgraded your server from a single processor by adding 3 additional processors....
• Which of the following is true about the Raw File Source in SQL Server 2005 Integration Services?
• More...