1z0-074 Free Practice Test

In your database,DEFERRED_SEGMENT_CREATIONis set toTRUE. You successfully execute this command:
<>

1. A. Two subpartitions are allocated to theq1_2016partition when the first row is inserted intoq1_2016.
2. B. A single subpartition is allocated to theq1_2016partition when the first row is inserted intoq1_2016.
3. C. Separate segments are allocated to theq1_2016partition and each of its subpartitions when the first row is inserted intoq1_2016.
4. D. A segment is allocated to theq1_2016partition but not its subpartitions at table creation.
5. E. A single segment is allocated to theq1_2016partition and its subpartitions at table creation.

Correct Answer: A

Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?

1. A. Oracle Loader-type external tables
2. B. remote cloning
3. C. RMAN Transportable Tablespace with Data Pump for all tablespaces
4. D. Data Pump Transportable Tablespace for all tablespaces
5. E. Data Pump Conventional Export/Import

Correct Answer: C

Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

1. A. expdpscripts to export database objects belonging to the SYS schema
2. B. a log file containing a list of pre-upgrade patches to be applied
3. C. RMANdatabase backup scripts
4. D. a log file with tool recommendations and requirements
5. E. pre- and post-upgrade fixup scripts

Correct Answer: DE

QUERY_REWRITE_INTEGRITYandQUERY_REWRITE_ENABLEDare set toTRUSTEDand TRUE
respectively in an Oracle 12c Release 2 database.
You create theSALES_EVALreal-time materialized view (MV) on theSALES, CUSTOMERS, andPRODUCTStables, which supportsCOMPLETE REFRESHby executing these statements.
<>

1. A. from theSALES_EVALMV because theQUERY_REWRITE_ENABLEDsetting permits rewrites on unverified constraints if the table is not stale
2. B. from theSALES, CUSTOMERS, andPRODUCTS tables becauseQUERY_REWRITE_INTEGRITYis set to TRUSTED
3. C. from theSALES, CUSTOMERS, andPRODUCTStables because the column in theGROUP BYclause is different from theSALES_EVALMV definition
4. D. from theSALES, CUSTOMERS, andPRODUCTStables because the columns used in theSELECTlist are different from theSALES_EVALMV definition
5. E. from theSALES_EVALMV because theWHEREclause in the query and in theSALES_EVALdefinition are the same

Correct Answer: E

You create a new application container,SALES_APP, with applicationPDBs,SALES1_PDB, andSALES2_PDB.
You want to install theNEW_APPapplication inSALES1_PDBandSALES2_PDBby using:
<>

1. A. All the statements should be executed in the application root.
2. B. All the statements should be executed in the application seed.
3. C. All the statements should be executed in theSALES1_PDBandSALES2_PDBapplication containers.
4. D. BEGIN/END INSTALLstatements should be executed in the application root and the SYNC statement inSALES1_PDBandSALES2_PDB.
5. E. BEGIN/END INSTALLstatements should be executed in the CDB root and the SYNC statement in the application root.

Correct Answer: AD