Quiz
Chapter 8 (True/False)
Perguntas do quiz (30)
11. 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.
- AVerdadeiro
- BFalso
22. SQL supports the conditional execution of procedures (if...then...else statements) that are typically sup-ported by a programming language
- AVerdadeiro
- BFalso
33. 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.
- AVerdadeiro
- BFalso
44. Procedural code is executed on the database client machine.
- AVerdadeiro
- BFalso
55. PL/SQL functions are executed in the same way as functions such as MIN and AVG.
- AVerdadeiro
- BFalso
66. Every PL/SQL block must be given a name
- AVerdadeiro
- BFalso
77. In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.
- AVerdadeiro
- BFalso
88. PL/SQL blocks have a section used to declare variables.
- AVerdadeiro
- BFalso
99. 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.
- AVerdadeiro
- BFalso
1010. Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.
- AVerdadeiro
- BFalso
1111. A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.
- AVerdadeiro
- BFalso
1212. A trigger is executed as part of the transaction that triggered it.
- AVerdadeiro
- BFalso
1313. Triggers can only be used to update table values
- AVerdadeiro
- BFalso
1414. A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.
- AVerdadeiro
- BFalso
1515. Each statement inside the PL/SQL code must end with a period (“.”).
- AVerdadeiro
- BFalso
1616. To test a trigger, you should use the EXECUTE TRIGGER command.
- AVerdadeiro
- BFalso
1717. Just like database triggers, stored procedures are stored in the database.
- AVerdadeiro
- BFalso
1818. One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.
- AVerdadeiro
- BFalso
1919. One of the disadvantages of stored procedures is that they increase network traffic
- AVerdadeiro
- BFalso
2020. Stored procedures help reduce code duplication by means of code isolation and code sharing
- AVerdadeiro
- BFalso
2121. Stored procedures must have at least one argument.
- AVerdadeiro
- BFalso
2222. You can declare variables inside a stored procedure.
- AVerdadeiro
- BFalso
2323. Stored procedures are executed using the EXEC command.
- AVerdadeiro
- BFalso
2424. Cursors are held in a reserved memory area in the client computer.
- AVerdadeiro
- BFalso
2525. An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.
- AVerdadeiro
- BFalso
2626. An explicit cursor must return two or more rows
- AVerdadeiro
- BFalso
2727. The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.
- AVerdadeiro
- BFalso
2828. Cursor-style processing involves retrieving data from the cursor, one row at a time.
- AVerdadeiro
- BFalso
2929. A stored function is another name for a stored procedure
- AVerdadeiro
- BFalso
3030. "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.
- AVerdadeiro
- BFalso
Informações
- Descrição
- asdf Quiz sobre Chapter 8 (True/False), criado por . . em 22-09-2016.
- Autor
- . .
- Idioma
- English
- Visualizações
- 484
- Histórico
- Criado em 22 set 2016 · atualizado em 18 jan 2017
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz