Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Co ]: Answer the following questions by circling either true (1) or false (F) 1. T F Every database has more than one primary data

image text in transcribed

Co ]: Answer the following questions by circling either true (1) 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. The master database is a template for newly created databases. 4. T F 5. T F With INIT is a backup option that indicates that SQL Server will not overwrite any existing backup on the target media. 6. T F 7. T F Under server security, you can create additional Server Roles. In simple recovery model, no differential backups are performed. A full backup of a database does not include all objects, system tables, and data. 8. T F 9. T F Log files are not part of a filegroup and are managed separately from the data space. 10. T F A differential backup truncates the transaction log

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual Basic6 Database Programming

Authors: John W. Fronckowiak, David J. Helda

1st Edition

0764532545, 978-0764532542

More Books

Students also viewed these Databases questions

Question

Describe a transition economy.

Answered: 1 week ago