Clover Infotech DBA Consultant Interview Questions and Answers

New SQL Server installation and configuration

• Determine hardware and software requirements

• Install SQL Server software

• Configure server settings and security

• Create and configure databases

• Set up backup and recovery procedures

Database migration involves upgrading a lower version of a database to a higher version.

• Ensure compatibility between the source and target database versions

• Backup the source database before migration

• Use a migration tool or script to transfer data and schema

• Test the migrated database thoroughly before deploying to production

Locks and latches are mechanisms used in database management systems to control access to data and ensure data integrity.

• Locks are used to control access to data by preventing multiple users from modifying the same data simultaneously.

• Latches are lightweight synchronization mechanisms used to protect data structures in memory.

• Locks can be of different types such as shared locks, exclusive locks, and update locks.

• Latche...read more

Isolation level determines how transactions interact with each other in a database.

• Isolation levels include Read Uncommitted, Read Committed, Repeatable Read, Serializable.

• Higher isolation levels provide more data consistency but may lead to more locking and potential performance issues.

• Example: Using Read Uncommitted isolation level allows reading uncommitted data, while Serializable ensures data integrity but may lea...read more