AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-146





Question ID 2793

Examine the following error:
SQL> DECLARE v_runid NUMBER; BEGIN
 
v_runid := DBMS_
 
HPROF.ANALYZE (LOCATION => 'PROFILE_DATA',
 
FILENAME => 'pd_cc_pkg.txt');
DBMS_OUTPUT.PUT_LINE('Run ID: ' || v_runid);
END;
DECLARE
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_HPROF", line 299
ORA-06512: at line 4
What would you do to execute the above block successfully?
 

Option A

A.    Start the PL/SQL profiler before executing the block.
 

Option B

B.    Run the tracetab.sql script located at ORACLE_HOME\RDBMS\ADMIN.
 

Option C

C.    Run the dbmshptab.sql script located at ORACLE_HOME\RDBMS\ADMIN.
 
 

Option D

D. Grant READ and WRITE privileges to the current user on the PROFILE_DATA directory object.
 

Correct Answer C
Explanation


Question ID 2794

Which two statements are true about SecureFile LOB options? (Choose two.)
 

Option A

A.    The DECRYPT option can be used to remove the encryption only if the LOB column is empty.
 

Option B

B.    The KEEP_DUPLICATES option removes the deduplication effect only on new data in a LOB

column.
 

Option C

C.    The KEEP _    DUPLICATES option removes the deduplication effect on existing and new data ina LOB column.
 

Option D

D.    The DECRYPT option can be used to remove the encryption from LOB columns that are empty or contain data.
 

Correct Answer C,D
Explanation

Send email to admin@getfreedumps for new dumps request!!!