最適な練習法には1Z0-083問題集で素晴らしい1Z0-083試験問題PDF [Q103-Q127]

最適な練習法には1Z0-083問題集で素晴らしい1Z0-083試験問題PDF

更新された検証済みの合格させる1Z0-083試験リアル問題と解答があります

質問 # 103
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A. The register database privilege should be granted to the virtual catalog owner.
B. At least one target database should be registered in the recovery catalog.
C. The owner of VPC cannot own recovery catalog.
D. The recovery_catalog_owner role should be granted to the virtual catalog owner.
E. A base recovery catalog should exist.

正解：A、C、E

質問 # 104
Which three are true about Automatic Workload Repository (AWR) snapshots?

A. They are generated if STATISTICS_LEVEL is set to BASIC.
B. They are always created manually.
C. They are always created automatically.
D. They can be retained forever.
E. They are generated if STATISTICS_LEVEL is set to ALL.
F. They are generated if STATISTICS_LEVEL is set to TYPICAL.

正解：C、E、F

質問 # 105
You want to transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have the same endian format.
Examine this list of steps:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause.
4. Copy the cross-platform backup sets to the destination system.
5. Copy the Data Pump dump set from the source to the destination system.
6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

A. 1, 3, 4, 6, 8
B. 2, 3, 4, 5, 6, 7
C. 3, 4, 6
D. 1, 2, 3, 4, 5, 6, 7, 8

正解：A

質問 # 106
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)

A. It is an Oracle Database service
B. It cannot be used to upgrade Oracle Database homes.
C. It can be used to provision middleware.
D. It can be used to provision applications.
E. It can be used to patch Grid Infrastructure homes containing Oracle Restart.

正解：C、E

質問 # 107
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?

A. after losing a sysaux tablespace data file
B. after losing all copies of the control file
C. after losing all members of the current online redo log group
D. after losing an undo tablespace that is in use
E. after losing all members of an inactive online redo log group

正解：C、E

質問 # 108
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 and recovered while connected to CDB$ROOT.
B. Data file 24 can be recovered only while connected to PDB2.
C. Data file 24 can be restored only while connected to CDB$ROOT.
D. Data file 24 can be recovered while connected to CDB$ROOT.
E. Data file 24 can be recovered while connected to PDB2.
F. Data file 24 can be restored only while connected to PDB2.

正解：B、C、E

質問 # 109
Examine this configuration:

To recover from this critical failure, you execute these commands:

What will be the outcome?
A)

B)

C)

D)

E)

A. Option E
B. Option C
C. Option B
D. Option D
E. Option A

正解：E

質問 # 110
Which two are true about unplugging an application container from a container database and plugging it into a different container database?

A. It requires only local undo mode in the database where the application container will be unplugged.
B. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.
C. Unplugging the application root from a CDB unplugs all its application PDBs.
D. Plugging the application root into a different CDB plugs In all its application PDBs.
E. It requires local undo mode in both container databases.
F. Application PDBs In the application container must be unplugged before the application root Is unplugged.

正解：C、F

質問 # 111
Which three are true about performing an Oracle Database install on Linux? (Choose three.)

A. It can be done after installing Grid Infrastructure for a Standalone Server.
B. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
C. It can be done before installing Grid Infrastructure for a Standalone Server.
D. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
E. The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.
F. The runfixup.sh script can install missing RPMs.
G. It allows you to select the languages supported by the Oracle database server.

正解：D、E、G

質問 # 112
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 closed.
B. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
C. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
D. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
E. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
F. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
G. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.
H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

正解：A、D、F、H

質問 # 113
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

A. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
B. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
C. The Oracle Grid Infrastructure installation must be owned by the grid user.
D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
E. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
F. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.

正解：D、E

質問 # 114
A database is configured in ARCHIVE LOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)

A. after losing an archived log from before the most recent backup
B. after losing all copies of the control file
C. when any archived log from, before, or after the most recent backup is corrupt.
D. after losing the SYSTEM tablespace
E. after losing an archived log from after the most recent backup

正解：A、D

質問 # 115
Which three are true about Database Point-in-Time Recovery? (Choose three.)

A. The target point for the recovery must be specified as a stime or System Change Number (SCN).
B. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
C. The database must be open RESETLOGS after Database Point-in-Time Recovery.
D. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
E. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
F. The Database must be in ARCHIVELOG mode.

正解：C、D、F

解説：
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20target%20time.

質問 # 116
Which two are true about the SQL Tuning Advisor?

A. It can recommend semantic changes to SQL statements.
B. It checks each query being analyzed for missing or stale statistics.
C. It only recommends syntactic changes to SQL statements.
D. It prevents performance regressions for SQL statements when changes are made.
E. It considers all SQL statements being analyzed by the advisor task as a group.

正解：A、E

質問 # 117
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 UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
C. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
D. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
E. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
F. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
G. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

正解：B、E、F、H

質問 # 118
Which two are true about server-generated alerts? (Choose two.)

A. Stateless alerts can be purged manually from the alert history.
B. Stateless alerts are automatically cleared.
C. Stateless alerts can be cleared manually.
D. Stateful alerts must be created by a DBA after resolving the problem.
E. Stateful alerts are purged automatically from the alert history

正解：A、C

質問 # 119
Which four are true about RMAN backup sets? (Choose four.)

A. Blocks from multiple data files can be contained in one backup set,.
B. A backup set must be written to disk.
C. Blocks from multiple data files can be contained in one backup piece,
D. A backup piece can belong to only one backup set.
E. A backup set must be written to media.
F. A data file can be split into multiple sections stored in different backup pieces in the same backup set.
G. A data file can be split into multiple sections stored in different backup sets.
H. A backup set can contain only one backup piece.

正解：A、C、D、F

質問 # 120
A user complains about poor database performance. You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

A. V$SESSTAT
B. V$SESSION
C. V$SESSION_WAIT_CLASS
D. V$SESSION_WAIT
E. V$SESSION_EVENT

正解：E

質問 # 121
T schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

A. Imported databases are unregistered from the RC11 catalog.
B. Recovery catalog is resynchronized with the control files of the registered databases.
C. All databases registered in the RC11 catalog are registered in the RC12C catalog.
D. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
E. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

正解：C、E

質問 # 122
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? (Choose three.)

A. Data file 24 can be recovered only while connected to PDB2.
B. Data file 24 can be restored only while connected to PDB2.
C. Data file 24 can be restored and recovered while connected to CDB$ROOT.
D. Data file 24 can be restored only while connected to CDB$ROOT.
E. Data file 24 can be recovered while connected to CDB$ROOT.
F. Data file 24 can be recovered while connected to PDB2.

正解：B、C、E

質問 # 123
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 REVENUE table partitions are not pruned across the PDBs automatically.
C. The REVENUE table must be a list-partitioned table.
D. The CONTAINERS clause cannot be used in queries on the REVENUE table.
E. A container map exists for the REVENUE table, but is not enabled.
F. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

正解：E、F

質問 # 124
Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A. A DBA can run it manually.
B. It analyzes a period of time corresponding to the last day of activity.
C. It runs automatically after each AWR snapshot.
D. It analyzes a period of time corresponding to the 12 hours of activity.
E. Results are written to the alert log.

正解：A、C

質問 # 125
Choose two. Which two are true about backup set compression using RMAN default compression?

A. Compressed backups cannot have a section size defined.
B. Compressed backups can be written only to media.
C. Compression can be done only for locally managed tablespaces.
D. Binary compression adds CPU overhead to backup operations.
E. Unused blocks below the high water mark are backed up.

正解：C、D

質問 # 126
Choose three. Which three are true about Oracle pluggable databases (PDBs)?

A. A PDB in a remote CDB can be accessed transparently thereby aggregating results from local and remote PDBs.
B. An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.
C. A PDB created from PDB$SEED must be set to READ WRITE after loading data.
D. A PDB created from PDB$SEED must be set to READ ONLY after loading data.
E. A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.
F. A PDB can be plugged into a CDB only if both are of the same Oracle Database release.
G. A non-CDB can be converted into a PDB.

正解：A、E、G

質問 # 127
......

更新されたPDF（2023年最新）実際にある 1Z0-083試験問題：https://jp.fast2test.com/1Z0-083-premium-file.html

問題集返金保証付きの1Z0-083公式問題集：https://drive.google.com/open?id=1-9bC_6WKhT8WqbRUXjAJFwKFKa_vnTsE