QUIZ - ADDBASE 5-6

Provide an example of why Database Performance is important. Expand your example. Provide at most five (5) sentences

This does not include the database, but only the tools to manage SQL Server instances.

• Express with tools

• Express

• SQL Server Management Studio Express

• LocalDB

This package includes all the elements of SQL Express. This is a bigger download than "with tools," as it also comprises both full text search and reporting services.

• SQL Server with Full Services

• Express with Advance Services

• Express with Tools

• SQL Server with tools

It is a lightweight version with all its programmability characteristics, yet it runs in user mode and has a speedy, zero-configuration installation and a short list of prerequisites.

• Express with Tools

• Express

• SQL Server

• LocalDB

Provide a business case that will show the importance and applicable application of backup and recovery. (Provide at most 5 sentences.).

It is a special file that keep track all database transactions.

• Dictionary

• Log File

• History

• Text File

It is the point of synchronization between the database and the transaction log file

• StartPointing

• CheckPointing

• FlagPointing

• EndPointing