6431924
Questão 1
Questão
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.
Responda
- True
- False
Questão 2
Questão
2. SQL supports the conditional execution of procedures (if...then...else statements) that are typically sup-ported by a programming language
Responda
- True
- False
Questão 3
Questão
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.
Responda
- True
- False
Questão 4
Questão
4. Procedural code is executed on the database client machine.
Responda
- True
- False
Questão 5
Questão
5. PL/SQL functions are executed in the same way as functions such as MIN and AVG.
Responda
- True
- False
Questão 6
Questão
6. Every PL/SQL block must be given a name
Responda
- True
- False
Questão 7
Questão
7. 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 8
Questão
8. PL/SQL blocks have a section used to declare variables.
Responda
- True
- False
Questão 9
Questão
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.
Responda
- True
- False
Questão 10
Questão
10. Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.
Responda
- True
- False
Questão 11
Questão
11. 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 12
Questão
12. A trigger is executed as part of the transaction that triggered it.
Responda
- True
- False
Questão 13
Questão
13. Triggers can only be used to update table values
Responda
- True
- False
Questão 14
Questão
14. A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.
Responda
- True
- False
Questão 15
Questão
15. Each statement inside the PL/SQL code must end with a period (“.”).
Responda
- True
- False
Questão 16
Questão
16. To test a trigger, you should use the EXECUTE TRIGGER command.
Responda
- True
- False
Questão 17
Questão
17. Just like database triggers, stored procedures are stored in the database.
Responda
- True
- False
Questão 18
Questão
18. 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 19
Questão
19. One of the disadvantages of stored procedures is that they increase network traffic
Responda
- True
- False
Questão 20
Questão
20. Stored procedures help reduce code duplication by means of code isolation and code sharing
Responda
- True
- False
Questão 21
Questão
21. Stored procedures must have at least one argument.
Responda
- True
- False
Questão 22
Questão
22. You can declare variables inside a stored procedure.
Responda
- True
- False
Questão 23
Questão
23. Stored procedures are executed using the EXEC command.
Responda
- True
- False
Questão 24
Questão
24. Cursors are held in a reserved memory area in the client computer.
Responda
- True
- False
Questão 25
Questão
25. An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.
Responda
- True
- False
Questão 26
Questão
26. An explicit cursor must return two or more rows
Responda
- True
- False
Questão 27
Questão
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.
Responda
- True
- False
Questão 28
Questão
28. Cursor-style processing involves retrieving data from the cursor, one row at a time.
Responda
- True
- False
Questão 29
Questão
29. A stored function is another name for a stored procedure
Responda
- True
- False
Questão 30
Questão
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.
Responda
- True
- False
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.