10 Tips For Far out 1Z0-146 vce

Q1. Which statements are true about the SecureFile storage paradigm? (Choose two.) 

A. SecureFile storage can be used for internal and external LOBs. 

B. Automatic Segment Space Management must be enabled for a tablespace to store SecureFile LOBs. 

C. SecureFile options enabled for a LOB column can be overridden on a per-LOB basis within the column. 

D. SecureFile is the default storage paradigm for all LOBs that are stored in locally managed tablespaces if the DB_SECUREFILE parameter is set to ALWAYS. 

View Answer

Q2. Identify two strategies against SQL injection. (Choose two.) 

A. Using parameterized queries with bind arguments. 

B. Use subprograms that are run with the definer's right. 

C. Use RESTRICT_REFERENCE clauses in functions that use dynamic SQLs. 

D. Validate user inputs to functions that use dynamic SQLs built with concatenated values. 

View Answer

Q3. Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.) 

A. DDL report for all objects dependent on a table 

B. DDL report for all the objects stored in a tablespace 

C. DDL report for all the invalidated objects in a schema 

D. data definition language (DDL) report for all the tables in a schema 

View Answer

Q4. View the Exhibit and examine the PL/SQL code. 

Which statement is true about the execution of the PL/SQL code? 

A. It executes successfully and displays 101 and 200000 values. 

B. The ASSIGN_VAL function generates an error during compilation because nested tables cannot be returned by functions. 

C. The SELECT statement generates an error because the nested table has not been initialized in the ASSIGN_VAL function. 

D. The ASSIGN_VAL function generates an error during compilation because the EXTEND method cannot be used with nested tables. 

View Answer

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

View Answer

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

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

Q8. Examine the section of code taken from a PL/SQL program: 

PROCEDURE p1 (x PLS_INTEGER) IS 

PRAGMA INLINE (p1, 'NO'); 

x:= p1(1) + p1(2) + 17; -- Call 1 

x:= p1(3) + p1(4) + 17; -- Call 2 

Call 1 and Call 2 are the comments for distinguishing the code. The PLSQL_OPTIMIZE_LEVEL parameter is set to 3. Which two statements are true in this scenario? (Choose two.) 

A. The calls to the P1 procedure are not inlined in the section commented as Call 1. B. The calls to the P1 procedure might be inlined in the section commented as Call 2. 

C. The calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2. 

D. The calls to the P1 procedure are never inlined in both the sections commented as Call 1 and Call 2. 

View Answer

Q9. Which statement describes the purpose of the plshprof command? 

A. It produces HTML output from raw profiler output. 

B. It produces HTML output from profiler tables in the database. 

C. It populates profiler tables in the database from raw profiler output. 

D. It produces raw profiler output on the most recently run applications. 

View Answer

Q10. Examine the code snippet from the declarative section of a PL/SQL block: 

DECLARE 

TYPE va1 IS VARRAY(10) OF VARCHAR2(20); 

SUBTYPE scale IS NUMBER(1,0); 

TYPE tb1 IS TABLE OF departments.department_name%TYPE INDEX BY 

departments.department_id%TYPE; 

TYPE tb2 IS TABLE OF va1 INDEX BY PLS_INTEGER; 

TYPE tb3 IS TABLE OF scale INDEX BY VARCHAR2(10);  

TYPE tb4 IS TABLE OF DATE INDEX BY DATE; 

TYPE tb5 IS TABLE OF NUMBER INDEX BY CHAR(2); 

Which of the above are valid definitions for associative arrays? (Choose all that apply.) 

A. tb1 

B. tb2 

C. tb3 

D. tb4 

E. tb5 

View Answer