Download Oracle.1z0-148.ActualTests.2018-10-06.47q.vcex

Download Exam

File Info

Exam Oracle Database 12c: Advanced PL/SQL
Number 1z0-148
File Name Oracle.1z0-148.ActualTests.2018-10-06.47q.vcex
Size 2 MB
Posted Oct 06, 2018
Download Oracle.1z0-148.ActualTests.2018-10-06.47q.vcex

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

You are designing and developing a complex database application built using many dynamic SQL statements. Which option could expose your code to SQL injection attacks? 


  1. Using bind variables instead of directly concatenating parameters into dynamic SQL statements
  2. Using automated tools to generate code
  3. Not validating parameters which are concatenated into dynamic SQL statements
  4. Validating parameters before concatenating them into dynamic SQL statements
  5. Having excess database privileges
Correct answer: A
Explanation:
Reference: https://docs.oracle.com/database/121/LNPLS/dynamic.htm#LNPLS645
Reference: https://docs.oracle.com/database/121/LNPLS/dynamic.htm#LNPLS645



Question 2

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



Question 3

Which codes executes successfully? 


  1. CREATE PACKAGE pkg AS 
    TYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER); 
    PROCEDURE calc_price (price_rec IN OUT rec_typ); 
    END pkg; 
    / 
    CREATE PACAKGE BODY pkg AS 
    PROCEDURE calc_price (price_rec IN OUT rec_typ) AS 
    BEGIN 
    price_rec.price  := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;
    END calc_price; 
    END pkg; 
    / 
    DECLARE 
    1_rec pkg. rec_typ; 
    BEGIN 
    1_rec_price :=100;
    1_rec.inc_pct :=50;
    EXECUTE IMMEDIATE ‘BEGIN pkg. calc_price (:rec); END;’ USING IN OUT 1_rec;
    END;
  2. CREATE PACKAGE pkg AS 
    TYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER); 
    END pkg; 
    / 
    CREATE PROCEDURE calc_price (price_rec IN OUT pkg. rec_typ) AS 
    BEGIN 
    price_rec.price  := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;
    END 
    / 
    DECLARE 
    1_rec pkg.rec_typ; 
    BEGIN 
    EXECUTE IMMEDIATE ‘BEGIN calc_price (:rec); END;’ USING IN OUT 1_rec (100, 50);
    END;
  3. CREATE PACKAGE pkg AS 
    TYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER); 
    END pkg; 
    / 
    CREATE PROCEDURE calc_price (price_rec IN OUT pkg. rec_typ) AS 
    BEGIN 
    price_rec.price  := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;
    END ; 
    / 
    DECLARE 
    1_rec pkg. rec_typ; 
    BEGIN 
    1_rec_price :=100;
    1_rec.inc_pct :=50;
    EXECUTE IMMEDIATE ‘BEGIN calc_price (1_rec); END;’; 
    END;
  4. DECLARE 
    TYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER); 
    1_rec rec-typ; 
    PROCEDURE calc_price (price_rec IN OUT rec_typ) AS 
    BEGIN 
    price_rec.price := price-rec.price+ (price_rec.price * price_rec.inc_pct)/100;
    END; 
    BEGIN 
    1_rec_price :=100;
    1_rec.inc_pct :=50;
    EXECUTE IMMEDIATE ‘BEGIN calc_price (:rec); END;’ USING IN OUT 1_rec;
    END;
Correct answer: B



Question 4

Examine this function header:
FUNCTION calc_new_sal (emp_id NUMBER) RETURN NUMBER; 
You want to ensure that whenever this PL/SQL function is invoked with the same parameter value across active sessions, the result is not recomputed. 
If a DML statement is modifying a table which this function depends upon, the function result must be recomputed at that point in time for all sessions calling this function. 
Which two actions should you perform?


  1. Ensure RESULT_CACHE_MAX_SIZE is greater than 0. 
  2. Enable the result cache by using DBMS_RESULT_CACHE.BYPASS (FALSE).
  3. Add the deterministic clause to the function definition.
  4. Add the RELIES_ON clause to the function definition.
  5. Add the RESULT_CACHE clause to the function definition.
Correct answer: AC



Question 5

Examine this block:
  
Which two will be correct after line 5?


  1. va. LAST and va. LIMIT will return the same value.
  2. va. LAST and va. COUNT will return the same value.
  3. va. LIMIT and va. COUNT will return the same value.
  4. va. LIMIT and va. NEXT (199) will return the same value.
  5. va. LAST will return 200.
  6. va. NEXT (199) will return NULL.
Correct answer: AC
Explanation:



Question 6

  
Examine this code:
  
You want to display the contents of CREATE_LIST. 
Which two lines need to be corrected in the PL/SQL block?


  1. Line 2
  2. Line 3
  3. Line 5
  4. Line 6
  5. Line 7
Correct answer: BD



Question 7

Examine the following SQL statement:
ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3; 
What is the result of executing this statements? 


  1. The PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result.
  2. The PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled.
  3. The PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled.
  4. This statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level,
Correct answer: C



Question 8

Which two statements describe actions developers can take to make their application less vulnerable to security attacks?


  1. Include the AUTHID DEFINER clause in stored program units.
  2. Do not concatenate unchecked user input into dynamically constructed SQL statements.
  3. Switch from using DBMS_SQL to EXECUTE IMMEDIATE.
  4. Include the AUTHID CURRENT_USER clause in stored program units.
  5. Increase the amount of code that is accessible to users by default.
Correct answer: BD



Question 9

Examine this code:
  
What is the correct statement to get the value of attribute ACCOUNT_MGR after the procedure has been executed?


  1. SELECT USERENV (‘ACCOUNT_MGR’) FROM dual;
  2. SELECT SYS_CONTEXT (‘USERENV’, ‘ACCOUNT_MGR’) FROM dual;
  3. SELECT SYS_CONTEXT (‘ORDER_CTX’, ‘ACCOUNT_MGR’) FROM dual;
  4. SELECT SYS_CONTEXT (‘ACCOUNT_MGR’, ‘ORDER_CTX’) FROM dual;
  5. SELECT USERENV (‘ORDER_CTX’) FROM dual;
Correct answer: B
Explanation:



Question 10

Identify the two correct scenarios where a function can be optimized using the function result cache feature.


  1. A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.
  2. A function which accesses multiple tables and calculates the commission to be given to a sales representative based on the number of products sold by that representative.
  3. A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE.
  4. A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.
  5. A function which calculates the factorial of a given number without accessing any table.
Correct answer: DE









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