Online Access Free 1z1-074 Exam Questions

The COMPATIBLE parameter is set to 12.2.0.0.0.
Which two statements are true about SQL identifier lengths? (Choose two.)

• A.Database names can be as long as 128 bytes.
• B.Database link names can be as long as 30 bytes.
• C.Disk group, PDB, and tablespace names are limited to 30 bytes.
• D.Database names can be as long as 30 bytes.
• E.Table names can be as long as 128 bytes.

Which two statements are true about FLEX ASM? (Choose two.)

• A.A database instance on any node can connect to an ASM instance on any node.
• B.Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.
• C.Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.
• D.A separate ASM network is required.
• E.It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.

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?

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

Which two statements are true about a PDB lockdown profile? (Choose two.)

• A.It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.
• B.It is enabled by default on creation.
• C.It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.
• D.It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.
• E.It is created by a common user with the SYSDBA privilege in CDB$ROOT.
• F.It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.

You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH MODE EVERY 5 MINUTES clause.
What happens every five minutes?

• A.An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.
• B.PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.
• C.PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.
• D.An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.
• E.PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.