WGU C170 : Quiz 4 - Advanced SQL - Questions & Correct Answers | Grade A+

The _____ data type is considered compatible with VARCHAR(35). Ans- CHAR(15) How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18? Ans- 144 Oracle uses the _____ function to extract the various parts of a date. Ans- TO_CHAR A(n) _____ join returns not only the rows matching the join condition (that is rows, with matching values in the commun columns) but also the rows with unmatched values. Ans- outer A _____ is a query inside a query. Ans- subquery A(n) _____ view is a view that can be used to update attributes in the base tables that are used in the view. Ans- updatable "Union compatible" means that the _____. Ans- names of the relation attributes can be different, but the data types must be alike A(n) _____ query can be used to produce a relation that retains the duplicate rows. Ans- UNION ALL When using a subquery, the output of a(n) _____ query is used as the input for the outer query. Ans- inner A(n) _____ routine pools multiple transactions into a single batch to update a master table field in a single operation. Ans- batch update The Oracle _____ function returns th