Data Question 1 with Answers

Data question 1 _____ is a string function that returns the number of characters in a string value. The _____ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second. A. UNION How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18? A. 144 Assume a designer is using the UNION operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Jenna and Howard are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator? A. 15 All join conditions are connected through a(n) _____ logical operator. A. AND The Oracle string concatenation function is _____. A. || When using the Oracle TO_DATE function, the code _____ represents a threeletter month name. A. MON The statement SELECT * FROM T1, T2 produces a(n) _____ join. A. cross Assume you are using the INTERSECT operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the INTERSECT operator? A. 2 Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator? A. 17 In subquery terminology, the first query in the SQL statement is known as the _____ query. A. outer The _____ statement combines rows from two queries and excludes duplicates. A. UNION The PL/SQL block starts with the _____ section. A. DECLARE In Oracle, the _____ function converts a date to a character string. A. TO_CHAR() In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping. A. Procedural Language SQL When using a(n) _____ join, only rows that meet the given criteria are returned. A. inner Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the MINUS operator? A. 2 The _____ pseudo-column is used to select the next value from a sequence. A. NEXTVAL The ANSI standard defines _____ type(s) of outer join(s) A. three 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. A. outer The _____ function returns the current system date in MS Access. A. DATE() The _____ data type is compatible with NUMBER. A. SMALLINT The syntax for a left outer join is _____. SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition A(n) _____ join will select only the rows with matching values in the common attribute(s). A. natural The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found. A. DECODE