DATABASE QUIZ 1

What uniquely identifies each row in a table?

primary key

To retrieve or update the data in a database, the client sends a ________________ to the database.

query

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

Which of the following is not a SQL DML statement?

CreateTable

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

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

Select

If you define a column as an identity column,

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

The processing that's done by the DBMS is typically referred to as

back-end processing

The interface between an application program and the DBMS is usually provided by the

data access API