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 perform operations on individual SecureFiles but not an entire column. DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT. If … Read more

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 privileges, regardless of the invoking user’s privileges. The BEQUEATH CURRENT_USER clause allows invoker’s rights functions referenced in a view to execute … Read more

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

Which two statements are true about PL/SQL AOIs for SecureFiles? Question: Which two statements are true about PL/SQL AOIs for SecureFiles? Options: DBMS_LOB can be used to compress SecureFiles columns. When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified. If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, … Read more

Which two blocks of code will give the required output?

In your schema, the DEPARTMENTS table contains the columns DEPARTMENT_ID and DEPARTMENT_NAME.You want to display the department name for existing department id 10.With SERVEROUTPUT enabled, which two blocks of code will give the required output?TYPE dept_cur IS REF CURSOR; cv1 dept_cur; v_dept_name departments. department_name%TYPE;BEGINOPEN cv1 FOR SELECT department_name FROM departments WHERE department_id=10;IF cv1 IS NOT … Read more

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 in a table when you want to retrieve the collection data for certain rows by ranges of values. When you want … Read more

What is the result of executing this statements?

Examine the following SQL statement: ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;What is the result of executing this statements? Question: What is the result of executing this statements? Options: The PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result. The PL/SQL optimize level for subsequently complied PL/SQL units will be set to … Read more

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 calc_price;END pkg;/DECLARE1_rec pkg. rec_typ;BEGIN1_rec_price :=100;1_rec.inc_pct :=50;EXECUTE IMMEDIATE ‘BEGIN pkg. calc_price (:rec); END;’ USING IN OUT 1_rec; END;TYPE rec_typ IS RECORD (price … Read more

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?Reference: https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/subprograms.htm#insertedID11 Question: Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully? Options: The IN parameters must not include BLOB, CLOB, collection or record data types. The function must … Read more