あなたを合格させる1Z0-083お手軽に試験合格リアル1Z0-083練習問題集で更新されたのは2025年04月24日
2025年最新の実際に出ると確認されたで無料Oracle 1Z0-083試験問題
Oracle 1Z1-083（Oracle Database Administration II）試験は、Oracleデータベースの管理と維持に関する知識とスキルを検証したいデータベース管理者向けに設計されています。この試験は、Database Professionalのグローバルに認識されているベンチマークであるOracle Certified Professional（OCP）認定トラックの一部です。この試験に合格すると、パフォーマンスチューニング、バックアップと回復、セキュリティ管理、トラブルシューティングなど、高度なデータベース管理タスクの専門知識が示されます。
質問 # 44
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
(Choose two.)
- A. Poorly performing SQL statements can be tuned automatically by the Oracle server.
- B. The solution that best optimizes one SQL statement can degrade the performance of others.
- C. SQL statements doing only logical reads never require tuning because they do no physical I/O.
- D. SQL statements doing joins always do more physical I/O than single table queries.
- E. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
正解：A、C
質問 # 45
Choose three. Which three actions will add a resource to an Oracle Restart configuration?
- A. creating a database service using DBMS_SERVICE.CREATE_SERVICE
- B. creating a disk group using the CREATE DISKGROUP SQL statement
- C. creating a database service using Oracle Database Configuration Assistant (DBCA)
- D. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
- E. creating a database using the CREATE DATABASE SQL statement
- F. creating an Oracle Database service by modifying the SERVICE_NAMES parameter
正解：C、D、E
質問 # 46
Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)
- A. They cannot drop tablespaces.
- B. They can view data from any data dictionary view or dynamic performance view.
- C. They can view data from any user-defined tables.
- D. They can drop any tablespace.
- E. They cannot create restore points.
- F. They can create any table.
正解：B、D、F
解説：
https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-privilege-and- role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7
質問 # 47
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
- A. Control file backups can be created while connected to the root container.
- B. Online Redo Log backups can be created while connected to the root container.
- C. Archived Redo Log backups can be created while connected to an application root CDB.
- D. The BACKUP TABLESPACEcommand can back up a PDBtablespace even if RMAN is connected to CDB$ROOT.
- E. Control file backups can be created while connected to a nonroot container.
正解：A、D
解説：
A - FALSE. The ARCH process backs up online redo logs (by creating Arch redo logs), never the DBA. DBAs backup Archive Redo Logs, not online redo logs.
B - TRUE. Control files are DB wide - backing them up, from the Container Root, is exactly where you do this.
C - TRUE. Part of the point of Multitenant is that you have control of all PDBs from the CDB level.
D - FALSE. An application root container is still below the main Container, so you cannot administer control files from here.
E - FALSE. For the same reason as above, you can only create control file backups from the Root Container.
質問 # 48
Examine the command for creating pluggable database PDB2 in container database CDB2.
Select three options, any one of which is required for it to execute successfully. (Choose three.)
- A. Set only the PDB_FILE_NAME_CONVERTparameter.
- B. Add the FILE_NAME_CONVERTclause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
- C. Enable only OMF.
- D. Add the FILE_NAME_CONVERTclause to the statement and enable Oracle Managed Files (OMF)
- E. Set the PDB_FILE_NAME_CONVERTparameter and enable OMF.
- F. Add only the CREATE_FILE_DESTclause to the statement.
正解：C、E、F
質問 # 49
Which three are located by using environment variables? (Choose three.)
- A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
- B. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
- C. the location of Oracle Net Services configuration files
- D. the temporary disk space used by Oracle Installer during installation
- E. the maximum number of database files that can be opened by a database instance
- F. default directories for temporary files used by temporary tablespaces
正解：A、C、D
解説：
A - ORACLE_BASE, ORACLE_HOME - correct
B - TNS_ADMIN, old TWO_TASK, etc - correct
C - spfile parameter ASM_DISKGROUPS, not env variable
D - [s]pfile parameter DB_CREATE_FILE_DEST, not env variable
E - TMP, TEMP - correct
F - [s]pfile parameter DB_FILES, not env variable
質問 # 50
Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)
- A. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
- B. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
- C. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
- 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.
- F. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.
- G. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
- H. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
正解：B、D、E、H
質問 # 51
A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)
- A. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
- B. PDB_FILE_NAME_CONVERT must be set before executing the command.
- C. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
- D. PDB1 must be dropped from CDB1.
- E. PDB1 data files already exist in the correct location.
正解：D、E
解説：
Reference:
http://anjaniappsdba.blogspot.com/2016/09/oracle-database-12102c-hot-cloning-of.html
質問 # 52
Examine this configuration:
17.CDB1is an Oracle Database 12c Release 2 container database (CDB).
18.PDB1and PDB2are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:
What is the outcome?
- A. Only CDB$ROOT and PDB$SEED are upgraded.
- B. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
- C. It fails because PDB2 is not in UPGRADE state.
- D. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
- E. It fails because PDB$SEED is in MIGRATE state.
- F. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
正解：B
解説：
https://docs.oracle.com/en/database/oracle/oracle-database/21/upgrd/upgrading-parallel- upgrade-utility-catctl-pl.html#GUID-C667B51C-058F-48B6-86FE-12E9D82FDDBD
質問 # 53
Which two are true about RMAN duplexed backup sets? (Choose two.)
- A. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.
- B. They can be written to media.
- C. They must be written to media.
- D. They can be written only to disk.
- E. They can be created only by using the COPIES option of a BACKUP command.
正解：A、B
解説：
In most cases, the easiest method of duplexing backup sets is to use BACKUP... COPIES or CONFIGURE ... BACKUP COPIES to duplex backup sets.
RMAN can duplex backups to either disk or tape, but cannot duplex backups to tape and disk simultaneously.
https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/configuring-rman-client- advanced.html#GUID-2A285F87-552A-4F36-A5B9-F25A69611B4B
質問 # 54
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?
- A. The statistics_level parameter is set to all only for PDB2 when it is reopened.
- B. The statistics_level parameter is set to all when the root database is restarted.
- C. The statistics_level parameter is set to all when any of the PDBs is reopened.
- D. The statement is ignored because there is no SPFILE for a PDB.
正解：A
質問 # 55
Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)
- A. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
- B. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
- C. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
- D. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
- E. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
- F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
- G. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
- H. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
正解：B、C、D、E
質問 # 56
Which three activities are possible for PDBs? (Choose three.)
- A. converting an application container into another application container in a different CDB
- B. converting an application PDB to an application root
- C. converting an application PDB to a regular PDB
- D. converting an application seed to an application PDB
- E. converting an application PDB to an application seed
- F. converting an application container into another application container in the same CDB
- G. converting a regular PDB to an application PDB
正解：D、E、G
解説：
Application seed can be created from
CDB seed - Application seed is created unsynced with the application in application root Application root - Application seed is created synced with the application in application root but script pdb_to_apppdb.sql needs to be run Application PDB - Synchronization status of Application Seed created is same as the source application PDB Application PDBs can be created from CDB seed - Application PDB is created unsynced with the application in application root Application seed - Synchronization status of created Application PDB is same as the source application seed Application PDB - Synchronization status of created Application PDB is same as the source application PDB
https://blog.toadworld.com/2017/07/10/oracle-multi-tenant-application-containers-part-ii-create-application-container
E: http://oracle-help.com/oracle-database/multitenant/convert-regular-pdb-to-application-pdb/
質問 # 57
Examine this configuration:
1. CDB1 is a container database.
2. COMMON_USER_PREFIX is set to an empty string.
3. PDB1 is a pluggable database in CDB1.
4. APP1_ROOT is an application container in CDB1.
5. APP1_PDB1 is an application PDB in APP1_ROOT.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
What is true?
- A. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
- B. ROLE1 will be created only in CDB$ROOT.
- C. It will return an error because creation of a local role is not allowed in CDB$ROOT.
- D. ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
- E. It will return an error because common roles must start with C##.
正解：B
質問 # 58
choose three Which three are true about unified auditing in full mode?
- A. The unified audit trail is written to a read-only external file.
- B. Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.
- C. The unified audit trail is written to a read-only table.
- D. Audit records are created for SYS.
- E. Audit records are created for non-sys users.
正解：C、D、E
質問 # 59
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)
- A. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
- B. CDB1 and CDB2 must be in shared undo mode.
- C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
- D. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
- E. Cloning HR_ROOT automatically clones HR_PDB1.
正解：A、E
質問 # 60
......
1Z0-083リアル試験問題解答は無料：https://www.goshiken.com/Oracle/1Z0-083-mondaishu.html
1Z0-083試験問題、リアル1Z0-083練習問題集：https://drive.google.com/open?id=1EFjPUQTgm4Dk0_mncLfnB-fglHpwQWJE