DBMS 110 Final Exam Questions and Answers (verified answers)

DBMS 110 Final Exam Questions and Answers
(verified answers)

The _____ command defines a default value for a column when no value is given. -
ANSW- DEFAULT

A(n) _____ join returns not only the rows matching the join condition (that is, rows with
matching values in the common columns) but also the rows with unmatched values. -
ANSW- outer

The conditional LIKE must be used in conjunction with wildcard characters. True or
False? -ANSW- True

You cannot insert a row containing a null attribute value using SQL. True or False? -
ANSW- False

The ANSI SQL standards are also accepted by the ISO. True or False? -ANSW- True

What type of command does this SQL statement use?

SELECT P_CODE, P_DESCRIPT, P_PRICE_V_NAME

FROM PRODUCT, VENDOR

WHERE PRODUCT.V_CODE=VENDOR. V_CODE -ANSW- old-style join

A(n) _____ is an alternate name given to a column or table in any SQL statement. -
ANSW- alias

Oracle users can use the Access QBE (query by example) query generator. True or
False? -ANSW- False

Comparison operators cannot be used to place restrictions on character-based
attributes. True or False? -ANSW- False

The COMMIT command does not permanently save all changes. In order to do that, you
must use SAVE. True or False? -ANSW- False

A(n) _____ join will select only the rows with matching values in the common
attribute(s). -ANSW- natural

Which query is used to list a unique value for V_CODE, where the list will produce only
a list of those values that are different from one another? -ANSW- SELECT DISTINCT
V_CODE

, FROM PRODUCT;

The SQL aggregate function that gives the number of rows containing non-null values
for a given column is _____. -ANSW- COUNT

String comparisons are made from left to right. True or False? -ANSW- True

According to the rules of precedence, which of the following computations should be
completed first? -ANSW- Operations within parentheses

The special operator used to check whether an attribute value matches a given string
pattern is _____. -ANSW- LIKE

How many rows would be returned from a cross join of tables A and B, if A contains 8
rows and B contains 18? -ANSW- 144

If a designer wishes to create an inner join, but the two tables do not have a commonly
named attribute, he can use a(n) _____ clause. -ANSW- JOIN ON

An alias cannot be used when a table is required to be joined to itself in a recursive
query. True or False? -ANSW- False

The SQL command that allows a user to permanently save data changes is _____. -
ANSW- COMMIT

Which comparison operator indicates a value is not equal? -ANSW- < >

Numeric functions take one numeric parameter and return one value. True or False? -
ANSW- True

All SQL commands must be issued on a single line. True or False? -ANSW- False

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
True or False? -ANSW- True

The COUNT function is designed to tally the number of non-null "values" of an attribute,
and is often used in conjunction with the DISTINCT clause. True or False? -ANSW-
True

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE
clause. True or False? -ANSW- True

The benefits of the web as a data access platform arise from its cross-platform
functionality and the simplicity of its interface. True or False? -ANSW- True