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
(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
