1z1-074 試験問題を無料オンラインアクセス

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 in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.
• B.An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.
• C.PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.
• D.PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.
• E.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.

APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2.
1.0 is the current version of the application.
You execute this block in the application root:

What is the outcome?

• A.An error is thrown because the version number should be sequential, either 1.1 or 2.0.
• B.An error is thrown because the c## prefix is missing in the role name.
• C.A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2.
• D.A common role is created only in the application root.
• E.An error is thrown because the CONTAINER=ALL clause is missing.
• F.A common role is created only in the application root and application seed.

You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB.
You want to install the NEW_APP application in SALES1_PDB and SALES2_PDB by using:

Where should you execute these statements?

• A.All the statements should be executed in the application root.
• B.BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.
• C.BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.
• D.All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.
• E.All the statements should be executed in the application seed.

You create and enable a unified audit policy on a database that has the default auditing configuration.

The OE user, who has the DBA role, executes these statements.

What is true about the SELECT statement and why?

• A.It is audited because, by default, the database is in mixed auditing mode with default policies enabled.
• B.It is not audited because the table belongs to another schema.
• C.It is audited because unified auditing is disabled be default.
• D.It is audited because, by default, all user activities in the database are audited.
• E.It is not audited because audit records are stored only when unified auditing is enabled in the database.

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

• A.They require backups to be restored when used in a PDB flashback operation
• B.They can be created only for a PDB in the mount state
• C.They can be created for a PDB when connected to either the PDB or to the root
• D.They are created as guaranteed restore points
• E.They require a clone instance to be created when used in a PDB flashback operation
• F.They can be created only if shared undo is enabled