WorksheetsMicrosoft SQL Server
Total questions: 10
Worksheet time: 14mins
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.
True
False
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?
Physical CPU core or Virtual CPU core
CPU plus Client Access License
Client Access License only
CPU core only
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?
True
False
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 domain user account
A local user account
No account is needed
The root user account
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?
No, only one database and associated tables is allowed
Yes, multiple databases and associated tables are allowed
Neither, databases and tables are the same thing
Databases require additional software
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.)
Connect to the database in object explorer
Export the database to mySQL format
Expand the databases and select the database to back up
Right click, choose Tasks, then Back Up
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.)
USE
SELECT
REMOVE
DELETE
Sophia is setting up a new database for her small business. To create a table, she needs to add a table name and define:
Rows
Arrays
Columns
Windows
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?
Artificial intelligence
A database
Data in a spreadsheet
A word document with names and addresses
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?
True
False
