Want to know Exambible 1Z0-146 Exam practice test features? Want to lear more about Oracle Oracle 11g: Advanced PL/SQL certification experience? Study Refined Oracle 1Z0-146 answers to Rebirth 1Z0-146 questions at Exambible. Gat a success with an absolute guarantee to pass Oracle 1Z0-146 (Oracle 11g: Advanced PL/SQL) test on your first attempt.

2017 Feb 1Z0-146 practice exam

Q21. Which two statements are true about SecureFile LOB options? (Choose two.) 

A. The COMPRESSION HIGH option can be enabled only for CLOBs. 

B. The COMPRESSION HIGH option can be enabled for all internal LOBs. 

C. The DECRYPT option can be used to remove encryption only if the LOB column is empty. 

D. The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain data. 

Answer: B,D 


Q22. You set RESULT_CACHE_MAX_SIZE to a nonzero value to enable result caching. You executed the following command to check the status for the result cache:, 

SQL> select dbms_result_cache.status() from dual; 

You receive the following output: 

DBMS_RESULT_CACHE.STATUS() 

DISABLED 

Identify the reason for the output. 

A. The RESULT_CACHE_MODE parameter is set to FORCE. 

B. The RESULT_CACHE_MODE parameter is set to MANUAL. 

C. The database instance is not able to allocate memory for the result cache. 

D. The database instance was started with the RESULT_CACHE_MAX_SIZE parameter set to 0. 

Answer:


Q23. The user OE is working on an app lication that needs to call an exte rnal C program multiple times in a single session. However, the extproc.exe file on the server gets accidentally deleted after the OE user connected and made calls to the external C program. Wh ich statement is true about the current session by the OE user? 

A. The session can continue calling the external C program. 

B. The session can call the external C program after republishing it. 

C. The session receives an error for the next call to the external C program. 

D. The session terminates during the subsequent call to the external C program. 

Answer:


Q24. Which two statements are true about cursor variables? (Choose two.) 

A. Cursor variables can be parameterized like cursors. 

B. The query associated with a cursor variable cannot reference host variables and PL/SQL variables. 

C. The FETCH statement executes the query associated with a cursor variable and identifies the result set. 

D. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable. 

E. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set. 

Answer: D,E 


Q25. View the Exhibit and examine the code in the PL/SQL block. 

The PL/SQL block generates an error on execution. What is the reason? 

A. The DELETE(n) method cannot be used with varrays. 

B. The DELETE(n) method cannot be used with nested tables. 

C. The NEXT method cannot be used with an associative array with VARCHAR2 key values. 

D. The NEXT method cannot be used with a nested table from which an element has been deleted. 

Answer:


Improve 1Z0-146 test questions:

Q26. Examine the settings for a user session given below: 

RESULT_CACHE_MODE= FORCE 

What would be the implications of this setting on query execution? (Choose all that apply.) 

A. All query results are stored in the result cache if possible. 

B. Query results that are bigger than the available space in the result cache are not cached. 

C. Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query. 

D. Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in your query. 

Answer: A,B 


Q27. Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.) 

A. It can be performed only on tables with a single LOB column. 

B. It automatically creates an interim table during the migration process. 

C. It allows the table that is migrated to be accessed throughout the migration process. 

D. It requires free space that is at least equal to the space used by the table that is migrated. 

E. It requires all constraints defined on the original table to be re-created manually after the migration. 

Answer: C,D 


Q28. The database instance was started up using the automatic memory management feature. No value was set for the RESULT_CACHE_MAX_SIZE parameter. 

Examine the following initialization parameter settings for your database: 

MEMORY_TARGET = 500M 

RESULT_CACHE_MODE = MANUAL 

You execute a query by using the result_cache hint. Which statement is true in this scenario? 

A. The query results are not stored because no memory is allocated for the result cache. 

B. The query results are stored and 0.5% of the memory target is allocated to the result cache. 

C. The query results are stored and 0.25% of the memory target is allocated to the result cache. 

D. The query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE. 

Answer:


Q29. Examine the structure of the TEST_DETAILS table: Name Null? Type 

TEST_ID NUMBER 

DESCRIPTION CLOB 

DESCRIPTION data was entered earlier and saved for TEST_ID 12. 

You execute this PL/SQL block to add data to the end of the existing data in the DESCRIPTION column for TEST_ID 12: 

DECLARE 

clob_loc CLOB; 

buf CHAR(12); 

BEGIN 

SELECT description INTO clob_loc FROM test_details WHERE test_id = 12 ; 

buf := '0123456789' 

DBMS_LOB.WRITEAPPEND(clob_loc,DBMS_LOB.GETLENGTH(buf), buf); 

COMMIT; 

END; 

It generates an error on execution. 

What correction should you do to achieve the required result? 

A. WRITEAPPEND must be replaced with APPEND. 

B. The BUF variable data type must be changed to CLOB. C. FOR UPDATE must be added to the SELECT statement. 

D. The GETLENGTH routine must be replaced with the LENGTH built-in function in WRITEAPPEND. 

Answer:


Q30. Identify three guidelines for the DBMS_ASSERT package. (Choose three.) 

A. Prefix all calls to DBMS_ASSERT with the SYS schema name. 

B. Embed DBMS_ASSERT verification routines inside the injectable string. 

C. Escape single quotes when you use the ENQUOTE_LITERAL procedure. 

D. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions. 

E. Prefix all calls to DBMS_ASSERT with a schema name that owns the subprogram that uses the DBMS_ASSERT package. 

Answer: A,C,D