chapter 5 review

Question 1

SQL functions fit into two board categories:
d
m

Answer 1

data manipulation language

data definition language

Question 2

basic commands have a vocab of fewer than….. words?

Answer 2

100

Question 3

ensure that a column will not have duplicate values?

Answer 3

unique

Question 4

validate data in an attribute

Answer 4

check

Question 5

create a dynamic subset of rows and columns from one or more table

Answer 5

create view

Question 6

restrict the selection of rows based on a conditional expression

Answer 6

where

Question 7

….creates physical files that hold a database

Answer 7

RDBMS

Question 8

t or f: RDMS are the same

Answer 8

false

Question 9

…. verifies that only registered users are able to access DB

Answer 9

DBMS

Question 10

a key that is both not a null and a unique specification

Answer 10

primary key

Question 11

….. will automatically enforce referential integrity for foreign key

Answer 11

RDBMS

Question 12

command sequence ends with a…?

Answer 12

semicolon

Question 13

ensure that column doesn’t accept nulls

Answer 13

not null constraints

Question 14

ensure that all values in the column are unique

Answer 14

unique constraints

Question 15

assign value to an attribute when a new row is added to the table

Answer 15

default constraints

Question 16

validate data when the attribute value is entered

Answer 16

check

Question 17

data manipulation commands:

Answer 17

insert
select
commit
update
rollback
delete

Question 18

used to enter data into table

Answer 18

insert

Question 19

t or f: when entering values, rows have to be between parentheses

Answer 19

true

Question 20

changes made to table contents are not physically saved on disk until:
d
p
c

Answer 20

database is closed
program is closed
commit command is used

Question 21

used to list contents of table

Answer 21

select

Question 22

columnist represents…… or….. attributes. separated by commas

Answer 22

one or more

Question 23

modify data in table

Answer 23

update

Question 24

t or f: if more than one attribute is to be updated in a row, separate the correction with a period.

Answer 24

false, commas

Question 25

undoes changes since the last commit?

Answer 25

rollback

Question 26

t or f: commit and rollback only work with commands to add,modify, or delete table rows

Answer 26

true

Question 27

deletes a table row

Answer 27

delete

Question 28

t or f: in delete, the (where) condition is optional

Answer 28

true

Question 29

query embedded inside another query?

Answer 29

subquery

Question 30

searching data involves multiple conditions

Answer 30

logical operators

Question 31

the (and, or, not) are?

Answer 31

logical operators

Question 32

mathematical field dedicated to using of logical operators

Answer 32

boolean algebra

Question 33

checks whether the attribute value is within range

Answer 33

between

Question 34

checks whether attribute value matches given string pattern

Answer 34

like

Question 35

checks if the subquery returns any rows

Answer 35

exists

Question 36

all changes in the table structure are made by using the .... command

Answer 36

alter

Question 37

t or f: update command updates everything

Answer 37

false, update existing command

Question 38

t or f: sql permits copying contents of selected table columns

Answer 38

true

Question 39

t or f: when a table is copied, integrity rules copy too

Answer 39

false

Question 40

logical operations work well in a .... environment

Answer 40

query

Question 41

.... clause produces a list of only values that are different from one another

Answer 41

distinct