Microsoft SQL Server

Microsoft SQL Server can only be installed on a Windows Domain Controller.

• True

• False

Microsoft SQL Server Enterprise (physical or virtual machine) licenses require purchase by:

• Physical CPU core or Virtual CPU core

• CPU plus Client Access License

• Client Access License only

• CPU core only

CAL's can be purchased for either Users or Devices or both.

• True

• False

When creating users for an instance of Microsoft SQL server, the type of user can be? (Choose two.)

• A domain user account

• A local user account

• No account is needed

• The root user account

Multiple databases can be housed within one instance of Microsoft SQL server?

• 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

The steps to backup a database in Microsoft SQL include? (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

Which of the following are SQL keywords? (Choose 3.)

• USE

• SELECT

• REMOVE

• DELETE

To create a table add a table name and define:

• Rows

• Arrays

• Columns

• Windows

A database is defined as?

• Artificial intelligence

• An organized collection of structured data

• Data in a spreadsheet

• A word document with names and addresses

Microsoft SQL Server is always managed using SQL Server Management Studio.

• True

• False