MsSQL Server Interview Questions & Answers
MsSQL Server Interview Online Test
1. What is SQL Server ?
Show Answer
2. Error severity 13 indicates what?
Show Answer
3. In which order do you perform an upgrade to SQL Server 2005 for replicated databases?
Show Answer
4. How many Service Packs will be released for SQL Server 2005 in 2007?
Show Answer
5. You setup a linked server from a SQL Server 2000 server to your new SQL Server 2005 server (with defaults), however you cannot execute procedures on the 2005 server. Why not?
Show Answer
6. What is the recommended way to send mail from SQLAgent in SQL Server 2005?
Show Answer
7. When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
Show Answer
8. What the heck does ATN2 do?
Show Answer
9. How does a differential backup know which extents have changed so that it can be very quickly run?
Show Answer
10. If you run this, what does it return?
select applock_mode('public', 'SalesApp', 'Transaction')
Show Answer
11. What does the Queue Reader Agent do in SQL Server 2005 replication?
Show Answer
12. What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
Show Answer
13. The Sort component in SQL Server 2005 Integration Services is what type of component?
Show Answer
14. If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
Show Answer
15. Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
Show Answer
16. Where does Profiler store its temporary data in SQL Server 2005?
Show Answer
17. What is the Service Broker Identifier ?
Show Answer
18. You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
Show Answer
19. How are modified extents tracked in SQL Server 2005 (which internal structures)?
Show Answer
20. What does this return?
Show Answer
21. What does the Log Reader agent in SQL Server 2005 replication do?
Show Answer
22. What does a @@fetch_status of -2 mean in SQL Server 2005?
Show Answer
23. You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
Show Answer
24. You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
Show Answer
25. What is the cost threshhold for parallelism in SQL Server 2005?
Show Answer
26. You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
Show Answer
27. You have an old database that needs to run in compatibility mode 65 on your SQL Server 2005 server. Which framework would you use to manage this database programmatically?
Show Answer
28. You have two Service Broker instances running. One is on SQL1 with the default collation and the other is on SQL2 setup for French collation. Which collation is used for Service Broker messages sent between the instances?
Show Answer
29. What does the max full-text crawl range option do?
Show Answer
30. Make a new copy of the production database each month and then copy that to the SAN. Attach it as a new Scalable Shared Database each month to the reporting servers.
A Scalable Shared Database does not support database snapshots, so you would have to manually create a new database each month with the data view you need and add this as a new Scalable Shared Database to the SAN and each reporting server.
Show Answer