Test
Chapter 8 (Multiple Choice CIS 3365)
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (40)
11. The following SQL statement uses a(n) ____.SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAMEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;
- Aa. set operator
- Bb. natural join
- Cc. “old-style” join
- Dd. procedural statement
22. When using a(n) ____ join, only rows that meet the given criteria are returned.
- Aa. full
- Bb. inner
- Cc. outer
- Dd. set
33. The statement SELECT * FROM T1, T2 produces a(n) ____ join.
- Aa. cross
- Bb. natural
- Cc. equi
- Dd. full
44. How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?
- Aa. 8
- Bb. 18
- Cc. 26
- Dd. 144
55. A(n) ____ join will select only the rows with common values in the common attribute(s).
- Aa. natural
- Bb. cross
- Cc. full
- Dd. outer
66. If you wish to create an inner join, but the two tables do not have a commonly named attribute, you can use a(n) ____ clause.
- Aa. OF
- Bb. USING
- Cc. HAS
- Dd. JOIN ON
77. The ANSI standard defines ____ type(s) of outer join(s)
- Aa. one
- Bb. two
- Cc. three
- Dd. four
88. 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.
- Aa. outer
- Bb. inner
- Cc. equi
- Dd. cross
99. The syntax for a left outer join is ____.
- Aa. SELECT column-list FROM table1 OUTER JOIN table2 LEFTWHERE join-condition
- Bb. SELECT column-list FROM table1 LEFT [OUTER] JOIN table2ON join-condition
- Cc. SELECT column-list WHERE LEFT table1 = table 2
- Dd. SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition
1010. A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.
- Aa. natural
- Bb. cross
- Cc. full outer
- Dd. left outer
1111. A ____ is a query (SELECT statement) inside a query.
- Aa. subquery
- Bb. range query
- Cc. join
- Dd. set query
1212. In subquery terminology, the first query in the SQL statement is known as the ____ query.
- Aa. outer
- Bb. left
- Cc. inner
- Dd. base
1313. In a subquery, the ____ query is executed first
- Aa. left
- Bb. right
- Cc. inner
- Dd. outer
1414.The ____ function returns the current system date in MS Access.
- Aa. TO_DATE(
- Bb. SYSDATE()
- Cc. DATE()
- Dd. TODAY()
1515. When using the Oracle TO_DATE function, the code ____ represents a three-letter month name.
- Aa. MON
- Bb. MM3
- Cc. MONTH
- Dd. MM
1616. The Oracle ____ function returns the current date
- Aa. DATE
- Bb. SYSDATE
- Cc. CURRENT_DATE
- Dd. TO_DATE
1717. In Oracle, the ____ function converts a date to a character string.
- Aa. CONVERT()
- Bb. TO_DATE
- Cc. TO_CHAR()
- Dd. TO_STRING()
1818. The Oracle string concatenation function is ____.
- Aa. CONCAT
- Bb. +
- Cc. ||
- Dd. &&
1919. When using the Oracle TO_NUMBER function to convert a character string into a number, ____represents a digit.
- Aa. 0
- Bb. 9
- Cc. $
- Dd. #
2020. ____ is a relational set operator.
- Aa. MINUS
- Bb. PLUS
- Cc. ALL
- Dd. EXISTS
2121. “Union-compatible” means that the ____.
- Aa. names of the relation attributes can be different, but the data types must be identical
- Bb. names of the relation attributes must be the same, but the data types can be different
- Cc. names of the relation attributes must be the same and their data types must be identical
- Dd. number of attributes must be the same, but the names and data types can be different
2222. The ____ data type is considered compatible with VARCHAR(35).
- Aa. DATE
- Bb. INT
- Cc. TINYINT
- Dd. CHAR(15)
2323. 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.
- Aa. NVL
- Bb. TO_CHAR
- Cc. DECODE
- Dd. CONVERT
2424. The ____ data type is compatible with NUMBER.
- Aa. VARCHAR(15)
- Bb. SMALLINT
- Cc. DATE
- Dd. CHAR(10)
2525. The ____ query combines rows from two queries and excludes duplicates.
- Aa. UNION
- Bb. UNION ALL
- Cc. INTERSECT
- Dd. MINUS
2626. The syntax for the UNION query is ____.
- Aa. query + query
- Bb. UNION (query, query)
- Cc. UNION: query query
- Dd. query UNION query
2727. Assume you are 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 CUS-TOMER_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 operator?
- Aa. 7
- Bb. 10
- Cc. 15
- Dd. 17
2828. 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 CUS-TOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL
operator?- Aa. 7
- Bb. 10
- Cc. 15
- Dd. 17
2929. 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 CUS-TOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the INTERSECT operator?
- Aa. 0
- Bb. 2
- Cc. 7
- Dd. 10
3030. 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.
- Aa. UNION
- Bb. UNION ALL
- Cc. INTERSECT
- Dd. MINUS
3131. 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?
- Aa. 0
- Bb. 2
- Cc. 8
- Dd. 10
3232. The ____ operator could be used in place of INTERSECT if the RDBMS does not support it.
- Aa. IN
- Bb. OF
- Cc. AND
- Dd. UNION
3333. The ____ operator could be used in place of MINUS if the RDBMS does not support it.
- Aa. IN
- Bb. NOT IN
- Cc. AND
- Dd. UNION
3434. The Oracle equivalent to an MS Access AutoNumber is a(n) ____.
- Aa. auto-number
- Bb. sequence
- Cc. TO_NUMBER function
- Dd. Trigger
3535. The ____ pseudo-column is used to select the next value from a sequence.
- Aa. CURRVAL
- Bb. NEXTVAL
- Cc. NEXT
- Dd. GET_NEXT
3636. A(n) ____ is a block of code (containing standard SQL statements and procedural extensions) that is stored and executed at the DBMS server.
- Aa. PSM
- Bb. PLS
- Cc. SQL Statement
- Dd. PMR
3737. 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.
- Aa. triggers
- Bb. indexes
- Cc. embedded SQL
- Dd. procedural SQL
3838. The PL/SQL block starts with the ____ clause.
- Aa. IS
- Bb. OPEN
- Cc. DECLARE
- Dd. BEGIN
3939. Oracle recommends ____ for creating audit logs.
- Aa. triggers
- Bb. stored procedures
- Cc. stored functions
- Dd. tables
4040. A stored function uses the ____ statement to return a value.
- Aa. EXIT
- Bb. END
- Cc. RETURN
- Dd. PROCESS
Información
- Descripción
- asdf Test sobre Chapter 8 (Multiple Choice CIS 3365), creado por . . el 22/09/2016.
- Autor
- . .
- Idioma
- English
- Visitas
- 795
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test