1z0-074 Free Practice Test

TheTESTDBcontainer database (CDB) contains two pluggable databases (PDBs),PDB1andPDB2. USER1is a local user inPDB1and has theSYSBACKUPprivilege.
Connect descriptors for PDB1 and PDB2 are mapped to TNS aliasespdb1andPDB2intnsnames.ora. Examine these commands executed by USER1 when all PDBs are open:
<>

1. A. An error is returned because the user is connected to a pluggable database.
2. B. The current date is displayed.
3. C. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax:SQL””.
4. D. An error is returned because the user is notSYS.
5. E. An error is returned because the user is not a common user.

Correct Answer: C

The TESTDB container database (CDB) running inARCHIVELOGmode contains two pluggable databases (PDBs)PDB1andPDB2.
A connect descriptor forTESTDBis mapped to the TNS aliastestdb in tnsnames.ora. The defaultRMANconfiguration is used.
Examine these commands:
<>

1. A. all root andPDB1data files, and theCONTROLFILE, SPFILE, andFLASHBACKLOGS
2. B. all root andPDB1data files, and theCONTROLFILE, SPFILE, andARCHIVELOGS
3. C. all root andPDB1data files, and theCONTROLFILEandSPFILE
4. D. all root andPDB1data files, and theCONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and ARCHIVELOGS
5. E. all root andPDB1data files

Correct Answer: E

You want to partition theSALEStable on theCITYandSALE_DATEcolumns. Which three partitioning methods can you use? (Choose three.)

1. A. range
2. B. interval
3. C. hash
4. D. list
5. E. virtual column-based

Correct Answer: ACD

Identify four prerequisites for issuing theRMAN RECOVER TABLEcommand starting from ORACLE Database 12c Release 2.

1. A. TheCOMPATIBLEparameter must be set to 12.0 or greater.
2. B. The database must be inARCHIVELOGmode.
3. C. FLASHBACK DATABASEmust be enabled.
4. D. RMANmust use a recovery catalog.
5. E. The database must be in theREAD WRITEstate.
6. F. RMANcan recover the table only from a backupset.
7. G. An export dump file of the table must be available.
8. H. There must be sufficient space to start the auxiliary instance.

Correct Answer: ABEF

In a Database Cloud Service (DBCS) environment, which pre-created user hassudoprivileges to run certainrootcommands?

1. A. grid
2. B. oracle
3. C. opc
4. D. nobody
5. E. oinstall

Correct Answer: C