Transaction log backups are not possible with simple recovery model

Question $1$ options:

TrueFalse

Question $2(1$ point$)$

$$

Point out the correct statement.

Question $2$ options:

Using differential backups can save available space

Differential backups takes longer than full backup

Question $3(1$ point$)$

$$

To revoke an authorization, we use the command

Question $3$ options:

REVOKE

ALTER

MODIFY

UNDO

Question $4(1$ point$)$

$$

$\_\_\_\_\_\_\_\_\_\_\_\_$ contains backup of the transaction log of the database..

Question $4$ options:

partial

transaction log backup

Question $5(1$ point$)$

$$

Choose the correct one

A Login is used for authentication into a SQL InstanceA User is used for authorization into a$$SQL Database.$$

Question $5$ options:

$1$ is correct, and $2$ is wrong

$1$ is wrong and $2$ is correct

Both are correct

Both are wrong

Question $6(1$ point$)$

$$

SQL Server has the ability to encrypt the data while creating a backup.

Question $6$ options:

TrueFalse

Question $7(1$ point$)$

$$

Choose the incorrect option

Question $7$ options:

RECOVERY option in RESTORE command will leave the database ready to use by rolling back all uncommitted transactions.

If no recovery options are specified, RECOVERY will be taken by default.

NORECOVERY option in RESTORE command will leave the database ready to use by rolling back all uncommitted transactions.

Question $8(1$ point$)$

$$

Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

Question $8$ options:

Rollforward

Rollback

Question $9(1$ point$)$

$$

Following recovery model gives you the most protection against data loss.

Question $9$ options:

Full recovery

Bulk$-$logged

Simple

Question $10(1$ point$)$

$$

Which among the following is a server level principal?

Question $10$ options:

Login ID

Username