Quiz
Chapter 8 (True/False)
Questions in this 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.
- ATrue
- BFalse
22. SQL supports the conditional execution of procedures (if...then...else statements) that are typically sup-ported by a programming language
- ATrue
- BFalse
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.
- ATrue
- BFalse
44. Procedural code is executed on the database client machine.
- ATrue
- BFalse
55. PL/SQL functions are executed in the same way as functions such as MIN and AVG.
- ATrue
- BFalse
66. Every PL/SQL block must be given a name
- ATrue
- BFalse
77. In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.
- ATrue
- BFalse
88. PL/SQL blocks have a section used to declare variables.
- ATrue
- BFalse
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.
- ATrue
- BFalse
1010. Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.
- ATrue
- BFalse
1111. A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.
- ATrue
- BFalse
1212. A trigger is executed as part of the transaction that triggered it.
- ATrue
- BFalse
1313. Triggers can only be used to update table values
- ATrue
- BFalse
1414. A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.
- ATrue
- BFalse
1515. Each statement inside the PL/SQL code must end with a period (“.”).
- ATrue
- BFalse
1616. To test a trigger, you should use the EXECUTE TRIGGER command.
- ATrue
- BFalse
1717. Just like database triggers, stored procedures are stored in the database.
- ATrue
- BFalse
1818. One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.
- ATrue
- BFalse
1919. One of the disadvantages of stored procedures is that they increase network traffic
- ATrue
- BFalse
2020. Stored procedures help reduce code duplication by means of code isolation and code sharing
- ATrue
- BFalse
2121. Stored procedures must have at least one argument.
- ATrue
- BFalse
2222. You can declare variables inside a stored procedure.
- ATrue
- BFalse
2323. Stored procedures are executed using the EXEC command.
- ATrue
- BFalse
2424. Cursors are held in a reserved memory area in the client computer.
- ATrue
- BFalse
2525. An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.
- ATrue
- BFalse
2626. An explicit cursor must return two or more rows
- ATrue
- BFalse
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.
- ATrue
- BFalse
2828. Cursor-style processing involves retrieving data from the cursor, one row at a time.
- ATrue
- BFalse
2929. A stored function is another name for a stored procedure
- ATrue
- BFalse
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.
- ATrue
- BFalse
Information
- Description
- asdf Quiz on Chapter 8 (True/False), created by . . on 22/09/2016.
- Author
- . .
- Language
- English
- Views
- 484
- History
- Created on 22 Sep 2016 · updated on 18 Jan 2017
- Tags
- Rating
- No ratings yet Rate this quiz