[2023年更新]1Z1-083試験問題集でテストエンジン練習テスト問題
合格できる1Z1-083試験[2023年04月09日]最新279問題
Oracle 1Z1-083 (Oracle Database Administration II) 認定試験は、Oracle データベース管理のエキスパートであることを証明したいデータベース管理者にとって高く求められている認定試験です。この試験は、大規模な Oracle データベースを管理する責任を持つ IT プロフェッショナルの知識と技能をテストするために設計されています。データベースアーキテクチャ、バックアップとリカバリ、パフォーマンスチューニング、セキュリティなど、幅広いトピックをカバーしています。
Oracle 1Z1-083試験に合格することは、データベース管理のキャリアを進めたい個人にとって重要な成果です。認定試験に合格することは、個人がOracleデータベース管理の概念を深く理解し、複雑なOracleデータベースを管理する能力があることを示しています。認定はまた、Oracleデータベースを使用する組織でOracleデータベース管理者として働きたい個人の資格証明にもなります。
Oracle 1Z1-083試験は、Oracleデータベース管理のスキルを向上させたい専門家向けの上級認定です。この試験に合格した候補者は、データベースの管理、制御、およびメンテナンスのエキスパートとして認められます。この認定は、Oracleのデータベース管理カリキュラムの第2レベルであり、最初のレベルで習得した知識とスキルを発展させます。
質問 # 54
Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:
Which two are true?
- A. PDB1 and PDB2 are in read only state.
- B. Redo logs are opened.
- C. CDB$ROOT is in mount state.
- D. PDB$SEED is in read only state.
- E. PDB1 and PDB2 are in mount state.
正解：A、B
質問 # 55
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
- A. Metrics are statistical counts for a specific unit.
- B. STATISTICS_LEVEL must be set to ALL to generate alerts.
- C. All metrics are instance related.
- D. A space usage management alert is automatically cleared after the underlying problem is resolved.
- E. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
- F. They are generated by SMON when a tablespace is 97% full.
正解：A、B、D
質問 # 56
Examine this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are pluggable databases in CDB1.
* PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. CDB1 is shut down.
- B. Uncommitted transactions in PDB1 have been rolled back.
- C. CDB1 is in MOUNT state
- D. PDB1 is closed.
- E. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
正解：B、D
質問 # 57
choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE command?
- A. It fails because no parallel channels are allocated for the auxiliary database.
- B. It fails because connection to the AUXILIARY instance must be as SYSDBA.
- C. Itsucceeds only if the target database is greater than 400M.
- D. It succeeds.
- E. No catalogued backup of the TARGET is used to duplicate the database.
正解：D、E
質問 # 58
Examine these actions:
1. Create a new database for a recovery catalog.
2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3. Configure archivelog mode for the catalog database.
4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.
5. Grant the recovery_catalog_owner role to the recovery catalog schema owner.
6. Grant the sysbackup privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the create catalog command?
- A. 1,2,4, 5
- B. 2, 4, 5, 6
- C. 1,3,4, 5
- D. 1,2,3,4, 5,6
- E. 2, 4, 5
正解：C
質問 # 59
Which three are true about Oracle Grid Infrastructure for a Standalone Server?
- A. It creates one disk group during installation.
- B. It requires Oracle ASMLib to manage Automatic Storage Managerment (ASMl) disks.
- C. Automatic Storage Management (ASM requires that ars groups OSASM and OSDBA be assigned assecondary groups for its installation owner.
- D. It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.
- E. It requires Oracle ASM Filter Drver (ASMFD) to manage Automatic Storage Managemernt (AsM) disks.
- F. It requires the operating system ORACLE_BASDE environment variable to be predefined before installation.
正解：A、C、D
質問 # 60
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
- A. using the CREATE TABLE AS SELECT SQL statement
- B. using operating system file copy utilities
- C. using Database Replay
- D. using Database Upgrade Assistant
- E. using Oracle Data Pump
- F. using SQL Developer
正解：A、E、F
解説：
Explanation
https://www.oracle.com/a/tech/docs/twp-upgrade-oracle-database-19c.pdf
質問 # 61
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)
- A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
- B. CDB$ROOT and PDB$SEED are automatically duplicated.
- C. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
- D. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
- E. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
正解：C、D
解説：
Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV430
質問 # 62
You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:
Which three are true? (Choose three.)
- A. All archive logs created after this backup are kept for two years.
- B. The control file is included in the self-contained archival backup.
- C. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
- D. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
- E. The restore point is a label for the system change number (SCN) before the archival backup was taken.
- F. The SPFILE is included in the self-contaied archival backup.
正解：B、C、F
解説：
Explanation
https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_6011.htm
http://devel.hotpilot.cz/ora11gR2u2-full/backup.112/e10643/rcmsubcl011.htm An example:
http://www.online-database.eu/recovery-manager-rman/143-rman-backupsets-with-restore-point
質問 # 63
Which two are true about the SQL Tuning Advisor?
- A. It only recommends syntactic changes to SQL statements.
- B. It can recommend semantic changes to SQL statements.
- C. It considers all SQL statements being analyzed by the advisor task as a group.
- D. It prevents performance regressions for SQL statements when changes are made.
- E. It checks each query being analyzed for missing or stale statistics.
正解：B、C
質問 # 64
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
- B. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
- C. An existing Oracle base can be used.
- D. Only the grid user can perform the upgrade.
- E. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
- F. Existing Oracle Database instances must be shut down before starting the upgrade.
正解：A、D、F
質問 # 65
Which two are true about common objects? (Choose two.)
- A. They can be only metadata-linked in an application container.
- B. They can exist in user-defined schemas only in application containers.
- C. They can be created only in an application root.
- D. They can be created only in CDB$ROOT.
- E. They can be extended data-linked in CDB$ROOT.
- F. They can exist in CDB$ROOT and an application root.
正解：F
質問 # 66
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?
- A. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
- B. by using the RMAN switch command to set the new location for the data files
- C. by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host
- D. by creating a new database in the new host, and then using the RMAN recover command
正解：A
質問 # 67
Which two statements are true when row archival management is enabled?
- A. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct
- B. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
- C. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
- D. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
- E. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
正解：B、E
質問 # 68
Choose three. Which three are true about Audit policies in container databases (CDBs)?
- A. A common unified audit policy can be created at the application root level.
- B. Application-common unified audit policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
- C. A common unified audit policy can be created at the CDB level.
- D. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
- E. An application PDB cannot have a local audit policy.
- F. All audit records are written to the audit trail in CDB$ROOT .
正解：A、B、C
質問 # 69
Which two are true about common objects? (Choose two.)
- A. They can be only metadata-linked in an application container.
- B. They can exist in user-defined schemas only in application containers.
- C. They can be created only in an application root.
- D. They can be created only in CDB$ROOT.
- E. They can exist in CDB$ROOT and an application root.
- F. They can be extended data-linked in CDB$ROOT.
正解：B、C
解説：
Reference:
https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharing- of-data-in-application-common-objects
質問 # 70
You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:
Which two are true? (Choose two.)
- A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
- B. The inserts on USER1.EMP were committed when the session connected to PDB2.
- C. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
- D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
- E. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
- F. The insert on USER2.DEPT is uncommitted.
- G. The insert on USER2.DEPT fails because of the active transaction in the parent container.
正解：D、E
質問 # 71
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
- B. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
- C. An existing Oracle base can be used.
- D. Only the griduser can perform the upgrade.
- E. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
- F. Existing Oracle Database instances must be shut down before starting the upgrade.
正解：A、D、F
解説：
Explanation/Reference: https://docs.oracle.com/database/121/CWLIN/procstop.htm#CEGEDCDB
質問 # 72
Which two are true about a Recovery Manager (RMAN) duplication without a target connection?
- A. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
- B. The undo tablespace clause is always required when no connection exists to the target instance.
- C. The undo tablespace clause is always required when no connection exists to the recovery catalog and the target database is closed.
- D. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
- E. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
正解：C、D
質問 # 73
......
Oracle 1Z1-083リアルな2023年最新の知能問題集模擬試験問題集：https://jp.fast2test.com/1Z1-083-premium-file.html