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

Nächster

Chapter 8 (True/False)

Beschreibung

Zusammenfassung der Ressource

Frage 1

Frage 2

Frage 3

Frage 4

Frage 5

Frage 6

Frage 7

Frage 8

Frage 9

Frage 10

Frage 11

Frage 12

Frage 13

Frage 14

Frage 15

Frage 16

Frage 17

Frage 18

Frage 19

Frage 20

Frage 21

Frage 22

Frage 23

Frage 24

Frage 25

Frage 26

Frage 27

Frage 28

Frage 29

Frage 30

ähnlicher Inhalt

	Erstellt von . . vor etwa 8 Jahre