Quiz
Chapter 8 (True/False)
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
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
- 485
- Tags
- Rating
- No ratings yet Rate this quiz