The Up to date Guide To 1Z0-146 vce

Q1. Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.) 

A. Detect a wrong user. 

B. Check input string length. 

C. Verify qualified SQL names. D. Validate TNS connect strings. 

E. Verify an existing schema name. 

F. Enclose string literals within double quotation marks. 

View Answer

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

View Answer

Q3. Examine the structure of the TEXT_TAB table. Name Null? Type 

TEXT_ID NUMBER 

DOC1 CLOB 

DOC2 CLOB 

You issue the following INSERT commands: 

INSERT INTO text_tab VALUES (1, 'This is line 1',null); 

INSERT INTO text_tab VALUES (2, 'This is line 1','This is line 2'); 

Then you execute the following block of the PL/SQL code: 

DECLARE 

vc1 VARCHAR2(1000):= 'This is the preface' 

lb1 CLOB; 

lb2 CLOB; 

BEGIN 

SELECT doc1 INTO lb1 FROM text_tab WHERE text_id=1; 

SELECT doc1 || doc2 INTO lb1 FROM text_tab WHERE text_id=2; 

lb2 := vc1|| lb1; 

UPDATE text_tab SET doc2 = lb2 WHERE text_id = 1; 

END; 

/ 

What is the outcome? 

A. It executes successfully. 

B. It gives an error because VARCHAR2 should be explicitly converted to CLOB. 

C. It gives an error because CLOB variables should be initialized to EMPTY_CLOB(). 

D. It gives an error because the concatenation operator cannot be used with the CLOB data type. 

View Answer

Q4. You created the SALES_ORDERS_CTX context to use the 

OE.SALES_ORDERS_PKG package. 

View Exhibit1 and examine the package that is used with the context. 

View Exhibit2 to examine the policy defined and the logon trigger. 

A user receives the following error when he or she executes a query: 

ERROR at line 2: 

ORA-28112: failed to execute policy function 

What could be the reason for the error? 

A. The user has insufficient privileges on the DBMS_SESSION package. 

B. The subprograms inside the package have not been created with the invoker's right. 

C. The THE_PREDICATE function has an insufficient number of parameters in the package. 

D. The policy is created by using SALES_ORDERS_PKG.THE_PREDICATE without a parameter. 

View Answer

Q5. In a user session, tracing is enabled as follows: SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_LINES); PL/SQL procedure successfully completed. 

You executed the procedure as follows: 

SQL> EXECUTE PROC10 

PL/SQL procedure successfully completed. 

When you examine the PLSQL_TRACE_EVENTS table, you find that no trace information was written into it. 

View the Exhibit. 

What is the reason for this? 

A. The PROC10 procedure is created with the invoker's right. 

B. The PROC10 procedure is not compiled with the DEBUG option. 

C. Tracing is not enabled with the TRACE_ENABLED_CALLS option. 

D. The TRACE_ENABLED parameter is set to FALSE for the session. 

View Answer

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

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

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

View Answer

Q9. Which two statements correctly describe the features of SecureFiles? (Choose two.) 

A. Compression is performed only on the server side and enables random reads and writes to LOB data. 

B. Deduplication stores identical data, which occurs in a LOB column in each row, as a single copy within the LOB. 

C. Compression can be performed on the client side and it enables random and sequential reads and writes to LOB data. 

D. Deduplication stores identical data occurring two or more times in the same LOB column as a single copy for the table. 

View Answer

Q10. The result cache is enabled for the database instance. 

Examine the following code for a PL/SQL function: 

CREATE OR REPLACE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR 

RESULT_CACHE RELIES_ON (HR.EMPLOYEES) 

IS 

date_hired DATE; 

BEGIN 

SELECT hire_date INTO date_hired 

FROM HR.EMPLOYEES 

WHERE EMPLOYEE_ID = emp_id; 

RETURN TO_CHAR(date_hired); 

END; 

Which statement is true in this scenario? 

A. If sessions have different NLS_DATE_FORMAT settings, cached results have different formats. 

B. The function results are not cached because the query used in the function returns the DATE data type. 

C. If sessions have different NLS_DATE_FORMAT settings, cached results have same formats because the function's return type is VARCHAR. 

D. If a function is executed with same argument value but different NLS_DATE_FORMAT for the session, the cached result is overwritten with the new function result. 

View Answer