1.If you create a temporary database, where will its data be stored?
Typically, when a user creates a new temporary database, they select the database's name and storage location. If the user fails to designate the new database location, the database will be stored at the current location, and the database filename will begin with tempdb.
2.Change the properties of the model database so that its size is 4 MB. (Use T-SQL) Show the T-SQL statements.
USE master;
GO
ALTER DATABASE AdventureWorks2012
MODIFY FILE
(NAME = FILENAME,
SIZE = 4MB);
GO
3.Name all key terms of Policy-Based Management and discuss their roles and how they relate to one another.
Policy-Based Management
A policy is a collection of requirements and guidelines that specify how database objects and servers should be configured or behave. Policies are defined in accordance with standards or specifications.
Condition:
A condition is a logical statement or restriction that determines if a specific database feature complies with policy criteria. Conditions are applied to assess conformance.
Facet:
For a database entity, such a table or server, a facet is a specified collection of properties. Policies can target configuration elements of an object thanks to facets. Category:
Policies can be arranged into containers according to their goals by using categories. Because all policies in a category have the same objective, managing and accessing them as a group is made simpler.
