Database Interview Questions

Interviews World

		.Net Framework(43)
		.Net Memory Management(2)
		.Net Web Service(6)
		.Net Remoting(30)
		.Net Security(2)
		.Net Threading(8)
		.Net Architecture(2)
		Basic C#(33)
		VB.Net(2)
		.Net Window Service(3)
		.Net Window Forms(14)
		Advanced C#(25)
		Visual Studio 2003(2)
		Visual Studio 2005(2)
		Visual Studio 2008(2)
		Visual Studio 2010(2)

		ASP.NET General(7)
		ASP.NET Caching(9)
		ASP.NET Ajax(13)
		ASP.NET Session(7)
		ASP.NET Localisation(2)
		ASP.NET 1.1(2)
		ASP.NET 2.0(2)
		ASP.NET 3.5(11)
		ASP.NET 4.0(2)

		SQL Server 2000(20)
		SQL Server 2005(24)
		SQL Server 2008(42)

General ADO.NET(7)

Object Oriented (27)

		Basic Object Oriented(19)
		Advanced Object Oriented(8)

MS Dynamics (1)

		MS Dynamics GP 9(2)
		MS Dynamics GP 10(1)
		MS Dynamics Soloman(2)
		MS Dynamics CRM 3.0(2)
		MS Dynamics CRM 4.0(2)
		MS Dynamics CRM 5.0(2)

Sharepoint (65)

		Basic SharePoint(35)
		SharePoint Server 2003(4)
		SharePoint Server 2007(25)
		SharePoint Server 2010(2)

Automation Testing(15)

Welcome to Interviews World

1

What is the error handling in stored procedures of SQL Server 2005?

Which DML statements are affected by the IGNORE-DUP-KEY = ON index option in SQL Server 2008?

If you are running Profiler in a database set to 80 compatibility modes in SQL Server 2008, are the security requirements for show plan data determined?

If you have overlapping terms, for example "SQL" and "SQL Server" in a SQL Server 2008 Thesaurus file, which term is applied as a rule?

A database can have 1,024 active in-row text data pointers in it. If you need to re-use some of those, how can you free up existing pointers for re-use?

What is the use of store procedure sp(underscore)validname?

SQL Server allows you to create indexes with the option IGNORE_DUP_KEY = ON (or just IGNORE_DUP_KEY before SQL Server 2005). Which of the following statements about this option are true?

Integrated full-text search in SQL Server 2008, which of these are language specific?

In SQL Server 2008 if SSMS is not installed on your machine and You are trying to run some scripts using SQLCMD but keep getting errors that your password has expired. What should you do?

If you have two overlapping terms in a SQL Server 2008 thesaurus file and both terms are the same length, which is applied?

What are included columns in SQL Server 2005?

What are you trying to run DBCC FREESESSIONCACHE command?

Which command prompt tool will help me to append output data from a query into an existing file?

In SQL Server 2005 Algebrizer replaces which component in SQL Server 2000?

Which SSIS packages are used by the Data Collector for a data collector set?

Website Highlights

Newsleter

Enter your Email:

©2007-2008 interviewsworld.com All Rights Reserved. | About Us | Contact Us | Disclaimer | Privacy Policy | Terms Of Service
User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License