SQL Server 2005 has the following features? - SQL Server Quiz

SQL Server - Quiz(MCQ)

SQL Server 2005 has the following features?

A)

Powerpivot

B)

Filestream

C)

Dynamic Management Views

D)

In-memory capability

Correct Answer : Dynamic Management Views

Explanation : SQL Server 2005 introduced DMVs (Dynamic Management Views), which are specialized views and functions that return server state information. FILESTREAM, Powerpivot and in-memory capability were introduced in 2008,2008 R2 and 2014 respectively.

Recently Updated in SQL Server Questions

Which of the following system database occupies more space and memory?

A)

Msdb

B)

Model

C)

Master

D)

Tempdb

Correct Answer : Master

Explanation : The master database records all of the system level information for a SQL Server system.

Which database is used as template for all databases?

A)

Master

B)

Tempdb

C)

Northwind

D)

Model

Correct Answer : Model

Explanation : When a CREATE DATABASE statement is issued, the first part of the database is created by copying in the contents of the model database.

Which of the following database is used by SQL Server Agent?

A)

Pubs

B)

Msdb

C)

Model

D)

Tempdb

Correct Answer : Msdb

Explanation : The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.

New Technologies MCQ's

Machine Learning

Artificial Intelligence

Ethical Hacking

Microsoft Azure

Cloud Computing

Quantum Computing

Neural Networks

Virtual Reality

Augmented Reality

Advertisement