chapter 5

Question 1

what does the command ‘create table’ do?

Answer 1

creates a new table in the DB

Question 2

what does the command ‘alter table’ do?

Answer 2

modifies table definitions

Question 3

what does the command ‘not nulls’ do?

Answer 3

ensure the column doesn’t accept null

Question 4

t or f: one of the data manipulation commands is ‘insert’.

Answer 4

true

Question 5

what does the command ‘delete’ do?

Answer 5

delete a table row

Question 6

what does the command ‘drop’ do?

Answer 6

deletes table from DB

Question 7

what does the command ‘order by’ do?

Answer 7

listing order

Question 8

….. checks whether attribute value is within range

Answer 8

between