READ Free Dumps For Oracle- 1z0-060
| Question ID 2169 | Examine the contents of SQL loader 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 |
| Question ID 2170 | 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: |
| 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 |