Answer the following questions by circling either true (T) or false (F) 1. T F Every database has more than one primary data file. 2. T F Transaction log helps to restore the database to the point...


Answer the following questions by circling either<br>true (T) or false (F)<br>1. T<br>F<br>Every database has more than one primary data file.<br>2. T<br>F<br>Transaction log helps to restore the database to the point where it failed.<br>3. T<br>F<br>A login name can be disabled temporarily.<br>4. T<br>F<br>The master database is a template for newly created databases.<br>5. T<br>With INIT is a backup option that indicates that SQL Server will not overwrite any<br>F<br>existing backup on the target media.<br>6. Т<br>F<br>Under server security, you can create additional Server Roles.<br>7. T<br>F<br>In simple recovery model, no differential backups are performed.<br>8. T<br>A full backupof a database does not include all objects, system tables, and data.<br>F.<br>Log files are not part of a filegroup and are managed separately from the data space.<br>9. T<br>

Extracted text: Answer the following questions by circling either true (T) or false (F) 1. T F Every database has more than one primary data file. 2. T F Transaction log helps to restore the database to the point where it failed. 3. T F A login name can be disabled temporarily. 4. T F The master database is a template for newly created databases. 5. T With INIT is a backup option that indicates that SQL Server will not overwrite any F existing backup on the target media. 6. Т F Under server security, you can create additional Server Roles. 7. T F In simple recovery model, no differential backups are performed. 8. T A full backupof a database does not include all objects, system tables, and data. F. Log files are not part of a filegroup and are managed separately from the data space. 9. T

Jun 01, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here