Interview Questions - SQL Server 2008

Why should I learn to solve SQL Server 2008 technical interview questions?

Learn and practise solving SQL Server 2008 technical interview questions and answers to enhance your skills for clearing technical interviews, HR interviews, campus interviews, and placement tests.

Where can I get technical SQL Server 2008 technical interview questions and answers with explanations?

IndiaBIX provides you with lots of fully solved SQL Server 2008 technical interview questions and answers with a short answer description. You can download SQL Server 2008 technical interview questions and answers as PDF files or e-books.

How do I answer SQL Server 2008 technical interview questions from various companies?

You can answer all kinds of SQL Server 2008 technical interview questions by practising the given exercises (short answer type). You can also find the frequently asked SQL Server 2008 technical interview questions with answers from various companies, such as TCS, Wipro, Infosys, CTS, IBM, etc.

What are the basic functions for master, msdb, model, tempdb and resource databases?
  1. The master database holds information for all databases located on the SQL Server instance and is theglue that holds the engine together. Because SQL Server cannot start without a functioning masterdatabase, you must administer this database with care.
  2. The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
  3. The tempdb holds temporary objects such as global and local temporary tables and stored procedures.
  4. The model is essentially a template database used in the creation of any new user database created in the instance.
  5. The resoure Database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata.

What is Service Broker?
Service Broker is a message-queuing technology in SQL Server that allows developers to integrate SQL Server fully into distributed applications. Service Broker is feature which provides facility to SQL Server to send an asynchronous, transactional message. it allows a database to send a message to another database without waiting for the response, so the application will continue to function if the remote database is temporarily unavailable.

Where SQL server user names and passwords are stored in SQL server?
They get stored in System Catalog Views sys.server_principals and sys.sql_logins.

What is Policy Management?
Policy Management in SQL SERVER 2008 allows you to define and enforce policies for configuring and managing SQL Server across the enterprise. Policy-Based Management is configured in SQL Server Management Studio (SSMS). Navigate to the Object Explorer and expand the Management node and the Policy Management node; you will see the Policies, Conditions, and Facets nodes.