Copiar e Editar

CHAPTER 8: ADVANCED SQL

Descrição

CIS 3365 Quiz sobre CHAPTER 8: ADVANCED SQL, criado por Miguel Lucero em 05-04-2017.
Miguel Lucero
Quiz por Miguel Lucero, atualizado more than 1 year ago
Miguel Lucero
Criado por Miguel Lucero mais de 7 anos atrás
452
2
0

Resumo de Recurso

Questão 1

Questão
1. A relational join operation merges rows from two tables.
Responda
  • True
  • False

Questão 2

Questão
2. An inequality condition is also known as a natural join and an equality condition is also called a theta join.
Responda
  • True
  • False

Questão 3

Questão
3. Subqueries cannot be used in combinations with joins.
Responda
  • True
  • False

Questão 4

Questão
4. The SELECT statement uses the attribute list to indicate what columns to project in the resulting set.
Responda
  • True
  • False

Questão 5

Questão
5. Numeric functions take one numeric parameter and return one value.
Responda
  • True
  • False

Questão 6

Questão
6. String manipulation functions are rarely used in programming.
Responda
  • True
  • False

Questão 7

Questão
7. UNION, INTERSECT, and MINUS work properly only if relations are intersect-compatible, which means that the names of the relation attributes and their data types must be different.
Responda
  • True
  • False

Questão 8

Questão
8. A view is a virtual table based on a SELECT query.
Responda
  • True
  • False

Questão 9

Questão
9. A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.
Responda
  • True
  • False

Questão 10

Questão
10. SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language.
Responda
  • True
  • False

Questão 11

Questão
11. To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.
Responda
  • True
  • False

Questão 12

Questão
12. A persistent stored module is stored and executed on the database client machine.
Responda
  • True
  • False

Questão 13

Questão
13. Every PL/SQL block must be given a name.
Responda
  • True
  • False

Questão 14

Questão
14. In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.
Responda
  • True
  • False

Questão 15

Questão
15. PL/SQL blocks have a section used to declare variables.
Responda
  • True
  • False

Questão 16

Questão
16. The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.
Responda
  • True
  • False

Questão 17

Questão
17. Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.
Responda
  • True
  • False

Questão 18

Questão
18. A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.
Responda
  • True
  • False

Questão 19

Questão
19. Triggers can only be used to update table values.
Responda
  • True
  • False

Questão 20

Questão
20. A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.
Responda
  • True
  • False

Questão 21

Questão
21. A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.
Responda
  • True
  • False

Questão 22

Questão
22. MySQL allows multiple triggering conditions per trigger.
Responda
  • True
  • False

Questão 23

Questão
23. BEFORE means before the changes are made in memory but after the changes are permanently saved to disk.
Responda
  • True
  • False

Questão 24

Questão
24. Just like database triggers, stored procedures are stored in the database.
Responda
  • True
  • False

Questão 25

Questão
25. One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.
Responda
  • True
  • False

Questão 26

Questão
26. Stored procedures must have at least one argument.
Responda
  • True
  • False

Questão 27

Questão
27. Variables can be declared inside a stored procedure.
Responda
  • True
  • False

Questão 28

Questão
28. Cursors are held in a reserved memory area in the client computer.
Responda
  • True
  • False

Questão 29

Questão
29. An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one
Responda
  • True
  • False

Questão 30

Questão
30. An explicit cursor must return two or more rows.
Responda
  • True
  • False

Questão 31

Questão
31. A stored function is another name for a stored procedure.
Responda
  • True
  • False

Questão 32

Questão
Linked SQL” is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.
Responda
  • True
  • False

Questão 33

Questão
33. The following SQL statement uses a(n) . SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
Responda
  • a. set operator
  • b. natural join
  • c. “old­style” join
  • d. procedural statement

Questão 34

Questão
34. When using a(n) join, only rows that meet the given criteria are returned.
Responda
  • a. full
  • b. inner
  • c. outer
  • d. set

Questão 35

Questão
35. The statement SELECT * FROM T1, T2 produces a(n) join.
Responda
  • a. cross
  • b. natural
  • c. equi-
  • d. full

Questão 36

Questão
36. How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?
Responda
  • a. 8
  • b. 18
  • c. 26
  • d. 144

Questão 37

Questão
37. A(n) join will select only the rows with matching values in the common attribute(s).
Responda
  • a. natural
  • b. cross
  • c. full
  • d. outer

Questão 38

Questão
38. If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.
Responda
  • a. OF
  • b. USING
  • c. HAS
  • d. JOIN ON

Questão 39

Questão
39. 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.
Responda
  • a. outer
  • b. inner
  • c. equi-
  • d. cross

Questão 40

Questão
40. The syntax for a left outer join is .
Responda
  • a. SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition
  • b. SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition
  • SELECT column-list WHERE LEFT table1 = table 2
  • . SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition

Questão 41

Questão
41. In subquery terminology, the first query in the SQL statement is known as the query.
Responda
  • a. outer
  • b. left
  • c. inner
  • d. base

Questão 42

Questão
42. In the context of SELECT subquery types, a is returned when an UPDATE subquery is used.
Responda
  • a. NULL
  • b. single value
  • c. list of values
  • d. virtual table

Questão 43

Questão
43. Which of the following is a feature of a correlated subquery?
Responda
  • a. The inner subquery executes first.
  • b. The outer subquery initiates the process of execution in a subquery.
  • c. The inner subquery initiates the process of execution in a subquery.
  • d. The outer subquery executes independent of the inner subquery

Questão 44

Questão
44. The function returns the current system date in MS Access.
Responda
  • a. TO_DATE()
  • b. SYSDATE()
  • c. DATE()
  • d. TODAY()

Questão 45

Questão
45. When using the Oracle TO_DATE function, the code represents a three-letter month name.
Responda
  • a. MON
  • b. MM3
  • c. MONTH
  • d. MM

Questão 46

Questão
46. In Oracle, the function converts a date to a character string.
Responda
  • a. CONVERT()
  • b. TO_DATE
  • c. TO_CHAR()
  • d. TO_STRING()

Questão 47

Questão
is a string function that returns the number of characters in a string value.
Responda
  • a. LENGTH
  • b. SUBSTRING
  • c. CONCAT
  • d. UCASE

Questão 48

Questão
48. When using the Oracle TO_NUMBER function to convert a character string into a number, represents a digit.
Responda
  • a. 0
  • b. 9
  • c. $
  • d. #

Questão 49

Questão
49. 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.
Responda
  • a. NVL
  • b. TO_CHAR
  • c. DECODE
  • d. CONVERT

Questão 50

Questão
50. is a relational set operator.
Responda
  • a. MINUS
  • b. PLUS
  • c. ALL
  • d. EXISTS

Questão 51

Questão
51. “Union­compatible” means that the .
Responda
  • a. names of the relation attributes can be different, but the data types must be alike
  • 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 alike
  • d. number of attributes must be the same, but the names and data types can be different

Questão 52

Questão
52. The data type is considered compatible with VARCHAR(35).
Responda
  • a. DATE
  • b. INT
  • c. TINYINT
  • d. CHAR(15)

Questão 53

Questão
53. The statement combines rows from two queries and excludes duplicates.
Responda
  • a. UNION
  • b. UNION ALL
  • c. INTERSECT
  • d. MINUS

Questão 54

Questão
54. 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?
Responda
  • a. 7
  • b. 10
  • c. 15
  • d. 17

Questão 55

Questão
55. 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?
Responda
  • a. 7
  • b. 10
  • c. 15
  • d. 17

Questão 56

Questão
56. 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?
Responda
  • a. 0
  • b. 2
  • c. 7
  • d. 10

Questão 57

Questão
57. 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.
Responda
  • a. UNION
  • b. UNION ALL
  • c. INTERSECT
  • d. MINUS

Questão 58

Questão
58. 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?
Responda
  • a. 0
  • b. 2
  • c. 8
  • d. 10

Questão 59

Questão
59. The operator could be used in place of INTERSECT if the DBMS does not support it.
Responda
  • a. IN
  • b. OF
  • c. AND
  • d. UNION

Questão 60

Questão
60. The operator could be used in place of MINUS if the DBMS does not support it.
Responda
  • a. IN
  • b. NOT IN
  • c. AND
  • d. UNION

Questão 61

Questão
61. The Oracle equivalent to an MS Access AutoNumber is a(n) .
Responda
  • a. auto-number
  • b. sequence
  • c. TO_NUMBER function
  • d. trigger

Questão 62

Questão
62. Which of the following is a feature of oracle sequences?
Responda
  • a. Oracle sequences are tied to columns and tables.
  • b. Oracle sequences generate a character string that can be assigned to tables.
  • c. An oracle sequence uses the identity column property to automatically number rows.
  • d. An oracle sequence can be created and deleted anytime.

Questão 63

Questão
63. The pseudo-column is used to select the next value from a sequence.
Responda
  • a. CURRVAL
  • b. NEXTVAL
  • c. NEXT
  • d. GET_NEXT

Questão 64

Questão
64. 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.
Responda
  • a. cursor-style processing
  • b. stored procedures
  • c. embedded SQL
  • d. Procedural Language SQL

Questão 65

Questão
65. The Oracle string concatenation function is .
Responda
  • a. CONCAT
  • b. +
  • c. ||
  • d. &&

Questão 66

Questão
66. The PL/SQL block starts with the section.
Responda
  • a. IS
  • b. OPEN
  • c. DECLARE
  • d. BEGIN

Questão 67

Questão
67. Oracle recommends for creating audit logs.
Responda
  • a. triggers
  • b. stored procedures
  • c. stored functions
  • d. tables

Questão 68

Questão
68. is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not.
Responda
  • a. %ROWCOUNT
  • b. %NOTFOUND
  • c. %FOUND
  • d. %ISOPEN

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

Como Transformar Flashcards em Suporte
Alessandra S.
Gramática - Visão Geral - Fonologia
tiago meira de almeida
História do Brasil - Período Colonial
alessandra
Conjunções
GoConqr suporte .
Como Estudar Matemática
GoConqr suporte .
Pré-História
Valdemir Júnior
A INTEGRAÇÃO DAS TDIC À PEDAGOGIA: UMA CONCEPÇÃO DE WEB CURRÍCULO
Malton Fuckner
Teorias atomicas
Vitor Felix
Crise da República e a ruptura de 1930
jacson luft
Escala
Leandro Ribeiro
PLATELMINTOS
Taína Garcia Moreno Tomazella
Explore a Biblioteca