Category: Oracle >> 1z0-148

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

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

Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles?Reference: https://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm Question: Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles? Options: DBMS_LOB.GETOPTIONS can only be used for BLOB data types. DBMS_LOSETOPTIONS can...

Select the correct statement regarding BEQUEATH CURRENT_USER. 0

Select the correct statement regarding BEQUEATH CURRENT_USER.

Select the correct statement regarding BEQUEATH CURRENT_USER.Reference: https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG558 Question: Select the correct statement regarding BEQUEATH CURRENT_USER. Options: If a view references a PL/SQL function then BEQUEATH CURRENT_USER allows the function to execute with DBA...

Select a valid reason for using VARRAYS. 0

Select a valid reason for using VARRAYS.

Select a valid reason for using VARRAYS.Reference https://www.go4expert.com/articles/oracle-nested-tables-varrays-t20494/ Question: Select a valid reason for using VARRAYS. Options: When the amount of data to be held in the collection is widely variable. As a column...

Which codes executes successfully? 0

Which codes executes successfully?

Which codes executes successfully?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 ASPROCEDURE calc_price (price_rec IN OUT rec_typ) ASBEGIN price_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;END...