Home

interview questions

interview questions

SQL Server

Tuesday, 06 January 2009

Main Menu

Login

Most Popular Category

JAVA

Core Java, J2EE, Struts, ...

Microsoft Technologies

ASP, C#, DotNet, ...

Programming

C++, PHP, VB, ...

SAP

ABAP, Modules, SAP Basics, ...

Testing

QA Testing, Software Testing, ...

Web Technologies

AJAX, Java Script, Web Services, ...

Polls

Does personal networking help in job search?

	Yes
	No
	Can't Say

Interview Questions

interview questions

interview questions

SQL Server

This category contains SQL Server Interview Questions and Answers

Results 1 - 10 of 52

1. What's SQL Server?

Database/SQL Server

SQL Server is a DBMS system provided by Microsoft. SQL ...

2. What is one of the downsides of using RAID 5 as opposed to RAID 1?

Database/SQL Server

The downside of RAID 5 is that write performance can be...

3. Which query will return a list of the synonyms in your database?

Database/SQL Server

select * from sys.synonyms

4. How can you get SQL Server 2005 to simulate multiple processors for query testing?

Database/SQL Server

Use the -P parameter in the startup parameter list. ...

5. Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets?

Database/SQL Server

WITH PERMISSION_SET EXTERNAL_ACCESS

6. In SQL Server 2005, what permissions does a user need to successfully execute the USE command?

Database/SQL Server

CONNECT permission on the target database.

7. If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?

Database/SQL Server

You need to only apply the latest hot fix.

8. What does this return on SQL Server 2005?select NEWSEQUENTIALID()

Database/SQL Server

This returns an error. Explanation: This returns an ...

9. Which key does the OPEN MASTER KEY statement open?

Database/SQL Server

This opens the Database Master Key Explanation: This...

10. What does the DUMP command do?

Database/SQL Server

Backs up the transaction log. Explanation: This comm...

<< Start < Prev 1 2 3 4 5 6 Next > End >>


[ Back ]	Top

Powered by AlphaContent 3.0.3 © 2005-2009 - All rights reserved

SQL Server Interview Questions

New on Interviewduniya.com
Best Questions To Ask in Your Interview Phone Interviews: Tips And Secrets Sample Interview Questions Can Prepare You For the Real Interview How To Have A Successful Interview I Want Confidence 10 Tips to Dress for Success 5 Tips: How to Close a High-Paying Job Deal? How To Ace The College Interview

Instant Messenger

Sponsored Links

Copyright © 2008 InterviewDuniya.com All Rights Reserved.

Partner Site: Maheshwari Matrimony