Chapter 8 (True/False)

Question 1

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.

Accepted Answer

false

Answer

true

Question 2

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

Accepted Answer

false

Answer

true

Question 3

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.

Accepted Answer

true

Question 4

4. Procedural code is executed on the database client machine.

Accepted Answer

false

Answer

true

Question 5

5. PL/SQL functions are executed in the same way as functions such as MIN and AVG.

Accepted Answer

false

Answer

true

Question 6

6. Every PL/SQL block must be given a name

Accepted Answer

false

Answer

true

Question 7

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

Accepted Answer

true

Question 8

8. PL/SQL blocks have a section used to declare variables.

Accepted Answer

true

Question 9

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.

Accepted Answer

true

Question 10

10. Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

Accepted Answer

false

Answer

true

Question 11

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

Accepted Answer

true

Question 12

12. A trigger is executed as part of the transaction that triggered it.

Accepted Answer

true

Question 13

13. Triggers can only be used to update table values

Accepted Answer

false

Answer

true

Question 14

14. A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.

Accepted Answer

true

Question 15

15. Each statement inside the PL/SQL code must end with a period (“.”).

Accepted Answer

false

Answer

true

Question 16

16. To test a trigger, you should use the EXECUTE TRIGGER command.

Accepted Answer

false

Answer

true

Question 17

17. Just like database triggers, stored procedures are stored in the database.

Accepted Answer

true

Question 18

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

Accepted Answer

true

Question 19

19. One of the disadvantages of stored procedures is that they increase network traffic

Accepted Answer

false

Answer

true

Question 20

20. Stored procedures help reduce code duplication by means of code isolation and code sharing

Accepted Answer

true

Question 21

21. Stored procedures must have at least one argument.

Accepted Answer

false

Answer

true

Question 22

22. You can declare variables inside a stored procedure.

Accepted Answer

true

Question 23

23. Stored procedures are executed using the EXEC command.

Accepted Answer

true

Question 24

24. Cursors are held in a reserved memory area in the client computer.

Accepted Answer

false

Answer

true

Question 25

25. An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Accepted Answer

true

Question 26

26. An explicit cursor must return two or more rows

Accepted Answer

false

Answer

true

Question 27

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.

Accepted Answer

false

Answer

true

Question 28

28. Cursor-style processing involves retrieving data from the cursor, one row at a time.

Accepted Answer

true

Question 29

29. A stored function is another name for a stored procedure

Accepted Answer

false

Answer

true

Question 30

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.

Accepted Answer

false

Answer

true

Siguiente

Chapter 8 (True/False)

Descripción

Resumen del Recurso

Pregunta 1

Pregunta 2

Pregunta 3

Pregunta 4

Pregunta 5

Pregunta 6

Pregunta 7

Pregunta 8

Pregunta 9

Pregunta 10

Pregunta 11

Pregunta 12

Pregunta 13

Pregunta 14

Pregunta 15

Pregunta 16

Pregunta 17

Pregunta 18

Pregunta 19

Pregunta 20

Pregunta 21

Pregunta 22

Pregunta 23

Pregunta 24

Pregunta 25

Pregunta 26

Pregunta 27

Pregunta 28

Pregunta 29

Pregunta 30

Similar

	Creado por . . hace alrededor de 8 años