READ Free Dumps For Oracle- 1z0-067
Question ID 22087 | Which two statements are true about dropping a pluggable database (PDB)? |
Option A | A PDB must be in mount state or it must be unplugged. |
Option B | The data files associated with a PDB are automatically removed from disk. |
Option C | A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs. |
Option D | A PDB must be in closed state. |
Option E | The backups associated with a PDB are removed. |
Option F | A PDB must have been opened at least once after creation. |
Correct Answer | A,D |
Question ID 22088 | On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command: |
Option A | It succeeds with default settings if the employees table exists in the hr schema. |
Option B | It fails because no SQL*Loader data file location is specified. |
Option C | It fails if the hr user does not have the create any directory privilege. |
Option D | It fails because no SQL*Loader control file location is specified. |
Option E | It succeeds and creates the employees table in the HR schema. |
Correct Answer | A,C |