Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Chapter 1 SQL test

memorize.ai (lvl 286)

(0)

30 cards

()

Section 1

Preview this deck

A relational database consists of one or more __________________.

Front

1 / 30

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (30)

Section 1

(30 cards)

A relational database consists of one or more __________________.

Front

tables

Back

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

Front

foreign key

Back

The three main hardware components of a client/server system are the clients, the server, and the __________________________________.

Front

network

Back

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

Front

entity relationship

Back

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

Front

back-end processing

Back

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

Front

select

Back

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

Front

ddl

Back

MySQL became an open-source database in 1970 T or F

Front

false

Back

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

Front

Use comments to describe what each statement does.

Back

A SELECT statement is commonly referred to as a query. T or F

Front

true

Back

Which of the following types of statements does not modify the data in a table?

Front

SELECT

Back

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

Front

join

Back

A database driver is software that lets the

Front

data access model communicate with the database

Back

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

Front

data access API

Back

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

Front

type

Back

MySQL runs on all major operating systems and is widely used for web applications. T or F

Front

true

Back

PPP, Cava, and Ciesta are three of the most popular languages mentioned in the chapter that are used to interface with a MySQL server/database. T or F

Front

false

Back

The most common type of relationship between two tables is a/an _______________________ relationship.

Front

one-to-many

Back

A/An _______________________ uniquely identifies each row in a table.

Front

primary key

Back

In a client/server system, the processing done by an applicaton is typically divided between the client and the server. T or F

Front

True

Back

The industry acronym DBMS stands for Database Manipulation System. T or F

Front

false

Back

The result of a SELECT statement is

Front

a result set

Back

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

Front

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

Back

Which of the following types of SQL statements is not a DML statement?

Front

CREATE TABLE

Back

SQL is a freeform language that is not case-sensitive. T or F

Front

true

Back

A relational database consists of tables, and tables consists of legs and columns. T or F

Front

False

Back

To retrieve or update the data in a database, the client sends a/an _____________________ to the database.

Front

query

Back

The intersection of a row and a column is commonly called a/an ____________________.

Front

cell

Back

The server is a computer that stores the files and databases of the system and provides services the clients. T or F

Front

true

Back

The processing that's done by the DBMS is typically referred to as back-side processing. T or F

Front

false

Back