CIS 336 All Assignments CIS 336 All Assignments | Page 59

(TCO 7) A ____ occurs when a relationship is improperly or incompletely identified and,
therefore, is represented in a way that is not consistent with the real world.
(TCO 7) The ______________________ comparison operator is used to search for values which
are not NULL.
TCO 7) You want to write a query that will return the customer number, first and last name
from the book_order table (shown below) for all customers who have a P.O. Box and who live
in either Trenton or Chicago. Write the query that will accomplish this task.
CIS 336 Quiz 4
Click Below Link To Purchase
www.foxtutor.com/product/cis-336-quiz-4
TCO 8) If a Cartesian join is used to link table A which contains five rows to table B which
contains eight rows, there will be _______ rows in the results.
(TCO 8) Which of the following statements will produce the value 21.1?
(TCO 8) Which of the following format elements will display insignificant leading zeros?
(TCO 8) Oracle’s pseudo table used only for cases where a table is not really needed is
_________?
(TCO 7) Using the BOOK_CUSTOMER and BOOK_ORDER tables shown below for reference
which SQL statement will return the same results as the following SQL statement?
(TCO 7) A table alias or qualifier cannot be assigned in the FROM clause of which type of join?
(TCO 7) The _______ query joins a table to itself using aliases to distinctly identify each instance
of the table.