MCTS Database Management & SQL Server

Question 1

What is the purpose of SQL Server Management Studio (SSMS)?

Accepted Answer

Managing SQL Server and executing queries

Answer

Writing HTML code

Answer

Designing graphics

Answer

Creating Excel spreadsheets

Question 2

Which language is used to interact with SQL Server databases?

Accepted Answer

T-SQL

Answer

Java

Answer

Python

Answer

C#

Question 3

Which SQL command is used to remove a table from the database?

Accepted Answer

DROP

Answer

DELETE

Answer

TRUNCATE

Answer

REMOVE

Question 4

What is normalization in SQL databases?

Accepted Answer

Organizing data to minimize duplication

Answer

Adding redundant data

Answer

Backing up data

Answer

Encrypting sensitive information

Question 5

Which system database in SQL Server stores login accounts and system configuration?

Accepted Answer

master

Answer

tempdb

Answer

msdb

Answer

model

Question 6

What is the function of the PRIMARY KEY constraint?

Accepted Answer

Prevents duplicate and NULL values in a column

Answer

Creates a relationship between tables

Answer

Allows foreign keys

Answer

Inserts data into the database

Question 7

Which command is used to retrieve data from a SQL Server table?

Accepted Answer

SELECT

Answer

FETCH

Answer

PULL

Answer

READ

Question 8

Which feature in SQL Server provides data recovery after a system failure?

Accepted Answer

Transaction logs

Answer

Indexes

Answer

Triggers

Answer

Constraints

Question 9

What is the purpose of the SQL Server Agent?

Accepted Answer

Automates administrative jobs

Answer

Hosts websites

Answer

Manages system logins

Answer

Creates new databases