LIS3784 final Questions with Answers (100% Correct Answers)

1




LIS3784 final Questions with Answers (100%
Correct Answers)
for most business transactional databases we should normalize relations into—
Answer: 3NF

surrogate primary keys are espeically useful when there is no— Answer: natural
key

what kind of keys work with primary keys to implement relationships in the
relational model?— Answer: foreign key

the special operator used to check whether an attribute value is within a range
of values— Answer: between

special operator used to check for similar character strings— Answer: like

a table structure AND data can be deleted from the database by using what
command— Answer: drop table

The SQL aggregate function that gives the number of rows containing non-null
values for the given column is ____.— Answer: count

The SQL aggregate function that gives the total of all values for a selected
attribute in a given column is ____.— Answer: sum

The SQL aggregate function that gives the average for the specific column is
____.— Answer: avg

The following SQL statement uses a(n) ____.

SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME

FROM PRODUCT, VENDOR

WHERE PRODUCT.V_CODE=VENDOR.V_CODE;— Answer: old style
join