Copy and Edit

Chapter 8 (Multiple Choice CIS 3365)

Description

asdf Quiz on Chapter 8 (Multiple Choice CIS 3365), created by . . on 22/09/2016.
. .
Quiz by . ., updated more than 1 year ago
. .
Created by . . over 8 years ago
770
3
0
1 2 3 4 5 (0)

Resource summary

Question 1

Question
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;
Answer
  • a. set operator
  • b. natural join
  • c. “old-style” join
  • d. procedural statement

Question 2

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

Question 3

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

Question 4

Question
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?
Answer
  • a. 8
  • b. 18
  • c. 26
  • d. 144

Question 5

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

Question 6

Question
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.
Answer
  • a. OF
  • b. USING
  • c. HAS
  • d. JOIN ON

Question 7

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

Question 8

Question
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.
Answer
  • a. outer
  • b. inner
  • c. equi
  • d. cross

Question 9

Question
9. The syntax for a left outer join is ____.
Answer
  • 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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

Question
21. “Union-compatible” means that the ____.
Answer
  • 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

Question 22

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

Question 23

Question
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.
Answer
  • a. NVL
  • b. TO_CHAR
  • c. DECODE
  • d. CONVERT

Question 24

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

Question 25

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

Question 26

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

Question 27

Question
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?
Answer
  • a. 7
  • b. 10
  • c. 15
  • d. 17

Question 28

Question
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?
Answer
  • a. 7
  • b. 10
  • c. 15
  • d. 17

Question 29

Question
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?
Answer
  • a. 0
  • b. 2
  • c. 7
  • d. 10

Question 30

Question
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.
Answer
  • a. UNION
  • b. UNION ALL
  • c. INTERSECT
  • d. MINUS

Question 31

Question
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?
Answer
  • a. 0
  • b. 2
  • c. 8
  • d. 10

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

Question
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.
Answer
  • a. triggers
  • b. indexes
  • c. embedded SQL
  • d. procedural SQL

Question 38

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

Question 39

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

Question 40

Question
40. A stored function uses the ____ statement to return a value.
Answer
  • a. EXIT
  • b. END
  • c. RETURN
  • d. PROCESS
Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Investiga las transformaciones de la cultura y de la vida cotidiana a lo largo del tiempo.
Sherlyn Muñoz
Irene
i.biza
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
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
Browse Library