• Author / Uploaded
• Dorin Chioibas

Citation preview

Test: Section 15 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 15 Quiz (Answer all questions in this section) 1. (Choose three) (1) Points

Identify examples of benefits of using PLSQL_OPTIMIZE_LEVEL. Mark for Review (Choose all correct answers)

Separating compiled code so that separate units may be repeated as needed Copy compiled code from one subprogram into another subprogram (*) Control what PL/SQL does with useless code (*) Modify source code to optimize frequently-used elements at the top Backward compatible with previous versions of the Oracle database (*)

Correct

Correct

2. Native compilation always runs faster; therefore SQL statements in PL/SQL will always run faster, also. True or False? Mark for Review (1) Points True False (*)

Correct

Correct

3. What is the name of the column used to identify the PLSQL_OPTIMIZE_LEVEL in the data dictionary? Mark for Review (1) Points PLSQL_OPTIMIZE_LEVEL (*) USER_PLSQL_OPTIMIZE

OPTIMIZE_LEVEL PLSQL_LEVEL PLSQL_CODE_TYPE

Correct

Correct

4. Native machine code PL/SQL will always execute faster than bytecode PL/SQL because it need not be interpreted at run time. True or False? Mark for Review (1) Points True (*) False

Correct

Correct

5. Conditional Compilation allows you to include some source code in your PL/SQL program that may be compiled or may be ignored depending on: Mark for Review (1) Points The value of a global package constant. The values of an initialization parameter. The version of the Oracle software you are using. Any of these could be used. (*)

Correct

Correct

Page 1 of 3 Next

Summary

Test: Section 15 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 15 Quiz (Answer all questions in this section) 6. The value of DBMS_DB_VERSION.VER_LE_11 is TRUE when the version of the Oracle database is version 11 or greater. True or False? Mark for Review (1) Points True False (*)

Correct

Correct

7. Conditional compilation allows you to determine what code will be compiled based on select criteria you specify using inquiry flags. True or False? Mark for Review (1) Points True False (*)

Correct

Correct

8. Mark for Review (1) Points

How would you determine the current Oracle database version?

DBMS_DB_VERSION.VERSION (*) DBMS_DB_VERSION.VER_LE_11 DBMS_DB_VERSION.RELEASE DBMS_DB_VERSION.VER_LE_10

Correct

Correct

9. Which PL/SQL warning message identifies code that can cause unexpected behavior or wrong results when executed? Mark for Review (1) Points

ERROR INFORMATIONAL SEVERE (*) ALL PERFORMANCE

Correct

Correct

10. A warning in PL/SQL is the same as an error in PL/SQL, but can only be viewed through the USER_ERRORS data dictionary view. True or False? Mark for Review (1) Points True False (*)

Correct Previous

Correct Page 2 of 3 Next

Summary

Test: Section 15 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 15 Quiz (Answer all questions in this section) 11. The informational warning level for PL/SQL compiled code identifies the code that may cause execution speed to be slow. True or False? Mark for Review (1) Points True False (*)

Correct

Correct

12. What does the following statement do? DBMS_WARNING.ADD_WARNING_SETTING_CAT('PERFORMANCE','ENABLE','SESSION'); Mark for Review (1) Points Add the PERFORMANCE warning category into a PL/SQL variable. Enables the PERFORMANCE warning category, leaving other category settings unchanged. Disables all warning categories, then enables the PERFORMANCE category. Enables the PERFORMANCE warning category, setting other category settings to disabled. Enables the PERFORMANCE warning category, leaving other category settings unchanged, for the current session. (*)

Correct

Correct

13. To obfuscate the procedure my_proc, what statement should be at Line A? BEGIN -- Line A ('CREATE OR REPLACE PROCEDURE mycleverproc (p_param1 IN NUMBER, p_param2 OUT NUMBER) IS BEGIN ... /* some clever but private code here */ END mycleverproc;'); END; Mark for Review (1) Points DBMS_DDL.WRAP_CODE DBMS_DDL.CREATE_WRAP DBMS_DDL.CREATE_WRAPPED (*) DBMS_DDL.WRAPPED

DBMS_DML.CREATE_WRAP

Correct

Correct 14.

Which is NOT a benefit of obfuscation?

Mark for Review

(1) Points Source code is visible to the owner. (*) Source code is hidden from all users. Protection for intellectual property is provided. Source code is not loaded in the data dictionary.

Correct

Correct

15. You created a package named pkg1. The code is approximately 90,000 characters. What is the statement that you use to obfuscate this package in the database? Mark for Review (1) Points DBMS_DDL.CREATE_WRAPPED (pkg1); WRAP INAME=pkg1.sql (*) WRAP pkg1.sql DBMS_DDL.CREATE_WRAP (pkg1); DBMS_DDL.CREATE_WRAPPED ('CREATE OR REPLACE PACKAGE BODY pkg1...);

Correct

Correct

Previous

Page 3 of 3 Summary