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