2024年最新の有効な1Z1-083リアル試験問題（更新された）100%問題集と練習試験合格させます
[更新されたのは2024年]Oracle 1Z1-083問題準備には無料サンプルのPDF
Oracle 1Z1-083 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
Oracle 1Z1-083試験の準備をするには、候補者はOracleデータベースの豊富な経験を持ち、データベース管理のベストプラクティスを完全に理解する必要があります。また、教室やオンラインコースなどのOracleのトレーニングリソース、練習試験や学習ガイドも活用する必要があります。候補者はまた、Oracle認定コミュニティへの参加を検討する必要があります。そこでは、試験の準備をして貴重な研究資料とリソースにアクセスする他の専門家とつながることができます。
質問 # 136
Choose three. Which three are performed by Oracle Automatic Storage Management (ASM) instances?
- A. managing space allocation for Oracle ASM files
- B. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
- C. mounting disk groups
- D. managing Allocation Units (AUs) for disk group content
- E. managing extent allocation for Oracle database segments
- F. acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
正解：A、C、D
質問 # 137
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
- A. Databases can be transported between systems with different endian formats.
- B. Data files can be converted on the source system.
- C. The password file is automatically converted by RMAN.
- D. By default, the transported database will use Oracle Managed Files (OMF)
- E. A new DBID is automatically created for the transported database.
- F. Data files can be converted on the destination system.
正解：B、D、F
解説：
Explanation
A: If you do not provide a destination, then the DB_FILE_CREATE_DEST initialization parameter must be set in the target platform. RMAN restores the data files to the location specified by this parameter using new Oracle Managed File (OMF) names. BC: While creating the cross-platform backup to transport a database, you can convert the database either on the source database or the destination database. The benefit of performing the conversion on the destination database is that the processing overhead of the convert operation is offloaded from the source to the destination database.
質問 # 138
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
- A. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- B. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
- C. A target database's persistent RMAN configuration settings are always stored in the target's control file
- D. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
- E. The RMAN SHOW ALL command displays only settings with nondefault values.
- F. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
- G. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
正解：C、D、F
質問 # 139
Which two are true about common objects? (Choose two.)
- A. They can exist in user-defined schemas only in application containers.
- B. They can exist in CDB$ROOTand an application root.
- C. They can be created only in an application root.
- D. They can be only metadata-linked in an application container.
- E. They can be extended data-linked in CDB$ROOT.
- F. They can be created only in CDB$ROOT.
正解：C、E
解説：
Explanation/Reference: https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharing-of- data-in-application-common-objects
質問 # 140
Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?
- A. Run the Memory Advisor for the Program Global Area.
- B. Run the SQL Access Advisor.
- C. Run the SQL Tunning Advisor.
- D. Run the Memory Advisor for the shared pool.
- E. Run the Memory Advisor for the System Global Area.
正解：D
質問 # 141
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 SQL Developer
- C. using Oracle Data Pump
- D. using Database Upgrade Assistant
- E. using operating system file copy utilities
- F. using Database Replay
正解：A、D、E
質問 # 142
Which two are true about Oracle instance recovery? (Choose three.)
- A. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
- B. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
- C. Recovery reads redo until the end of the redo thread. SMON rollsback any dead transactions, and then the datanase is opened.
- D. Recovery begins from the beginning of the CURRENT redo log group.
- E. Recovery begins from the last checkpoint position that wascalculated by the Database Writer before instance failure.
- F. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
正解：B、C、E
質問 # 143
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)
- A. creating thte oraInventory (oinstall) group
- B. creating the OSDBA (dba) group
- C. creating the grid OS user
- D. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
- E. creating the oracle OS user
- F. configuring the OS for Oracle Automatic Storage Management shared storage access
正解：A、B、E
質問 # 144
HR_ROOT is an application container with the HR_APP application installed.
No application PDBs and no application seed have yet been created in HR_ROOT.
An application PDB, PDB1, must be created so that the HR_APP application's common objects are accessible to it.
Which two methods can be used? (Choose two.)
- A. Create an application seed, and install HR_APP in it.
- B. Create the PDB1 application PDB and install HR_APP in it.
- C. Create the PBD1 application PDB and synchronize it with PDB$SEED.
- D. Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.
- E. Create the PBD1 application PDB and synchronize it with HR_ROOT.
正解：A、D
質問 # 145
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
- A. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- B. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
- C. A target database's persistent RMAN configuration settings are always stored in the target's control file
- D. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
- E. The RMAN SHOW ALL command displays only settings with nondefault values.
- F. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
- G. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
正解：C、D、F
解説：
Reference:
https://books.google.com.pk/books? id=pUEkAAAAQBAJ&pg=PA114&lpg=PA114&dq=V$RMAN_CONFIGURATION+view+displays+only+settings
+with+values+that+have+been+modified&source=bl&ots=fhC9A7ULeX&sig=ACfU3U2- cGhTjmAOpCZhvlL5R4j6ixLRAw&hl=en&sa=X&ved=2ahUKEwjJzf- WmtnoAhXT8eAKHQ9uBG8Q6AEwAHoECAwQJg#v=onepage&q=V%24RMAN_CONFIGURATION%20view
%20displays%20only%20settings%20with%20values%20that%20have%20been%20modified&f=false
質問 # 146
Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)
- A. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
- B. to switch to a patched Oracle Database home
- C. to switch to a read-only Oracle home
- D. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
- E. to switch back to the previous Oracle home as part of a rollback operation
正解：B、E
解説：
Explanation
You can use rhpctl move gihome command with the same syntax to switch from the current Oracle Grid Infrastructure home to a patched home. The rhpctl command enables you to switch from your current Oracle Grid Infrastructure or Oracle Database home to patched Oracle home so that you can provision the new Oracle home as gold image. You can also use the rhpctl command to switch back to the old Oracle home, if you want to roll back the operation.
質問 # 147
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
- A. SQL statements doing joins always do more physical I/O than single table queries.
- B. Poorly performing SQL statements can be tuned automatically by the Oracle server.
- C. The solution that best optimizes one SQL statement can degrade the performance of others.
- D. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
- E. SQL statements doing only logical reads never require tuning because they do no physical I/O.
正解：B、C
質問 # 148
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
- A. After the change, only one undo tablespace can exist in CDB$ROOT.
- B. Undo tablespaces existing in PDBs must be dropped before the change.
- C. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- D. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
- E. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
- F. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
正解：A、E
解説：
You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property. When the database property LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO tablespace that is created in the CDB root, and that is shared by all containers. When LOCAL_UNDO_ENABLE is TRUE, every container in the CDB uses local undo and each PDB must have its own local UNDO tablespace. To maintain ease of management and provisioning, UNDO tablespace creation happens automatically and does not require any action from the user. When a PDB is opened and an UNDO tablespace is not available, its automatically created.
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/creating-and-configuring-a- cdb.html#GUID-12ADA04D-F81D-4579-A68C-0958CC7D6C2F
質問 # 149
Choose the best answer. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
- A. database writer performance
- B. log writer performance
- C. SQL statements
- D. general operating system health
- E. database instance memory management and sizes
正解：D
質問 # 150
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
- A. Databases can be transported between systems with different endian formats.
- B. Data files can be converted on the source system.
- C. The password file is automatically converted by RMAN.
- D. By default, the transported database will use Oracle Managed Files (OMF)
- E. A new DBID is automatically created for the transported database.
- F. Data files can be converted on the destination system.
正解：B、D、F
質問 # 151
A container database called CDB1is OMF-enabled.
PDB_FILE_NAME_CONVERTis not configured in CDB1.
PDB1was unplugged from CDB1earlier 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. PDB1 must be dropped from CDB1.
- B. /u01/app/oracle/oradata/pdb1.xmldoes not contain the current locations of data files for PDB1.
- C. DBMS_PDB.CHECK_PLUG_COMPATIBILITYmust be run in CDB1before executing the command.
- D. PDB_FILE_NAME_CONVERTmust be set before executing the command.
- E. PDB1 data files already exist in the correct location.
正解：B、D
解説：
Explanation/Reference: http://anjaniappsdba.blogspot.com/2016/09/oracle-database-12102c-hot-cloning-of.html
質問 # 152
Examine these queries and their output:
An online RMAN backup of the CDB was taken an hour before Restore Point R1was created.
You want to recover PDB1 to Restore Point R1.
How do you achieve this?
- A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to CDB$ROOT.
- B. This cannot be done due to the lack of a clean restore point.
- C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to PDB1.
- D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to PDB1.
- E. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to CDB$ROOT.
正解：C
解説：
Explanation/Reference:
質問 # 153
......
1Z1-083豪華セット学習ガイドにはオンライン試験エンジン：https://jp.fast2test.com/1Z1-083-premium-file.html