Online Access Free 1Z0-146 Practice Test

Examine the code in the following PL/SQL block:
DECLARE
TYPE NumList IS TABLE OF INTEGER;
List1 NumList := NumList(11,22,33,44);
BEGIN
List1.DELETE(2);
DBMS_OUTPUT.PUT_LINE
( 'The last element# in List1 is ' || List1.LAST ||
' and total of elements is '||List1.COUNT);
List1.EXTEND(4,3);
END;
/
Which two statements are true about the above code? (Choose two.)

• A.LAST and COUNT give different values.
• B.The four new elements that are added contain the value 33.
• C.The four new elements that are added contain the value 44.
• D.LAST and COUNT give the same values.

Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)

• A.Only local subroutines can be inlined.
• B.PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.
• C.Inlining always reduces the execution time for a PL/SQL program unit.
• D.The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining.

Which statements are true about temporary LOBs? (Choose all that apply.)

• A.They are stored temporarily in the default tablespace of the user who creates them.
• B.They exist for the duration of the session in which they are created.
• C.They generate more redo information than persistent LOBs.
• D.They can be accessed only by the user who creates them.
• E.They can be created only for CLOB and NCLOB data.

To examine the dependencies between all PL/SQL objects and the tables and views they
reference, you executed the following query as the user OE:
SQL> SELECT owner || '.' || NAME refs_table
, referenced_owner || '.' || referenced_name AS table_referenced
FROM all_dependencies
WHERE owner = USER
AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION')
AND referenced_type IN ('TABLE', 'VIEW')
AND referenced_owner NOT IN ('SYS', 'SYSTEM')
ORDER BY owner, NAME, referenced_owner, referenced_name;
Which statement is true about the output of the query?

• A.It displays all PL/SQL code objects created by user OE that reference any table or view owned by other users except SYS and SYSTEM..
• B.It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.
• C.It displays no rows because this query needs to be executed as the user SYS for required results.
• D.It displays only those PL/SQL code objects created by the user OE that reference a table or view created by the user SYS.

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

• A.Enclose string literals within double quotation marks.
• B.Verify an existing schema name.
• C.Detect a wrong user.
• D.Verify qualified SQL names.
• E.Check input string length.
• F.Validate TNS connect strings.