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 . . almost 8 years ago
199
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
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
Browse Library