Chapter 02 slides

In Management Studio, if a statement returns data

Which of these is a graphical tool that you can use to start and stop a database server?

SQL Server Configuration Manager

If you want to use Management Studio to modify the data for a table, you can right-click on the table in Object Explorer and select what?

Edit Top 200 Rows

Which of the following is not true about Azure Data Studio (ADS)?

It provides built-in support for creating database diagrams

A database _____ is a schematic drawing that shows you the relationships between the tables you’re working with

diagram

In Management Studio, the Query Editor uses the IntelliSense feature to automatically display ______ lists that you can use to enter parts of a SQL statement.

completion

In Management Studio, what tool would you use if you wanted to modify a column in a table?

Table Designer

When you use Windows authentication to connect to a database, SOL Server _____

uses the login name and password that you use for your PC to authorize your connection

Which of the following is not available as part of the online documentation for SQL Server?

open-source code so you can compile SQL Server yourself