SQL

Question 1

How do you install SQL Express with tools 64-bit?

Question 2

How do you run a script?

Answer 2

1. Open SSMS, right-click a database on the left side, and select New Query
2. Paste the script into the query window
3. Press Parse to validate SQL syntax
4. Press Execute to run the script

Question 3

How do you set SQL to log into a file?

Question 4

Explain the difference between Windows vs. SQL authentication

Answer 4

Windows authentication checks the Windows User account that’s logged in using a principal token, whereas SQL authentication uses a username and password stored in within the SQL instance

Question 5

How do you view a table for the VCM database?

Answer 5

1. Expand the SqlServer instance tree
2. Expand the VCM Database
3. Expand Tables

Question 6

How do you view permissions for a database?

Answer 6

1. Right-click a database in the Object Explorer and select Properties
2. On the right side, select the Permissions page

Question 7

How do you view Security Roles for a database?

Question 8

How do you take a backup of a database?

Answer 8

1. Right-click a database in the Object Explorer and select Tasks > Back Up…
2. Press Add to choose a file path to save to
3. Press OK to back up the database

Question 9

How do you detach a database?

Answer 9

1. Right-click a database in the Object Explorer and select Tasks > Detach
2. Press OK

Question 10

How do you restore a database?

Answer 10

1. Right-click a database in the Object Explorer and select Tasks > Restore > Database
2. Choose Device and enter the file path of the .bak file
3. Select the database from the drop-down
4. Press OK

Question 11

How do you reattach a database?

Answer 11

1. Right-click Databases and select Attach
2. Press Add, then navigate to the location of the .mdf file
3. Press OK