1Z1-083試験無料問題集「Oracle Database Administration II 認定」

A. A proxy PDB must exist in the application root in the remote CDB.

B. A proxy PDB must exist in the application root in the local CDB.

C. PDB3's application root replica must exist in the local CDB.

D. The HR_ROOT replica must exist in the remote CDB.

E. A database link must exist in the local CDB root referring to the remote CDB.

F. A database link must exist in the remote CDB referring to the local CDB.

A. They can be used as a level 0 incremental backup.

B. They can be used as a level 1 incremental backup.

C. They can only be written to disk.

D. They are the only backup option available for databases in NOARCHIVELOG mode.

E. They can be encrypted using Transparent Data Encryption (TDE).

A. Silent install always runs operating scripts automatically.

B. The response file must contain the root or sudo password.

C. The response file can specify the path of the sudo program.

D. The response file can specify the root or sudo password.

E. The installer will prompt for the root or sudo password.

A. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

B. Oracle DBCA templates can store only logical structure and not database files.

C. The Data Warehouse template is most suitable when transaction response time is the key criterion.

D. New templates can only be created by modifying an existing user-created template.

E. Oracle DBCA templates can be used to create new databases and duplicate existing databases.

A. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

B. FLASHBACK DROP can undrop an index when undropping a table.

C. FLASHBACK TABLE can undrop a column.

D. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

E. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

A. It performs a software-only Oracle Database installation.

B. It includes the Oracle Preinstallation RPM.

C. From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.

D. It requires an Unbreakable Linux Network (ULN) subscription.

E. It uses a service configuration script to create a single-instance database as part of the installation.

A. The runfixup.sh script can install missing RPMs.

B. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

C. It can be done after installing Grid Infrastructure for a Standalone Server.

D. It can be done before installing Grid Infrastructure for a Standalone Server.

E. It allows you to select the languages supported by the Oracle database server.

F. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

G. The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.

A. 2, 4, 5, 6, 7

B. 1, 2, 4, 6, 7, 8

C. 1, 2, 4, 5, 7, 8

D. 1, 2, 3, 4, 5, 6, 7, 8

E. 1, 2, 3, 4, 5, 7, 8

A. It fails because the command does notspecify when the unified audit policy should be enforced.

B. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.

C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

D. It fails because system privileges cannot be granted with roles in the same audit policy.

A. SQL statements doing only logical reads never require tuning because they do no physical I/O.

B. The solution that best optimizes one SQL statement can degrade the performance of others.

C. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.

D. SQL statements doing joins always do more physical I/O than single table queries.

E. Poorly performing SQL statements can be tuned automatically by the Oracle server.

A. Space might be reclaimed proactively before space pressure occurs.

B. Space is always reclaimed proactively before space pressure occurs.

C. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

D. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

E. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

A. Data is never redacted for the EMP_V.SAL column.

B. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

C. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

A. A block being recovered is not accessible.

B. It cannot repair logical corruption.

C. To use it, Flashback Database must be enabled.

D. The target database for which one or more blocks are to be recovered must be in the OPEN state.

E. It can be performed on noncorrupt blocks.

F. The data file containing the block being recovered remains online.

A. It considers all SQL statements being analyzed by the advisor task as a group.

B. It only recommends syntactic changes to SQL statements.

C. It checks each query being analyzed for missing or stale statistics.

D. It prevents performance regressions for SQL statements when changes are made.

E. It can recommend semantic changes to SQL statements.