1. You can define variables and assign values to them using PLSQL_CCFLAGS. Then test the values of the variables using inquiry directives. True or False?
(1) Point
Correct
2. How would you determine the current Oracle database version?
(1) Point
Correct
3. Identify the selection directives used in conditional compilation.
(1) Point
Incorrect. Refer to Section 15 Lesson 3.
4. Conditional compilation allows you to include extra code to help with debugging, which can be removed once errors are resolved. True or False?
(1) Point
Correct
5. Obfuscation does not allow anyone to see the source code, including the owner. True or False?
(1) Point
Correct
6. 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?
(1) Point
Correct
7. Below are the steps to obfuscate a PL/SQL subprogram using the wrapper utility. What is the missing step?
1. Create a text file containing your complete unwrapped source code. 2. Execute WRAP to create a second text file containing the wrapped code. 3. Connect to the database and execute the wrapped text file as a script to compile the wrapped code into the Data Dictionary.
(1) Point
Incorrect. Refer to Section 15 Lesson 4.
8. Native compilation always runs faster; therefore SQL statements in PL/SQL will always run faster, also. True or False?
(1) Point
Incorrect. Refer to Section 15 Lesson 1.
9. 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?
(1) Point
Incorrect. Refer to Section 15 Lesson 1.
10. 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?
(1) Point
Correct
11. What are the valid values for PLSQL_OPTIMIZE_LEVEL in the data dictionary?
(1) Point
Incorrect. Refer to Section 15 Lesson 1.
12. An error in PL/SQL is when the compiler does not proceed successfully and an error message is displayed. True or False?
(1) Point
Correct
13. 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?
(1) Point
Incorrect. Refer to Section 15 Lesson 2.
14. 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';
1. What is the name of the column used to identify the PLSQL_OPTIMIZE_LEVEL in the data dictionary?
(1) Point
Incorrect. Refer to Section 15 Lesson 1.
2. Which data dictionary view allows you to see the setting for PLSQL_OPTIMIZE_LEVEL?
(1) Point
Incorrect. Refer to Section 15 Lesson 1.
3. To determine the current setting for PLSQL_OPTIMIZE_LEVEL, query the data dictionary view USER_PLSQL_OBJECTS_SETTINGS. True or False?
(1) Point
Correct
4. PLSQL_CODE_TYPE determines the type of code for both PL/SQL code and for SQL statements, which is what speeds up the execution speed. True or False?
6. Which pair of DBMS_WARNING commands would allow you to obtain the current settings and change and restore those settings in a PL/SQL subprogram? (Choose two)
(1) Point
Incorrect. Refer to Section 15 Lesson 2.
7. The informational warning level of the PL/SQL compiler identifies _____________.
(1) Point
Incorrect. Refer to Section 15 Lesson 2.
8. In the USER_ERRORS data dictionary view, if an error is prefixed with "Warning," the command completes but has a side effect the user needs to know about. For all other errors, the command terminates abnormally. True or False?
(1) Point
Correct
9. To create obfuscated code using the wrapper utility, determine the order in which to execute the following steps. A Connect to the database and execute the wrapped text file as a script to compile the wrapped code into the Data Dictionary. B Log into the database server computer. C Create a text file containing your complete unwrapped source code. D Execute WRAP to create a second text file containing the wrapped code.
(1) Point
Incorrect. Refer to Section 15 Lesson 4.
10. For PL/SQL code larger than 32,767 characters, you must use the wrap utility. True or False?
(1) Point
1. The two statements below are equivalent. True or False?
3. Which pair of DBMS_WARNING commands would allow you to obtain the current settings and change and restore those settings in a PL/SQL subprogram? (Choose two)
(1) Point
Incorrect. Refer to Section 15 Lesson 2.
4. The two statements below are equivalent. True or False?
ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:SEVERE';
(1) Point
Incorrect. Refer to Section 15 Lesson 2.
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:
(1) Point
Correct
6. In the following example, what statement belongs in Line A?
ALTER SESSION SET PLSQL_CCFLAGS = 'debug:true';
CREATE OR REPLACE PROCEDURE testproc IS BEGIN ... $IF $$debug $THEN DBMS_OUTPUT.PUT_LINE('This code was executed'); -- Line A ... END testproc;
ALTER SESSION SET PLSQL_CCFLAGS = 'debug:false';
(1) Point
Correct
7. 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;
(1) Point
Correct
8. You can define variables and assign values to them using PLSQL_CCFLAGS. Then test the values of the variables using inquiry directives. True or False?
(1) Point
Correct
9. Obfuscation does not allow anyone to see the source code, including the owner. True or False?
(1) Point
Correct
11. Below are the steps to obfuscate a PL/SQL subprogram using the wrapper utility. What is the missing step?
1. Create a text file containing your complete unwrapped source code. 2. Execute WRAP to create a second text file containing the wrapped code. 3. Connect to the database and execute the wrapped text file as a script to compile the wrapped code into the Data Dictionary.
(1) Point
Correct
12. What are the valid values for PLSQL_OPTIMIZE_LEVEL in the data dictionary?
(1) Point
Correct
13. 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?
(1) Point
Incorrect. Refer to Section 15 Lesson 1.
14. To set the PLSQL_CODE_TYPE to its fastest execution speed, which command do you use?
(1) Point
Incorrect. Refer to Section 15 Lesson 1.
15. Native compilation always runs faster; therefore SQL statements in PL/SQL will always run faster, also. True or False?
(1) Point
10. 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?
1. Which command would you use to see if your triggers are enabled or disabled? Tandai untuk Ditinjau (1) Point SELECT trigger_name, status FROM USER_TRIGGERS; (*) SELECT trigger_name, trigger_type FROM USER_TRIGGERS; SELECT object_name, status FROM USER_OBJECTS WHERE object_type = 'TRIGGER'; DESCRIBE TRIGGER Incorrect. Refer to Section 13 Lesson 5. 2. After the following SQL statement is executed, all the triggers on the DEPARTMENTS table will no longer fire, but will remain in the database. True or False? ALTER TABLE departments DISABLE ALL TRIGGERS; Tandai untuk Ditinjau (1) Point True (*) False Correct 3. A user creates the following trigger: CREATE OR REPLACE TRIGGER emp_trigg AFTER DELETE ON employees BEGIN ... END; The user now tries to drop the EMPLOYEES table. What happens? Tandai untuk Ditinjau (1) Point Both the table and the trigger are dropped. (*) The table is dropped and the trigger is disabled. The ...
1. Which of the following statements about the %ISOPEN cursor attribute is true? Tandai untuk Ditinjau (1) Point If a cursor is open, then the value of %ISOPEN is false. You can issue the %ISOPEN cursor attribute only when more than one record is returned. You can issue the %ISOPEN cursor attribute only when a cursor is open. You can issue the %ISOPEN cursor attribute when a cursor is open or closed. (*) Correct 2. Assume that you have declared a cursor called C_EMP. Which of the following statements about C_EMP is correct? (Choose two.) Tandai untuk Ditinjau (1) Point You can use c_emp%NOTFOUND to exit a loop. (*) You can use c_emp%ROWCOUNT to return the number of rows returned by the cursor so far. (*) You can fetch rows when c_emp%ISOPEN evaluates to FALSE. You can use c_emp%FOUND after the cursor is closed. Correct 3. You execute the following code: DECLARE CURSOR emp_curs IS SELECT last_name FROM employees; v_last_n...
1. Which of the following statements will show whether procedure myproc is valid or invalid? Tandai untuk Ditinjau (1) Point SELECT * FROM deptree; SELECT status FROM USER_PROCEDURES WHERE procedure_name = 'MYPROC'; SELECT status FROM USER_OBJECTS WHERE object_type = 'PROCEDURE' AND object_name = 'MYPROC'; (*) SELECT valid FROM USER_OBJECTS WHERE object_type = 'PROCEDURE' AND object_name = 'MYPROC'; Incorrect. Refer to Section 14 Lesson 1. 2. A single procedure can be both a referenced object and a dependent object. True or False? Tandai untuk Ditinjau (1) Point True (*) False Correct 3. A single PL/SQL subprogram such as a procedure can be both a referenced object and a dependent object. True or False? Tandai untuk Ditinjau (1) Point True (*) False Correct 4. View dept_view is based on a select from table departments. Procedure show_dept contains code which selects from dept_view. Which of the following statements are true? (C...
Komentar
Posting Komentar