Quiz 2 Flashcards
Which of the following is not true about Azure Data Studio (ADS)?
It provides built-in functionality for creating charts from query results
It can run on macOS
It is designed to work with a server running on the Azure cloud
It provides built-in support for creating database diagrams
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
system
role
diagram
object
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.
data
completion
execution
colored
completion
Which of these is a graphical tool that you can use to start and stop a database server?
Table Designer
SQL Server Management Studio
SQL Server Configuration Manager
Object Explorer
SQL Server Management Studio
Question 5
In Management Studio, if a statement returns data, that data is displayed in the __________ tab.
Query Editor tab
Results tab
Object Explorer
Messages tab
Results tab
When you use Windows authentication to connect to a database, SQL Server _____________
lets you access the database without authorization as long as you’re logged on to Windows
uses the login name and password that you use for your PC to authorize your connection
uses both Windows and SQL Server login names and passwords for authorization
requires that you use a special login name and password for your authorization
uses the login name and password that you use for your PC to authorize your connection
In Management Studio, what tool would you use if you wanted to modify a column in a table?
Object Explorer
Database Attacher
Table Designer
Query Editor
Table Designer
You can create a database diagram in Management Studio for _____________
up to 3 tables in a database
just the related tables in a database
any combination of the tables in a database
just the tables in a one-to-many relationship
any combination of the tables in a database
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
Script Table As
Select Top 1000 Rows
Design
Edit Top 200 Rows
Which of the following is not available as part of the online documentation for SQL Server?
documentation for previous versions of SQL Server
open-source code so you can compile SQL Server yourself
complete syntax options for all SQL statements
simple examples for using some SQL queries
open-source code so you can compile SQL Server yourself
?
