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 2817

Which statements are true about the SecureFile storage paradigm? (Choose two.)
 

Option A

A.    SecureFile storage can be used for internal and external LOBs.
 

Option B

B.    Automatic Segment Space Management must be enabled for a tablespace to store SecureFile LOBs.
 

Option C

C.    SecureFile options enabled for a LOB column can be overridden on a per-LOB basis within the column.
 

Option D

D.    SecureFile is the default storage paradigm for all LOBs that are stored in locally managed tablespaces if the DB_SECUREFILE parameter is set to ALWAYS.
 

Correct Answer B,C
Explanation


Question ID 2818

You created an application context successfully. The user OE was granted the EXECUTE privilege on the DBMS_SESSION package. The user receives this error while setting the value for an attribute within the context:
SQL> EXECUTE
DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE');
BEGIN DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); END;
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 94
 
ORA-06512: at line 1
What is the reason for this error?
 

Option A

A.    The context was created with a package name in the USING clause.
 

Option B

B.    The attribute can be set only in the package associated with the context.
 

Option C

C.    The package associated with the context did not exist at the time of creation of the context.
 

Option D

D.    The value for an attribute of a user-defined context can be set only by the ALTER SESSION command.
 

Correct Answer B
Explanation

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