chapter 5 review Flashcards
SQL functions fit into two board categories:
d
m
data manipulation language
data definition language
basic commands have a vocab of fewer than….. words?
100
ensure that a column will not have duplicate values?
unique
validate data in an attribute
check
create a dynamic subset of rows and columns from one or more table
create view
restrict the selection of rows based on a conditional expression
where
….creates physical files that hold a database
RDBMS
t or f: RDMS are the same
false
…. verifies that only registered users are able to access DB
DBMS
a key that is both not a null and a unique specification
primary key
….. will automatically enforce referential integrity for foreign key
RDBMS
command sequence ends with a…?
semicolon
ensure that column doesn’t accept nulls
not null constraints
ensure that all values in the column are unique
unique constraints
assign value to an attribute when a new row is added to the table
default constraints
validate data when the attribute value is entered
check
data manipulation commands:
insert
select
commit
update
rollback
delete
used to enter data into table
insert
t or f: when entering values, rows have to be between parentheses
true
changes made to table contents are not physically saved on disk until:
d
p
c
database is closed
program is closed
commit command is used
used to list contents of table
select
columnist represents…… or….. attributes. separated by commas
one or more
modify data in table
update
t or f: if more than one attribute is to be updated in a row, separate the correction with a period.
false, commas
undoes changes since the last commit?
rollback
t or f: commit and rollback only work with commands to add,modify, or delete table rows
true
deletes a table row
delete
t or f: in delete, the (where) condition is optional
true
query embedded inside another query?
subquery
searching data involves multiple conditions
logical operators
the (and, or, not) are?
logical operators
mathematical field dedicated to using of logical operators
boolean algebra
checks whether the attribute value is within range
between
checks whether attribute value matches given string pattern
like
checks if the subquery returns any rows
exists
all changes in the table structure are made by using the …. command
alter
t or f: update command updates everything
false, update existing command
t or f: sql permits copying contents of selected table columns
true
t or f: when a table is copied, integrity rules copy too
false
logical operations work well in a …. environment
query
…. clause produces a list of only values that are different from one another
distinct
