Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
MySQL Chapter 1 Quiz

MySQL Chapter 1 Quiz

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(1)
(0)
14 cards
()
Section 1

Preview this deck

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

Front

1 / 14

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

1

Favorites

0

Last updated

6 years ago

Date created

Mar 14, 2020

Cards (14)

Section 1

(14 cards)

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

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

Front

d) CREATE TABLE

Back

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

Front

Back-end

Back

The result of a SELECT statement is.. a) a result set b) a calculated value c) a stored procedure

Front

a) a result set

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

DML Commands

Front

Insert, Update, Delete

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

DDL Commands

Front

Create, Alter, Drop, Rename, Truncate, Comment

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

The interface between an application program and the DBMS is usually provided by the a) front end b) back end c) data access API d) programmer

Front

c) data access API

Back

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

Front

SELECT

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

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

The processing that's done by the DBMS is typically referred to as a) front-end processing b) back-end processing c) the file server d) the user interface

Front

b) back-end processing

Back