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-062





Question ID 2400

Examine the contents of SQL loader control file:

 
Which three statements are true regarding the SQL* Loader operation performed using the control file?
 

Option A

A.    An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
 

Option B

B.    The SQL* Loader data file myfile1.dat has the column names for the EMP table.
 

Option C

C.    The SQL* Loader operation fails because no record terminators are specified.
 

Option D

D.    Field names should be the first line in the both the SQL* Loader data files.
 

Option E

E.    The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

Correct Answer A,B,E
Explanation


Question ID 2401

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN; What is the result?
 

Option A

A.    It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
 

Option B

B.    It fails and reports an error because the CONTAINER=ALL clause is not used.
 

Option C

C.    It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
 

Option D

D.    It fails and reports an error because the CONTAINER=CURRENT clause is not used.

 

Option E

E.    It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Correct Answer A
Explanation

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