Hexacta Most Frequently Asked Latest SQL Server Interview Questions Answers
What Are The Different Authentication Modes In Sql Server And How Can You Change Authentication Mode?
SQL Server has 2 Authentication modes: Windows Authentication and SQL Server and Windows Authentication mode also referred as Mixed Mode.
What Are The Differences In Clustering In Sql Server 2005 And 2008 Or 2008 R2?
On SQL Server 2005, installing SQL Server failover cluster is a single step process whereas on SQL Server 2008 or above it is a multi-step process. That is, in SQL Server 2005, the Installation process itself installs on all of the nodes (be it 2 nodes or 3 nodes). In 2008 or above this has changed, we would need to install separately on all the nodes. 2 times if it is a 2 node cluster or 3 times in a 3 node cluster and so on.
What Is Meant By Active – Passive And Active – Active Clustering Setup?
An Active – Passive cluster is a failover cluster configured in a way that only one cluster node is active at any given time. The other node, called as Passive node is always online but in an idle condition, waiting for a failure of the Active Node, upon which the Passive Node takes over the SQL Server Services and this becomes the Active Node, the previous Active Node now being a Passive Node.
An Active –Active cluster is a failover cluster configured in a way that both the cluster nodes are active at any given point of time. That is, one Instance of SQL Server is running on each of the nodes always; when one of the nodes has a failure, both the Instances run on the only one node until the failed node is brought up (after fixing the issue that caused the node failure). The instance is then failed over back to its designated node.
List Out Some Of The Requirements To Setup A Sql Server Failover Cluster.?
Virtual network name for the SQL Server, Virtual IP address for SQL Server, IP addresses for the Public Network and Private Network(also referred as Hearbeat) for each node in the failover cluster, shared drives for SQL Server Data and Log files, Quorum Disk and MSDTC Disk.
On A Windows Server 2003 Active – Passive Failover Cluster, How Do You Find The Node Which Is Active?
Using Cluster Administrator, connect to the cluster and select the SQL Server cluster. Once you have selected the SQL Server group, in the right hand side of the console, the column“Owner” gives us the information of the node on which the SQL Server group is currently active.
How Do You Open A Cluster Administrator?
From Start -> Run and type CluAdmin (case insensitive) and the Cluster Administrator console is displayed OR you can also go to Start -> All programs -> Administrative Tools -> Cluster Administrator.
Due To Some Maintenance Being Done, The Sql Server On A Failover Cluster Needs To Be Brought Down. How Do You Bring The Sql Server Down?
In the Cluster Administrator, rick click on the SQL Server Group and from the popup menu item choose Take Offline.
What Are The Different Ways You Can Create Databases In Sql Server?
T-SQL; Create Database command.
Using Management Studio
Restoring a database backup
Copy Database wizard
When Setting Replication, Can You Have Distributor On Sql Server 2005, Publisher On Sql Server 2008?
No you cannot have a Distributor on a previous version than the Publisher.
When Setting Replication, Is It Possible To Have A Publisher As 64 Bit Sql Server And Distributor Or Subscribers As A 32 Bit Sql Server.
Yes it is possible to have various configurations in a Replication environment.
What Is The Difference Between Dropping A Database And Taking A Database Offline?
Drop database deletes the database along with the physical files, it is not possible to bring back the database unless you have a backup of the database. When you take a database offline, you the database is not available for users, it is not deleted physically, it can be brought back online.
Which Autogrowth Database Setting Is Good?
Setting an autogrowth in multiples of MB is a better option than setting autogrowth in percentage (%).
What Are The Different Types Of Database Compression Introduced In Sql Server 2008?
Row compression and Page compression.
What Are The Different Types Of Upgrades That Can Be Performed In Sql Server?
In-place upgrade and Side-by-Side Upgrade.
What Are The Recovery Models For A Database?
What Are The Different Authentication Modes In Sql Server And How Can You Change Authentication Mode?
SQL Server has 2 Authentication modes: Windows Authentication and SQL Server and Windows Authentication mode also referred as Mixed Mode.
What Are The Differences In Clustering In Sql Server 2005 And 2008 Or 2008 R2?
On SQL Server 2005, installing SQL Server failover cluster is a single step process whereas on SQL Server 2008 or above it is a multi-step process. That is, in SQL Server 2005, the Installation process itself installs on all of the nodes (be it 2 nodes or 3 nodes). In 2008 or above this has changed, we would need to install separately on all the nodes. 2 times if it is a 2 node cluster or 3 times in a 3 node cluster and so on.
What Is Meant By Active – Passive And Active – Active Clustering Setup?
An Active – Passive cluster is a failover cluster configured in a way that only one cluster node is active at any given time. The other node, called as Passive node is always online but in an idle condition, waiting for a failure of the Active Node, upon which the Passive Node takes over the SQL Server Services and this becomes the Active Node, the previous Active Node now being a Passive Node.
An Active –Active cluster is a failover cluster configured in a way that both the cluster nodes are active at any given point of time. That is, one Instance of SQL Server is running on each of the nodes always; when one of the nodes has a failure, both the Instances run on the only one node until the failed node is brought up (after fixing the issue that caused the node failure). The instance is then failed over back to its designated node.
List Out Some Of The Requirements To Setup A Sql Server Failover Cluster.?
Virtual network name for the SQL Server, Virtual IP address for SQL Server, IP addresses for the Public Network and Private Network(also referred as Hearbeat) for each node in the failover cluster, shared drives for SQL Server Data and Log files, Quorum Disk and MSDTC Disk.
 |
| Hexacta Most Frequently Asked Latest SQL Server Interview Questions Answers |
On A Windows Server 2003 Active – Passive Failover Cluster, How Do You Find The Node Which Is Active?
Using Cluster Administrator, connect to the cluster and select the SQL Server cluster. Once you have selected the SQL Server group, in the right hand side of the console, the column“Owner” gives us the information of the node on which the SQL Server group is currently active.
How Do You Open A Cluster Administrator?
From Start -> Run and type CluAdmin (case insensitive) and the Cluster Administrator console is displayed OR you can also go to Start -> All programs -> Administrative Tools -> Cluster Administrator.
Due To Some Maintenance Being Done, The Sql Server On A Failover Cluster Needs To Be Brought Down. How Do You Bring The Sql Server Down?
In the Cluster Administrator, rick click on the SQL Server Group and from the popup menu item choose Take Offline.
What Are The Different Ways You Can Create Databases In Sql Server?
T-SQL; Create Database command.
Using Management Studio
Restoring a database backup
Copy Database wizard
When Setting Replication, Can You Have Distributor On Sql Server 2005, Publisher On Sql Server 2008?
No you cannot have a Distributor on a previous version than the Publisher.
When Setting Replication, Is It Possible To Have A Publisher As 64 Bit Sql Server And Distributor Or Subscribers As A 32 Bit Sql Server.
Yes it is possible to have various configurations in a Replication environment.
What Is The Difference Between Dropping A Database And Taking A Database Offline?
Drop database deletes the database along with the physical files, it is not possible to bring back the database unless you have a backup of the database. When you take a database offline, you the database is not available for users, it is not deleted physically, it can be brought back online.
Which Autogrowth Database Setting Is Good?
Setting an autogrowth in multiples of MB is a better option than setting autogrowth in percentage (%).
What Are The Different Types Of Database Compression Introduced In Sql Server 2008?
Row compression and Page compression.
What Are The Different Types Of Upgrades That Can Be Performed In Sql Server?
In-place upgrade and Side-by-Side Upgrade.
What Are The Recovery Models For A Database?
There are 3 recovery models available for a database. Full, Bulk-Logged and Simple are the three recovery models available.
What Is The Importance Of A Recovery Model?
Primarily, recovery model is chosen keeping in view the amount of data loss one can afford to. If one expects to have minimal or no data loss, choosing the Full recovery model is a good choice. Depending on the recovery model of a database, the behavior of database log file changes. I would recommend you read more material on log backups and log file behavior and so on to understand in depth.
What Is Replication?
Replication is a feature in SQL Server that helps us publish database objects and data and copy (replicate) it to one or more destinations. It is often considered as one of the High-Availability options. One of the advantages with Replication is that it can be configured on databases which are in simple recovery model.
Post a Comment