Copy and Edit

Chapter 8 (True/False)

Description

asdf Quiz on Chapter 8 (True/False), created by . . on 22/09/2016.
. .
Quiz by . ., updated more than 1 year ago
. .
Created by . . over 7 years ago
155
2
0

Resource summary

Question 1

Question
1. UNION, INTERSECT, and MINUS work properly only if relations are union-compatible, which means that the names of the relation attributes and their data types must be different.
Answer
  • True
  • False

Question 2

Question
2. SQL supports the conditional execution of procedures (if...then...else statements) that are typically sup-ported by a programming language
Answer
  • True
  • False

Question 3

Question
3. 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.
Answer
  • True
  • False

Question 4

Question
4. Procedural code is executed on the database client machine.
Answer
  • True
  • False

Question 5

Question
5. PL/SQL functions are executed in the same way as functions such as MIN and AVG.
Answer
  • True
  • False

Question 6

Question
6. Every PL/SQL block must be given a name
Answer
  • True
  • False

Question 7

Question
7. In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.
Answer
  • True
  • False

Question 8

Question
8. PL/SQL blocks have a section used to declare variables.
Answer
  • True
  • False

Question 9

Question
9. The most useful feature of PL/SQL blocks is that they let you create code that can be named, stored, and executed by the DBMS.
Answer
  • True
  • False

Question 10

Question
10. Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.
Answer
  • True
  • False

Question 11

Question
11. A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.
Answer
  • True
  • False

Question 12

Question
12. A trigger is executed as part of the transaction that triggered it.
Answer
  • True
  • False

Question 13

Question
13. Triggers can only be used to update table values
Answer
  • True
  • False

Question 14

Question
14. A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.
Answer
  • True
  • False

Question 15

Question
15. Each statement inside the PL/SQL code must end with a period (“.”).
Answer
  • True
  • False

Question 16

Question
16. To test a trigger, you should use the EXECUTE TRIGGER command.
Answer
  • True
  • False

Question 17

Question
17. Just like database triggers, stored procedures are stored in the database.
Answer
  • True
  • False

Question 18

Question
18. One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.
Answer
  • True
  • False

Question 19

Question
19. One of the disadvantages of stored procedures is that they increase network traffic
Answer
  • True
  • False

Question 20

Question
20. Stored procedures help reduce code duplication by means of code isolation and code sharing
Answer
  • True
  • False

Question 21

Question
21. Stored procedures must have at least one argument.
Answer
  • True
  • False

Question 22

Question
22. You can declare variables inside a stored procedure.
Answer
  • True
  • False

Question 23

Question
23. Stored procedures are executed using the EXEC command.
Answer
  • True
  • False

Question 24

Question
24. Cursors are held in a reserved memory area in the client computer.
Answer
  • True
  • False

Question 25

Question
25. An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.
Answer
  • True
  • False

Question 26

Question
26. An explicit cursor must return two or more rows
Answer
  • True
  • False

Question 27

Question
27. The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.
Answer
  • True
  • False

Question 28

Question
28. Cursor-style processing involves retrieving data from the cursor, one row at a time.
Answer
  • True
  • False

Question 29

Question
29. A stored function is another name for a stored procedure
Answer
  • True
  • False

Question 30

Question
30. "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.
Answer
  • True
  • False
Show full summary Hide full summary

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

Similar

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
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
Funciones Polinomiales
Julieta Maya
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