Questions

Q1. Name five Microsoft SQL Server 2012 editions?

Q2. Name five main Microsoft SQL Server 2012 components?

Q3. SQL Server 2012 provides a rich set of tools to make working with SQL Server easier. Name commonly used five Microsoft SQL Server 2012 tools?

Q4. The data stored by SQL Server databases is contained within a set of files. Name three types of files that are used by SQL Server ?

Q5. SQL Server System database used by SQL Server for its own maintenance and management.  Name all of the SQL Server 2012 System databases?

Q6. SQL Server has three database recovery models. Choose  the appropriate recovery mode is very important. Name those Three SQL Server database recovery models?

Q7. SQL Server provides a verity of backup types.  More commonly, a combination of backup types is required to achieve an appropriate outcome. Name Five SQL Server 2012 Backup Types?

Q8. Checkpoint is an SQL Server internal process  that  helps to reduce the recovery time in the event of unexpected shutdown or system failure  . Name all four types of SQL Server2012 checkpoint operations ?

Q9. Name three primary command-line tools that can be used to verify network commutation in your server infrastructure?

Q10. Name three types of T-SQL Language types?

Answers

Q1. Correct Answer

Express

Standard

Compact

Developer

Web

Business Intelligence

Enterprise

Parallel Data Warehouse

Q2. Correct Answer

Database Engine

Analysis Services

Integration Services

Reporting Services

Master Data Services

StreamInsight

Data Mining

Full-Text Search

PowerPivot

Replication

Data Quality Services

Power View

Q3. Correct Answer

SQL Server Management Studio (SSMS)

SQL Server Data Tools (SSDT)

SQL Server Configuration Manager (SSCM)

SQL Server Profiler

Database Engine Tuning Advisor

Master Data Services Configuration Manger

Reporting Services Configuration manger

Data Quality Services Client

SQL Server Error and Usage Reporting

PowerShell Provider

SQL Server Management Objects (SMO)

Q4. Correct Answer

Primary Data Files

Secondary Data File

Transactional log files.

Q5. Correct Answer

master Database

msdb Database

model Database

Resource Database

tempdb Database

Q6. Correct Answer

Simple

Full

Bulk Logged

Q7. Correct Answer

Full

Differential

Partial

Transaction Log

Tall-log Backup

File Group

Copy only

Q8. Correct Answer

Automatic

Indirect

Manual

Internal

Q9. Correct Answer

PING

TraceRT

PathPING

Q10. Correct Answer

Data Manipulation Language (DML)

Data Definition Language (DDL)

Data Control Language (DCL)