MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which database is used as template for all databases?

A	Northwind
B	Master
C	Tempdb
D	Model

Explanation:

Detailed explanation-1: -The model database is used as the template for all databases created on an instance of SQL Server.

Detailed explanation-2: -SQL Server uses the model database as a template to create new databases.

Detailed explanation-3: -accdb is the template for all new blank databases.

Detailed explanation-4: -The tempdb is used to store temporary objects such as global and local temporary tables and stored procedures. The model is essentially a template database used in the creation of any new user database created in the instance.

There is 1 question to complete.