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 2771

You issue this command to create a table called LOB_STORE:

CREATE TABLE lob
_    store

(lob_id NUMBER(3),
photo BLOB DEFAULT EMPTY_BLOB(),
cv CLOB DEFAULT NULL,
ext_file BFILE DEFAULT NULL)
/
What is the outcome?
 

Option A

A.    The table is created successfully.
 

Option B

B.    It generates an error because DEFAULT cannot be set to EMPTY_BLOB() during table creation.
 

Option C

C.    It generates an error because DEFAULT cannot be set to null for a CLOB column during table creation.
 

Option D

D.    It generates an error because DEFAULT cannot be set to null for a BFILE column during table creation.
 

Correct Answer A
Explanation


Question ID 2772

Which two statements are true about REF CURSOR types? (Choose two.)
 

Option A

A.    REF CURSOR types cannot be defined inside a package.
 

Option B

B.    SYS_REFCURSOR can be used to declare cursor variables in stored procedures and functions.
 

Option C

C.    A REF CURSOR return type can be declared using %TYPE, or %ROWTYPE, or a userdefined record.
 

Option D

D.    Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function.
 

Correct Answer B,C
Explanation

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