1z0-148 무료 덤프문제 온라인 액세스

Which two blocks of code execute successfully?

• A.DECLARE
  SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL; my_val new_one; BEGIN my_val :=2; END;
• B.DECLARE
  SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; my_str_new_string; BEGIN my_str := 'abc'; END;
• C.DECLARE
  SUBTYPE new_one IS NUMBER (2, 1); my_val new_one; BEGIN my_val :=12.5; END;
• D.DECLARE
  SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9; my_val new_one; BEGIN my_val :=0; END;
• E.DECLARE
  SUBTYPE new_one IS NUMBER (1, 0); my_val new_one; BEGIN my_val := -1;
  END;

Which two statements are true about PL/SQL AOIs for SecureFiles?

• A.If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, an exception will be raised.
• B.An online redefinition of SecureFiles by DBMS_REDEFINIITON can be performed with PDML (Parallel DML).
• C.When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified.
• D.DBMS_LOB can be used to compress SecureFiles columns.

The user MY_USER has been assigned the roles CONNECT, RESOURCE, and DBA.
Which statement generates the DDL for these privileges?

• A.SELECT DBMS_METADATA.GET_GRANTED_DDL ('OBJECT_GRANT', 'my_user') FROM dual;
• B.SELECT DBMS_METADATA.GET_GRANTED_DDL ('ROLE_GRANT', 'my_user') FROM dual;
• C.SELECT DBMS_METADATA.GET_DDL ('USER', 'my_user') FROM dual;
• D.SELECT DBMS_METADATA.GET_GRANTED_DDL ('SYSTEM_GRANT', 'my_user') FROM dual;

For which type of PL/SQL program units is PL/Scope unable to collect data?

• A.wrapped PL/SQL program units
• B.triggers
• C.user-created PL/SQL program units
• D.package DBMS_STANDARD
• E.package STANDARD

Examine this code (all compiled into schema HR):

Execute this code:
SET SERVEROUTPUT ON;
EXEC test_pkg.do_stuff
What is the correct output?

• A.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 TEST_PKG.DO_STUFF2 4 TEST_PKG.DO_STUFF.NP12 3
  TEST_PKG.DO_STUFF.NP1.NP22 2 TEST_PKG.DO_STUFF.NP1.NP2.NP30 1
  FORMAT_CALL_STACK_12C
• B.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 DO_STUFF2 4 NP13 3 NP24 2 NP30 1 FORMAT_CALL_STACK_12C
• C.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 package body HR.TEST_PKG2 4 package body HR.TEST_PKG2 3 package body HR.TEST_PKG2 2 package body HR.TEST_PKG0 1 procedure HR.
  FORMAT_CALL_STACK_12C
• D.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 package body HR.TEST_PKG2 4 package body HR.TEST_PKG3 3 package body HR.TEST_PKG4 2 package body HR.TEST_PKG0 1 procedure HR.
  FORMAT_CALL_STACK_12C
• E.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 TEST_PKG.DO_STUFF2 4 TEST_PKG.DO_STUFF.NP13 3
  TEST_PKG.DO_STUFF.NP1.NP24 2 TEST_PKG.DO_STUFF.NP1.NP2.NP30 1
  FORMAT_CALL_STACK_12C