What is the difference between the 2 operating modes of Database Mirroring (mentioned in above answer)?

High-Safety Mode is to ensure that the Principal and Mirrored database are synchronized state, that is the transactions are committed at the same time on both servers to ensure consistency, but there is/might be a time lag

What are the operating modes in which Database Mirroring runs?

Database Mirroring runs in 2 operating modes High-Safety Mode and High-Performance Mode.

Does Transparent Data Encryption provide encryption when transmitting data across network?

No, Transparent Data Encryption (TDE) does not encrypt the data during transfer over a communication channel.

What is Transparent Data Encryption?

Introduced in SQL Server 2008 Transparent Data Encryption (TDE) is a mechanism through which you can protect the SQL Server Database files from unauthorized access through encryption. Also, TDE can protect the database backups of the instance on which TDE was setup.

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 different types of database compression introduced in SQL Server 2008?

Row compression and Page compression.

Which autogrowth database setting is good?

Setting an autogrowth in multiples of MB is a better option than setting autogrowth in percentage (%).