100%更新されたのはOracle 1Z0-083限定版PDF問題集
有効な試験問題を試そう1Z0-083には無料サイトで限定お試しチャンス
質問 78
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
- A. A space usage management alert is automatically cleared after the underlying problem is resolved.
- B. All metrics are instance related.
- C. Metrics are statistical counts for a specific unit.
- D. They are generated by SMON when a tablespace is 97% full.
- E. STATISTICS_LEVEL must be set to ALL to generate alerts.
- F. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
正解: A,C,F
解説:
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2
質問 79
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The local_undo_enabled database property is set to false in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the backup database command while connected to CDB$ROOT.
Which three are true?
- A. Data file 24 can be restored only while connected to PDB2.
- B. Data file 24 can be recovered only while connected to PDB2.
- C. Data file 24 can be recovered while connected to PDB2.
- D. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- E. Data file 24 can be restored only while connected to CDB$ROOT.
- F. Data file 24 can be recovered while connected to CDB$ROOT.
正解: C,D,F
質問 80
You must transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
1.Make the UNIVERSITY tablespace read-only on the source system.
2.Export the UNIVERSITY tablespace metadata using EXPDP.
3.Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4.Copy the UNIVERSITY tablespace data files to the destination system.
5.Copy the Data Pump dump set to the destination system.
6.Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7.Import the UNIVERSITY tablespace metadata using IMPDP.
8.Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?
- A. 1, 2, 4, 6, 7, 8
- B. 1, 2, 4, 5, 7, 8
- C. 1, 2, 3, 4, 5, 7, 8
- D. 1, 2, 3, 4, 5, 6, 7, 8
- E. 2, 4, 5, 6, 7
正解: C
質問 81
A database is configured in ARCHIVELOG mode.
A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred.
In which two scenarios is incomplete recovery required? (Choose two.)
- A. after losing all copies of the control file
- B. after losing an UNDO tablespace that is in use
- C. after losing all members of an INACTIVE online redo log group
- D. after losing a SYSAUX tablespace data file
- E. after losing all members of the CURRENT online redo log group
正解: A,E
質問 82
Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:
Which two are true? (Choose two.)
- A. The MAPTABLE table is a metadata-linked table.
- B. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
- C. The REVENUE table partitions are not pruned across the PDBs automatically.
- D. A container map exists for the REVENUE table, but is not enabled.
- E. The CONTAINERS clause cannot be used in queries on the REVENUE table.
- F. The REVENUE table must be a list-partitioned table.
正解: B,D
質問 83
Which two are true about gathering optimizer statistics? (Choose two.)
- A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
- B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
- C. System statistics can be gathered only while connected to CDB$ROOT.
- D. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
- E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
正解: A,B
解説:
Explanation
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%2
質問 84
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
- A. By default, MMON creates an AWR snapshot every 30 minutes.
- B. ADDM can recommend extending the buffer cache.
- C. AWR snapshots must be deleted when no longer required by ADDM.
- D. ADDM can recommend shrinking the buffer cache.
- E. ADDM performs its analysis only when a DBA requests it.
- F. By default, AWR snapshots are automatically purged after eight days.
正解: C,D,F
解説:
Explanation/Reference: https://books.google.com.pk/books?id=DeQkU5E75DUC&pg=PA869&lpg=PA869&dq=By+default,
+AWR+snapshots+are+automatically+purged+after+eight
+days&source=bl&ots=DfoGmJfCMy&sig=ACfU3U0Pf2RgIs72LUV4HUzs5UIXI8sXEQ&hl=en&sa=X&ved=2ah UKEwjb8bKhu9noAhUwTxUIHRpYAuMQ6AEwA3oECAsQLA#v=onepage&q=By%20default%2C%20AWR%
20snapshots%20are%20automatically%20purged%20after%20eight%20days&f=false
質問 85
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, 3, 4, 5
- B. 2, 4, 5, 6
- C. 1, 2, 3, 4, 5, 6
- D. 1, 2, 4, 5
- E. 2, 4, 5
正解: E
質問 86
Examine this configuration:
To recover from this critical failure, you execute these commands:
What will be the outcome?
- A. Option
- B. Option
- C. Option
- D. Option
- E. Option
正解: B
質問 87
Which three true about recovering tables using RMAN? (Choose three.)
- A. RMAN always uses an auxiliary instance.
- B. RMAN can recover tables in a standby database.
- C. RMAN can recover tables owned by the SYS user.
- D. RMAN can recover tables in the SYSAUX tablespace.
- E. RMAN can recover a table after a DDL operation has altered the table structure.
- F. RMAN can recover tables in the SYSTEM tablespace.
- G. RMAN can recover tables owed by the SYSTEM user.
正解: A,D,F
質問 88
Which two are true about server-generated alerts? (Choose two.)
- A. Stateless alerts can be cleared manually.
- B. Stateless alerts can be purged manually from the alert history.
- C. Stateful alerts are purged automatically from the alert history.
- D. Stateful alerts must be created by a DBA after resolving the problem.
- E. Stateless alerts are automatically cleared.
正解: A,D
質問 89
Examine this command:
$ rhpctl move database -sourcehorae Oracle_horne_path -destinationhome Oracle_home_path For which two purposes can you use this command?
- A. to switch to a read-only Oracle home
- B. to switch back to the previous Oracle home as part of a rollback operation
- C. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
- D. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
- E. to switch to a patched Oracle Database home
正解: A,C
質問 90
A database is configured in ARCHIVELOGmode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required? (Choose two.)
- A. after losing all copies of the control file
- B. after losing all members of the CURRENTonline redo log group
- C. after losing an UNDOtablespace that is in use
- D. after losing all members of an INACTIVE online redo log group
- E. after losing a SYSAUXtablespace data file
正解: A,D
質問 91
Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)
- A. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
- B. Space might be reclaimed proactively before space pressure occurs.
- C. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)
- D. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
- E. Space is always reclaimed proactively before space pressure occurs.
正解: A,C
質問 92
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:
Which three are true? (Choose three.)
- A. An application root PDB is created for APP1.
- B. A default service is created for the application root APP1.
- C. APP1 can never be unplugged.
- D. An application seed PDB is created for APP1.
- E. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
- F. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
正解: D,E,F
質問 93
Examine this configuration:
CDB1 is a container database.
COMMON_USER_PREFIX is C##.
PDB1 is a pluggable database contained in CDB1.
APP1_ROOT is an application container contained in CDB1.
APP1_PDB1 is an application PDB contained in APP1_ROOT.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.
- B. APP1_USER1 can be created in CDB1.
- C. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
- D. APP1_USER1 can be created in PDB1.
- E. P1_USER1 can be created in CDB1.
- F. C##_APP_USER1 can be created in CDB1.
正解: A,C
質問 94
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)
- A. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
- B. A Virtual Private Catalog used to register a container database can be created in a non-container database.
- C. It is always possible for RMAN to connect to a pluggable database as a target.
- D. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
- E. A Virtual Private Catalog used to register a container database can be created in a pluggable database.
- F. It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
正解: B,C,E
解説:
Explanation/Reference:
質問 95
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It is part of the DBMS_ADVISORpackage.
- B. It runs automatically every night by default.
- C. It is part of the DBMS_STATSpackage.
- D. It always analyzes all schemas in the database.
- E. It can be run only manually.
- F. It can recommend changes to improve the statistics gathering process.
正解: C,D,F
解説:
Explanation/Reference: https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2
質問 96
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. By default, AWR snapshots are retained for 7 days.
- B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
- C. By default, AWR snapshots are taken every 60 minutes.
- D. AWR data is stored in the SYSTEM tablespace.
- E. The taking of AWR snapshots can be disabled.
正解: B,C,E
解説:
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
質問 97
PDB1 and PBD2 are pluggable databases in CDB1.
Examine these commands:
CDB1 is then restarted.
Which three are true? (Choose three.)
- A. PDB1 will be MOUNTED.
- B. PDB$SEED will be opened READ ONLY.
- C. PDB1 will be opened READ WRITE.
- D. PDB2 will be MOUNTED.
- E. PDB$SEED will be MOUNTED.
- F. PDB2 will be opened READ WRITE.
正解: B,C,F
質問 98
......
Oracle 1Z0-083公式認定ガイドPDF：https://www.goshiken.com/Oracle/1Z0-083-mondaishu.html
無料Oracle Database 19c 1Z0-083公式認定ガイドPDFダウンロード：https://drive.google.com/open?id=10cd_di496ClSw0H0wsLr8sLj-i0_1SmN