Category: Oracle >> 1z0-148
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.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...
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...
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...
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...
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...
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...
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...