Answer Section 15 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 15

The two statements below are equivalent. True or False?

DBMS_WARNING.ADD_WARNING_SETTING_CAT

    ('INFORMATIONAL','ENABLE','SESSION');

and

ALTER SESSION

    SET PLSQL_WARNINGS = 'ENABLE:INFORMATIONAL';                                                                

                                               

                True (*)

                                               

                False

                                                                              

                                                               

An error in PL/SQL is when the compiler does not proceed successfully and an error message is displayed. True or False?

                                                                               

                                               

                True (*)

                                               

                False

                                                                               

                                                               

Select the three categories of PL/SQL compiler warning levels.

                                                                               

                                                (Choose all correct answers)      

                                                                               

                                               

                DISABLE

                                               

                SEVERE (*)

                                               

                INFORMATIONAL (*)

                                               

                PERFORMANCE (*)

                                               

                ENABLE

                                                                               

                                                               

Which PL/SQL warning message identifies code that can cause unexpected behavior or wrong results when executed?                                                                         

                                               

                ERROR

                                               

                PERFORMANCE

                                               

                ALL

                                               

                INFORMATIONAL

                                               

                SEVERE (*)

                                                                               

Conditional compilation allows you to determine what code will be compiled based on select criteria you specify using inquiry flags. True or False?

                                                                               

                                               

                True

                                               

                False (*)

In order to use the deterministic functions in Oracle version 11, you can use the following sample code to test for the Oracle version before compiling that section. True or False?

CREATE OR REPLACE FUNCTION myfunc

  RETURN NUMBER

    $IF DBMS_DB_VERSION.VERSION >= 11 $THEN

       DETERMINISTIC

    $END

IS BEGIN

   -- body of function

END myfunc;

                                                                               

                                               

                True (*)

                                               

                False

                                                                               

                                                               

How would you determine the current Oracle database version?

                                                                               

                                               

                DBMS_DB_VERSION.VER_LE_10

                                               

                DBMS_DB_VERSION.VER_LE_11

                                               

                DBMS_DB_VERSION.RELEASE

                                               

                DBMS_DB_VERSION.VERSION (*)

                                                                               

                                                               

Identify the selection directives used in conditional compilation.

                                                                               

                                               

                $IF

                $THEN

                $ELSE $ELSIF

                $ENDIF

                                               

                $$IF

                $$THEN

                $$ELSE

                $$END

                $$DEBUG

                                               

                $IF

                $THEN

                $ELSE

                $END

                $CCFLAG

                                               

                $$IF

                $$THEN

                $$ELSE

                $$ELSIF

                $$END

                                               

                $IF

                $THEN

                $ELSE

                $ELSIF

                $END

                (*)

                                                                               

                                                               

Which is NOT a benefit of obfuscation?

                                                                               

                                               

                Protection for intellectual property is provided.

                                               

                Source code is not loaded in the data dictionary.

                                               

                Source code is hidden from all users.

                                               

                Source code is visible to the owner. (*)

                                                                               

                                                               

When wrapping subprograms, the entire PL/SQL code must be included as an IN argument with data type CLOB to allow for any size program. True or False?

                                               

                True

                                               

                False (*)

One benefit of obfuscation is to protect intellectual property written in PL/SQL. True or False?

                                                                               

                                               

                True (*)

                                               

                False

                                                                               

                                                               

Identify examples of benefits of using PLSQL_OPTIMIZE_LEVEL. (Choose three)              

                                                                               

                                                (Choose all correct answers)      

                                                                               

                                               

                Backward compatible with previous versions of the Oracle database (*)

                                               

                Control what PL/SQL does with useless code (*)

                                               

                Separating compiled code so that separate units may be repeated as needed

                                               

                Copy compiled code from one subprogram into another subprogram (*)

                                               

                Modify source code to optimize frequently-used elements at the top

                                                                                                               

Which data dictionary view allows you to see the setting for PLSQL_OPTIMIZE_LEVEL?

                                                                               

                                               

                USER_OBJECT_SETTINGS

                                               

                USER_PLSQL_CODE_TYPE

                                               

                USER_PLSQL_OPTIMIZE

                                               

                USER_PLSQL_OBJECT_SETTINGS (*)

                                               

                USER_PLSQL_OBJECTS

                                                                               

                                                               

Native compilation always runs faster; therefore SQL statements in PL/SQL will always run faster, also. True or False?

                                                                               

                                               

                True

                                               

                False (*)

                                                                               

                                                               

When setting PLSQL_OPTIMIZE_LEVEL = 3, the compiled code will run more slowly, but it will work with older versions of the Oracle software. True or False? 

                                                                               

                                               

                True

                                               

                False (*)