cse 581_quiz1

What uniquely identifies each row in a table?

primary key

Management Studio allows you to back up a database. Then, if you accidentally modify or delete data, you can easily ________________ it.

restore

Which of the following types of statements isn't an action query?

select

A relational database consists of one or more what?

tables

If you define a column with a default value, that value is used whenever a row

that doesn't include a value for that column is added to the table

When you use Windows authentication to connect to a database, SQL Server

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

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

Data Definition Language (DDL)

The intersection of a row and a column is commonly called what?

cell

A SQL Server database consists of two files: a database file and a ___________.

log file

This is typically modeled after a real-world entity, such as an invoice or a vendor.

table

In Management Studio, if a statement returns data, that data is displayed in the __________ tab.

Result tab

Which of the following recommendations won't improve the readability of your SQL statements?

Use comments to describe what each statement does.

The three main hardware components of a client/server system

clients, server, and network

To run a SELECT statement from an application program, you store the statement in the ________________ object for the database connection.

command

To work with the data in a SQL Server database from a .NET application, you can use ADO.NET objects like

commands, connections, and data readers

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

Edit Top 200 Rows command

Which of the following isn't a common error when entering and executing SQL statements?

Forgetting to attach the required database

A graphical tool that you can use to start and stop the database server is called what?

SQL Server Configuration Manager

When using the Query Designer, where is the generated SQL statement displayed?

SQL pane

The Query Editor of the Management Studio lets you enter and execute all types of

SQL statement

The Query Editor of the Management Studio lets you enter and execute all types of

SQL statements

When a column in a table is defined, what determines the kind of data it can store?

a data type

If you define a column as an identity column,

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

You can create a database diagram for

any combination of the tables in a database

To store and manage the databases of the client/server system, each server requires what?

database management system (DBMS)

If you try to move a database file that's attached to a server, you'll get an error message that indicates the file is in use. To get around this, you need to ________________ the database from the server.

detach

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

diagram

To relate one table to another, a/an ________________ in one table is used to point to the primary key in another table

foreign key

What SQL dialect does Microsoft SQL Server use?

Transact-SQL

If you have the files for an existing SQL Server database, the easiest way to create the database is to ________________ those files to the database server.

attach

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

completion