Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Chapter 1 Quiz w/o choices

memorize.ai (lvl 286)

Section 1

Preview this deck

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

Front

1 / 14

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

1 year ago

Date created

Mar 14, 2020

Cards (14)

Section 1

(14 cards)

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

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

Front

c) data access API

Back

Which of the following types of statements does not modify the data in the table? a) SELECT b) INSERT c) UPDATE d) DELETE

Front

a) SELECT

Back

DDL Commands

Front

Create, Alter, Drop, Rename, Truncate, Comment

Back

Which of the following is NOT a DML statement? SELECT INSERT UPDATE DELETE

Front

SELECT

Back

DML Commands

Front

Insert, Update, Delete

Back

If you define a column with a default value, that value is used whenever a row a) is added to the table b) in the table is updated c) that doesn't include a value for that column is added to that table d) with a zero value for that column is added to the table

Front

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

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 result of a SELECT statement is..

Front

a) a result set

Back

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

Front

b) back-end processing

Back

Which of the following is NOT a DML statement? a) INSERT b) UPDATE c) DELETE d) CREATE TABLE

Front

d) CREATE TABLE

Back

A database driver is software that lets the a) data access model communicate with the application program b) data access model communicate with the database c) application program communicate with the data access model d) application program communicate with the database

Front

b) data access model communicate with the database

Back

Is DBMS a front-end of back-end process?

Front

Back-end

Back

Which of the following recommendations won't improve the readability of your SQL statements? a) Break long clauses into multiple lines. b) Use comments to describe what each statement does. c) Start each clause on a new line. d) Indent continued lines.

Front

c) Start each clause on a new line.

Back