Test: Section 15 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answ
Views 1,041 Downloads 30 File size 24KB
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