.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Steve Jackman
Imran Ghani
Santhakumar Munuswamy


Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.


Post New Question Subscribe to Interview Questions
 
Quick Links For Interview Questions Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  OOPs  JQuery  JavaScript/VBScript
BiztalkPatten/PracticesIISWCFWPFWWF
NetworkingAptitudeOthers  All    
 

Sql Server Interview Questions and Answers

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

Author: Subhransu Sekhar Jena          Posted Date: October 31, 2014    Category: Sql Server     Points: 40

SQL Server can be started from command line, using the SQLSERVR.EXE. This EXE has some very important parameters with which a DBA should be familiar with. -m is used for starting SQL Server in single user mode and -f is used to start the SQL Server in minimal confuguration mode.

What is blocking and how would you troubleshoot it?

Author: Subhransu Sekhar Jena          Posted Date: October 31, 2014    Category: Sql Server     Points: 40

Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock type. This forces the second connection to wait, blocked on the first.

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

Author: Subhransu Sekhar Jena          Posted Date: October 31, 2014    Category: Sql Server     Points: 40

Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated. SQL Server detects deadlocks and terminates one user's process.
A livelock is one, where a request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering. SQL Server detects the situation after four denials and refuses further shared locks. A livelock also occurs when read transactions monopolize a table or page, forcing a write transaction to wait indefinitely.
Check out SET DEADLOCK_PRIORITY and "Minimizing Deadlocks" in SQL Server books online. Also check out the article Q169960 from Microsoft knowledge base.

How many bits IP Address consist of?

Author: Subhransu Sekhar Jena          Posted Date: October 31, 2014    Category: Sql Server     Points: 40

An IP Address is a 32-bit number.

What are the steps you will take, if you are tasked with securing an SQL Server?

Author: Subhransu Sekhar Jena          Posted Date: October 31, 2014    Category: Sql Server     Points: 40

Again this is another open ended question. Here are some things you could talk about: Preferring NT authentication, using server, databse and application roles to control access to the data, securing the physical database files using NTFS permissions, using an unguessable SA password, restricting physical access to the SQL Server, renaming the Administrator account on the SQL Server computer, disabling the Guest account, enabling auditing, using multiprotocol encryption, setting up SSL, setting up firewalls, isolating SQL Server from the web server etc.
Read the white paper on SQL Server security from Microsoft website. Also check out My SQL Server security best practices

How many layers of TCP/IP protocol combined of?

Author: Subhransu Sekhar Jena          Posted Date: October 31, 2014    Category: Sql Server     Points: 40

Five. (Application, Transport, Internet, Data link, Physical).

How do you define testing of network layers?

Author: Subhransu Sekhar Jena          Posted Date: October 31, 2014    Category: Sql Server     Points: 40

Reviewing with your developers to identify the layers of the Network layered architecture, your Web client and Web server application interact with. Determine the hardware and software configuration dependencies for the application under test.

What is RAID and what are different types of RAID configurations?

Author: Subhransu Sekhar Jena          Posted Date: October 31, 2014    Category: Sql Server     Points: 40

RAID stands for Redundant Array of Inexpensive Disks, used to provide fault tolerance to database servers. There are six RAID levels 0 through 5 offering different levels of performance, fault tolerance.

How do you test proper TCP/IP configuration Windows machine?

Author: Subhransu Sekhar Jena          Posted Date: October 31, 2014    Category: Sql Server     Points: 40

Windows NT: IPCONFIG/ALL, Windows 95: WINIPCFG, Ping or ping ip.add.re.ss

Explain Left Anti Semi Join Operator?

Author: abhays          Posted Date: October 15, 2014    Category: Sql Server     Points: 40

The Left Anti Semi Join operator returns the result set for each row from the first (top) input when there is no matching row in the second (bottom) input. If no join predicate exists in the Argument column, each row is a matching row. Left Anti Semi Join is a logical operator.
« Previous12345678910….7677Next »



Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend