Chapter2ReviewQuestions – Flashcards
Unlock all answers in this set
Unlock answers
question
The ________ is a graphical user interface for working with the objects in a SQL Server database
answer
Management Studio
question
A database _______ is a schematic drawing that shows you the relationships between the tables you're working with
answer
diagram
question
Within the Management Studio, you can build a SQL statement without having to write your own code by using the _______
answer
Query Designer
question
SQL Server comes with complete documentation and reference information called ______
answer
Books Online
question
When you use Windows authentication to connect to a database, SQL Server
answer
uses the login name and password that you use for your PC to authorize your connection
question
When you set the compatibility level of SQL Server 2012, you make sure it is compatible with a specific version of
answer
SQL Server
question
You can create a database diagram for
answer
any combination of the tables in a database
question
The Query Editor of the Management Studio lets you enter and execute all types of
answer
SQL statements
question
Which of the following IS NOT a common error when entering and executing SQL statements?
answer
Forgetting to attach the required database
question
One limitation of the Query Designer is that you can't use it for
answer
certain types of complex queries
question
If you want to use the Management Studio to modify the data for a table, you can right-click on the table and select the
answer
Edit Top 200 Rows command
