wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft SQL Server

Total questions: 10

Worksheet time: 14mins

Name
Class
Date
1.

Benjamin is setting up a new server for his company and is considering installing Microsoft SQL Server. He wonders if Microsoft SQL Server can only be installed on a Windows Domain Controller.

a)

True

b)

False

2.

Rohan is setting up a new database server for his company using Microsoft SQL Server Enterprise on a physical or virtual machine. He needs to ensure that he purchases the correct type of licenses. Which of the following does Rohan need to buy?

a)

Physical CPU core or Virtual CPU core

b)

CPU plus Client Access License

c)

Client Access License only

d)

CPU core only

3.

Priya is setting up Microsoft SQL Server for her company. She learns that CAL's can be purchased for either Users or Devices or both. Is this true?

a)

True

b)

False

4.

David is setting up a new instance of Microsoft SQL Server for his company's database. When creating users for this instance, what type of user can David create? (Choose two.)

a)

A domain user account

b)

A local user account

c)

No account is needed

d)

The root user account

5.

Priya is setting up a new project at her company and wants to use Microsoft SQL Server to manage data for several departments. She wonders if she can create separate databases for each department within a single instance of Microsoft SQL Server. Is this possible?

a)

No, only one database and associated tables is allowed

b)

Yes, multiple databases and associated tables are allowed

c)

Neither, databases and tables are the same thing

d)

Databases require additional software

6.

Noah is tasked with backing up a database in Microsoft SQL Server for his company's IT department. Which steps should he follow to complete the backup? (Choose three.)

a)

Connect to the database in object explorer

b)

Export the database to mySQL format

c)

Expand the databases and select the database to back up

d)

Right click, choose Tasks, then Back Up

7.

Aria is learning SQL and wants to write queries to manage a database. She is trying to identify which of the following are actual SQL keywords. (Choose 3.)

a)

USE

b)

SELECT

c)

REMOVE

d)

DELETE

8.

Sophia is setting up a new database for her small business. To create a table, she needs to add a table name and define:

a)

Rows

b)

Arrays

c)

Columns

d)

Windows

9.

Olivia is setting up a system to store information about her company's employees, including their names, job titles, and contact details in a way that makes it easy to organize and retrieve. What is this system called?

a)

Artificial intelligence

b)

A database

c)

Data in a spreadsheet

d)

A word document with names and addresses

10.

Sophia is responsible for managing a company's Microsoft SQL Server. She believes that SQL Server can only be managed using SQL Server Management Studio. Is she correct?

a)

True

b)

False