3i Infotech MS SQL DBA Interview Questions and Answers

A service account is a special account used by a service or application to access resources on a network.

• Service accounts are used to run services or applications with the necessary permissions and access rights.

• Service accounts are often used in database administration to allow the database service to interact with the operating system.

• Service accounts can be configured with specific permissions and restrictions to li...read more

Replication can be configured by setting up a publication, creating a subscription, and initializing the subscription.

• Set up a publication by selecting the database objects to replicate and defining the publication properties.

• Create a subscription by specifying the subscriber server, database, and synchronization schedule.

• Initialize the subscription by generating a snapshot of the publication and applying it to the sub

Truncate is faster and cannot be rolled back, while delete is slower and can be rolled back.

• Truncate is a DDL command, while delete is a DML command.

• Truncate removes all rows from a table, while delete removes specific rows based on a condition.

• Truncate resets identity column values, while delete does not.

• Truncate cannot be used with a WHERE clause, while delete can.

• Truncate is faster than delete as it does not log ind...read more

Team dynamics refer to the interactions and relationships among team members that impact team performance and effectiveness.

• Effective communication is key for successful team dynamics

• Establishing clear roles and responsibilities helps avoid conflicts

• Encouraging collaboration and mutual respect fosters a positive team environment