ch 1 sql

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

A/An _________________ statement is used to retrieve selected columns and rows from a base table.

select

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 recommendations won't improve the readability of your SQL statements?

Use comments to describe what each statement does

A/An ____________________________ diagram can be used to show how the tables in a database are defined and related..

entity relationship

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

A database driver is software that lets the

data access model communicate with the database

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

data definition language

The type of operation that retrieves data from two or more tables is called a

join

When a column in a table is defined, it is given a data ________________ that determines what kind of data it can store.

type


Ensembles d'études connexes

Biology Chapter 5: The Working Cell- Guided Reading Activities

View Set

Geography Unit 2 Extreme Weather

View Set

5th Grade ABeka Spelling List #25

View Set

Florida 240 Practice exam questions and answers

View Set

The Nursing Process & Pharmacology-Evolve Chpt. 4

View Set

Charlie y Sophie llegan a El Salvador

View Set

Intro to Business: Business Terms 4

View Set