SQL Chapter 1 & 2 quiz

When you use Windows authentication to connect to a database, SQL Server 1. requires that you use a special login name and password for your authorization 2. lets you access the database without authorization as long as you're logged on to Windows 3. uses both Windows and SQL Server login names and passwords for authorization 4. uses the login name and password that you use for your PC to authorize your connection

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

Which of the following types of SQL statements isn't a DML statement? Insert Select Update Create Table

Create Table Create Table is a a data definition language. insert, select, update, and delete are all data manipulation language.

SQL statements that define the tables in a database are referred to as _______________ statements.

Data definition language

Within the Management Studio, you can build a SQL statement without having to write your own code by using the ____________________________________.

Query Designer

Which of the following types of statements isn't an action query? Insert Select Update Delete

Select - insert, update, and delete statements are referred to as action queries because they perform an action. Select statements are referred to as queries since they simply query the database.

If you define a column as an identity column, 1. you must also define the column with a default value 2. you must provide a unique numeric value for that column whenever a row is added to the table 3. a number is generated for that column whenever a row is added to the table 4. you can't use the column as a primary key column

A number is generated for that column whenever a row is added to the table

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 1. Edit Top 200 Rows command 2. Select Top 1000 Rows command 3. View Top 100 Rows command 4. Design command

Edit Top 200 Rows command

The ________________________________________ is a graphical user interface for working with the objects in a SQL Server database.

SQL Server Management Studio

If you define a column with a default value, that value is used whenever a row 1. that doesn't include a value for that column is added to the table 2. is added to the table 3. in the table is updated 4. with a zero value for that column is added to the table

That doesn't include a value for that column is added to the table. - You can assign a default value to each column. Then, that value is assigned to the column if another value is not provided when a row is added to the table.

A database __________________ is a schematic drawing that shows you the relationships between the tables you're working with.

diagram