Download Oracle.1z0-148.Pass4Sure.2019-05-30.47q.tqb

Download Exam

File Info

Exam Oracle Database 12c: Advanced PL/SQL
Number 1z0-148
File Name Oracle.1z0-148.Pass4Sure.2019-05-30.47q.tqb
Size 2 MB
Posted May 30, 2019
Download Oracle.1z0-148.Pass4Sure.2019-05-30.47q.tqb

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

Which two blocks of code execute successfully?


  1. DECLARE 
    SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9; 
    my_val new_one; 
    BEGIN 
    my_val :=0;
    END;
  2. DECLARE 
    SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; 
    my_str_new_string; 
    BEGIN 
    my_str  := ‘abc’;
    END;
  3. DECLARE 
    SUBTYPE new_one IS NUMBER (2, 1); 
    my_val new_one; 
    BEGIN 
    my_val :=12.5;
    END;
  4. DECLARE 
    SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL; 
    my_val new_one; 
    BEGIN 
    my_val :=2;
    END;
  5. DECLARE 
    SUBTYPE new_one IS NUMBER (1, 0); 
    my_val new_one; 
    BEGIN 
    my_val := -1;
    END;
Correct answer: AD



Question 2

Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles?


  1. DBMS_LOB.GETOPTIONS can only be used for BLOB data types.
  2. DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.
  3. DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
  4. If a table was not created with compression specified in the store as securefile clause then DBMS_LOB.SETOPTIONS can be used to enable it later.
Correct answer: D
Explanation:
Reference: https://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm
Reference: https://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm



Question 3

Examine this code executed as SYS:
  
Examine this code executed as SPIDER and the error message received upon execution:
  
What is the reason for this error?


  1. The procedure needs to be granted the DYNAMIC_TABLE_ROLE role.
  2. The EXECUTE IMMEDIATE clause is not supported with roles.
  3. Privileges granted through roles are never in effect when running definer’s rights procedures.
  4. The user SPIDER needs to be granted the CREATE TABLE privilege and the procedure needs to be granted the DYNAMIC_TABLE_ROLE.
Correct answer: C









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files