Chapter 8 (Multiple Choice CIS 3365)

Beschreibung

asdf Quiz am Chapter 8 (Multiple Choice CIS 3365), erstellt von . . am 22/09/2016.
. .
Quiz von . ., aktualisiert more than 1 year ago
. .
Erstellt von . . vor fast 8 Jahre
745
3

Zusammenfassung der Ressource

Frage 1

Frage
1. The following SQL statement uses a(n) ____.SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAMEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;
Antworten
  • a. set operator
  • b. natural join
  • c. “old-style” join
  • d. procedural statement

Frage 2

Frage
2. When using a(n) ____ join, only rows that meet the given criteria are returned.
Antworten
  • a. full
  • b. inner
  • c. outer
  • d. set

Frage 3

Frage
3. The statement SELECT * FROM T1, T2 produces a(n) ____ join.
Antworten
  • a. cross
  • b. natural
  • c. equi
  • d. full

Frage 4

Frage
4. How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?
Antworten
  • a. 8
  • b. 18
  • c. 26
  • d. 144

Frage 5

Frage
5. A(n) ____ join will select only the rows with common values in the common attribute(s).
Antworten
  • a. natural
  • b. cross
  • c. full
  • d. outer

Frage 6

Frage
6. 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.
Antworten
  • a. OF
  • b. USING
  • c. HAS
  • d. JOIN ON

Frage 7

Frage
7. The ANSI standard defines ____ type(s) of outer join(s)
Antworten
  • a. one
  • b. two
  • c. three
  • d. four

Frage 8

Frage
8. 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.
Antworten
  • a. outer
  • b. inner
  • c. equi
  • d. cross

Frage 9

Frage
9. The syntax for a left outer join is ____.
Antworten
  • a. SELECT column-list FROM table1 OUTER JOIN table2 LEFTWHERE join-condition
  • b. SELECT column-list FROM table1 LEFT [OUTER] JOIN table2ON join-condition
  • c. SELECT column-list WHERE LEFT table1 = table 2
  • d. SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition

Frage 10

Frage
10. A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.
Antworten
  • a. natural
  • b. cross
  • c. full outer
  • d. left outer

Frage 11

Frage
11. A ____ is a query (SELECT statement) inside a query.
Antworten
  • a. subquery
  • b. range query
  • c. join
  • d. set query

Frage 12

Frage
12. In subquery terminology, the first query in the SQL statement is known as the ____ query.
Antworten
  • a. outer
  • b. left
  • c. inner
  • d. base

Frage 13

Frage
13. In a subquery, the ____ query is executed first
Antworten
  • a. left
  • b. right
  • c. inner
  • d. outer

Frage 14

Frage
14.The ____ function returns the current system date in MS Access.
Antworten
  • a. TO_DATE(
  • b. SYSDATE()
  • c. DATE()
  • d. TODAY()

Frage 15

Frage
15. When using the Oracle TO_DATE function, the code ____ represents a three-letter month name.
Antworten
  • a. MON
  • b. MM3
  • c. MONTH
  • d. MM

Frage 16

Frage
16. The Oracle ____ function returns the current date
Antworten
  • a. DATE
  • b. SYSDATE
  • c. CURRENT_DATE
  • d. TO_DATE

Frage 17

Frage
17. In Oracle, the ____ function converts a date to a character string.
Antworten
  • a. CONVERT()
  • b. TO_DATE
  • c. TO_CHAR()
  • d. TO_STRING()

Frage 18

Frage
18. The Oracle string concatenation function is ____.
Antworten
  • a. CONCAT
  • b. +
  • c. ||
  • d. &&

Frage 19

Frage
19. When using the Oracle TO_NUMBER function to convert a character string into a number, ____represents a digit.
Antworten
  • a. 0
  • b. 9
  • c. $
  • d. #

Frage 20

Frage
20. ____ is a relational set operator.
Antworten
  • a. MINUS
  • b. PLUS
  • c. ALL
  • d. EXISTS

Frage 21

Frage
21. “Union-compatible” means that the ____.
Antworten
  • a. names of the relation attributes can be different, but the data types must be identical
  • b. names of the relation attributes must be the same, but the data types can be different
  • c. names of the relation attributes must be the same and their data types must be identical
  • d. number of attributes must be the same, but the names and data types can be different

Frage 22

Frage
22. The ____ data type is considered compatible with VARCHAR(35).
Antworten
  • a. DATE
  • b. INT
  • c. TINYINT
  • d. CHAR(15)

Frage 23

Frage
23. 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.
Antworten
  • a. NVL
  • b. TO_CHAR
  • c. DECODE
  • d. CONVERT

Frage 24

Frage
24. The ____ data type is compatible with NUMBER.
Antworten
  • a. VARCHAR(15)
  • b. SMALLINT
  • c. DATE
  • d. CHAR(10)

Frage 25

Frage
25. The ____ query combines rows from two queries and excludes duplicates.
Antworten
  • a. UNION
  • b. UNION ALL
  • c. INTERSECT
  • d. MINUS

Frage 26

Frage
26. The syntax for the UNION query is ____.
Antworten
  • a. query + query
  • b. UNION (query, query)
  • c. UNION: query query
  • d. query UNION query

Frage 27

Frage
27. 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?
Antworten
  • a. 7
  • b. 10
  • c. 15
  • d. 17

Frage 28

Frage
28. 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?
Antworten
  • a. 7
  • b. 10
  • c. 15
  • d. 17

Frage 29

Frage
29. 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?
Antworten
  • a. 0
  • b. 2
  • c. 7
  • d. 10

Frage 30

Frage
30. 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.
Antworten
  • a. UNION
  • b. UNION ALL
  • c. INTERSECT
  • d. MINUS

Frage 31

Frage
31. 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?
Antworten
  • a. 0
  • b. 2
  • c. 8
  • d. 10

Frage 32

Frage
32. The ____ operator could be used in place of INTERSECT if the RDBMS does not support it.
Antworten
  • a. IN
  • b. OF
  • c. AND
  • d. UNION

Frage 33

Frage
33. The ____ operator could be used in place of MINUS if the RDBMS does not support it.
Antworten
  • a. IN
  • b. NOT IN
  • c. AND
  • d. UNION

Frage 34

Frage
34. The Oracle equivalent to an MS Access AutoNumber is a(n) ____.
Antworten
  • a. auto-number
  • b. sequence
  • c. TO_NUMBER function
  • d. Trigger

Frage 35

Frage
35. The ____ pseudo-column is used to select the next value from a sequence.
Antworten
  • a. CURRVAL
  • b. NEXTVAL
  • c. NEXT
  • d. GET_NEXT

Frage 36

Frage
36. A(n) ____ is a block of code (containing standard SQL statements and procedural extensions) that is stored and executed at the DBMS server.
Antworten
  • a. PSM
  • b. PLS
  • c. SQL Statement
  • d. PMR

Frage 37

Frage
37. 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.
Antworten
  • a. triggers
  • b. indexes
  • c. embedded SQL
  • d. procedural SQL

Frage 38

Frage
38. The PL/SQL block starts with the ____ clause.
Antworten
  • a. IS
  • b. OPEN
  • c. DECLARE
  • d. BEGIN

Frage 39

Frage
39. Oracle recommends ____ for creating audit logs.
Antworten
  • a. triggers
  • b. stored procedures
  • c. stored functions
  • d. tables

Frage 40

Frage
40. A stored function uses the ____ statement to return a value.
Antworten
  • a. EXIT
  • b. END
  • c. RETURN
  • d. PROCESS
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

El Perdón
Alonso Linares
Investiga las transformaciones de la cultura y de la vida cotidiana a lo largo del tiempo.
Sherlyn Muñoz
Irene
i.biza
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
Funciones Polinomiales
Julieta Maya
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes