10 Tips For Up to the immediate present 1Z0-146 exam dumps

Q1. You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which scenarios is the cached result bypassed? (Choose all that apply.) 

A. when the size for the memory allocated for the result cache is increased 

B. when the function is executed in a session frequently with the same parameter value 

C. when the database administrator has disabled the use of the result cache during application patching 

D. when a data manipulation language (DML) statement is executed in a session on a table or view that was specified in the RELIES_ON clause of a result-cached function 

View Answer

Q2. Which two statements are true about nested tables and varrays? (Choose two.) 

A. Only varrays must have consecutive numbers as subscripts. 

B. Only nested tables can be used as column types in database tables. 

C. Both nested tables and varrays must have consecutive numbers as subscripts. 

D. Both nested tables and varrays can be used as column types in database tables. 

View Answer

Q3. View Exhibit1 and examine the structure of the EMPLOYEES table. 

itexamworld.com 

View Exhibit2 and examine the code in the PL/SQL block. 

The PL/SQL block fails to execute. What could be the reason? 

A. Nested tables cannot be returned by a function. 

B. The NEWNAMES nested table has not been initialized. 

C. The assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2. 

D. The third element of OLDNAMES cannot be assigned to the third element of GROUP1 because they are of inconsistent data types. 

E. LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection types are not allowed in SQL statements. 

View Answer

Q4. Which two are major approaches that can be used to reduce the SQL injection by limiting user input? (Choose two.) 

A. Restrict users accessing specified web page. 

B. Use NUMBER data type if only positive integers are needed. 

C. Use dynamic SQL and construct it through concatenation of input values. 

D. In PL/SQL API, expose only those routines that are intended for customer use. 

View Answer

Q5. Examine the following parameter values for a session: 

PLSQL_CODE_TYPE = NATIVE 

PLSQL_OPTIMIZE_LEVEL = 2 

Which two statements are true in this scenario? (Choose two.) 

A. The compiler automatically inlines subprograms even if you specify that they not be inlined. 

B. The compiler optimizes PL/SQL programs by elimination of unnecessary computations and exceptions. 

C. PL/SQL statements in a PL/SQL program unit are compiled into machine-readable code, and stored in the SYSTEM tablespace. 

D. PL/SQL statements in a PL/SQL program unit are compiled into an intermediate form, machine-readable code, which is stored in the database dictionary. 

View Answer

Q6. DATA_FILES is a directory object that contains the DETAILS.TXT text file. 

You have the required permissions to access the directory object. 

You create a table using the following command: 

CREATE TABLE clob_tab(col2 CLOB); 

View the Exhibit and examine the PL/SQL block that you execute for loading the external text file into the table that currently has no rows. The PL/SQL block results in an error. 

What correction must be done to ensure the PL/SQL block executes successfully? 

A. The L_OUT variable must be initialized to an empty locator. 

B. The L_OUT variable has to be declared as a temporary LOB. C. The A_CLOB variable has to be declared as a temporary LOB. 

D. The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly initialize the locator. 

View Answer

Q7. 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. 

View Answer

Q8. 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. 

View Answer

Q9. Which two statements are true about the initialization of internal LOBs? (Choose two.) 

A. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs. 

B. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only non-NULL internal LOBs. 

C. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-NULL internal LOBs. 

D. The CLOB and BLOB columns can be initialized only by using the EMPTY_CLOB() and EMPTY_BLOB() functions, respectively. 

E. The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size. 

View Answer

Q10. You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario? 

A. The corresponding shared library is also removed from the system. 

B. PL/SQL subprograms can be used to invoke the external C procedure. 

C. The existing extproc process is terminated and a new extproc is started. 

D. The PL/SQL subprogram that depends on the external C program becomes invalid. 

View Answer