1z1-148 無料問題集「Oracle Database: Advanced PL/SQL」

（A）DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.

（B）DBMS_LOB.GETOPTIONS can only be used for BLOB data types.

（C）DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.

（D）If a table was not created with compression specified in the store as securefile clause then DBMS_LOB.SETOPTIONS can be used to enable it later.

（A）ALL_PROCEDURES

（B）ALL_OBJECTS

（C）ALL_ARGUMENTS

（D）ALL_PACKAGES

（A）The amount parameter can be set to DBMS_LOB.LOBMAXSIZE to indicate to load to the end of the BFILE.

（B）An exception will always be raised if amount plus src_offset exceeds the length of the BFILE.

（C）If any error occurs when calling the procedure then it is written to the warning parameter and DBMS_LOB.LOADCLOBFROMFILE finishes successfully.

（D）The amount parameter can be set to NULL to indicate to load to the end of the BFILE.

（A）Programs making use of large helper subroutines are good candidates for inlining.

（B）PRAGMA INLINE must be specified.

（C）PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.

（D）Only local subroutines can be inlined.

（E）PLSQL_OPTIMIZE_LEVEL must be set to 3 to inline external subroutines.

（A）Only DBAs can create or run parallel execution tasks.

（B）DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.

（C）To execute chunks in parallel, users must have CREATE JOB system privilege.

（D）No specific system privileges are required to create or run parallel execution tasks.

（E）Users with CREATE TASK privilege can create or run parallel execution tasks.

（A）COMM is set to 1000 for all records in the EMP table where DEPTNO = 30.

（B）The statement fails with error ORA-28115: policy with check option violation.

（C）COMM is set to 1000 for all records in the EMP table where DEPTNO=20.

（D）The statement executes successfully but no rows are updated.

（A）CUR_VAL must be a weakly typed cursor variable.

（B）CUR_VAL can be either a strongly or weakly typed cursor variable.

（C）CUR_VAL must be opened after this line is executed in the PL/SQL block.

（D）The PL/SQL block can continue to use the cursor variable after this line is executed.

（E）CUR_VAL must be opened before this line is executed in the PL/SQL block.

（A）The PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled.

（B）The PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled.

（C）The PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result.

（D）This statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level,

（A）curid NUMBER;

（B）src_cur SYS_REFCURSOR;

（C）curid := DBMS_SQL.TO_CURSOR_NUMBER (src_cur);

（D）src_cur= NUMBER;

（E）curid SYS_FEFCURSOR;

（F）src_cur := DBMS_SQL.TO_REFCURSOR (curid);

（A）Associative arrays may be used when you need to process information of unknown volume.

（B）Do not use nested tables when you need to delete elements.

（C）Varrays should be used when you need to pass the collection as a parameter.

（D）Nested tables should be used when the index values are non-sequential.

（E）Nested tables may be used when there is no predefined upper bound for index values.

（F）Use associative arrays when you need numeric and string indices.