あなたを合格させる1Z0-083試験問題集で使おう（更新された283問があります) [Q159-Q177]

あなたを合格させる1Z0-083試験問題集で使おう（更新された283問があります)

1Z0-083試験問題集でOracle練習テスト問題

質問 # 159
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

A. A backup of the target database is always required.
B. A new DBID is always created for the duplicated database.
C. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
D. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
E. A connection to the target database instance is always required.
F. A connection to an auxiliary instance is always required.
G. A connection to the recovery catalog instance is always required.
H. A subset of the target database can be duplicated.

正解：C、D、F、H

解説：
A duplicate database is a copy of your target database. With the FOR STANDBY clause, it keeps the same unique database identifier(DBID); If FOR STANDBY not specified it creates a new DBID.
The duplicate database can include the same content or only a subset from the source database.
It can be in the same host or a separate host.
The principal work of the duplication is performed by the auxiliary channels.These channels correspond to a server session on the auxiliary instance on the destination host for backup based duplication.
For active database duplication the target channels perform the work of pushing data file copies to the auxiliary instance (if number of allocated target channels is greater than the number of allocated auxiliary channels).

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

A. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
B. The control file is included in the self-contained archival backup.
C. The restore point is a label for the system change number (SCN) before the archival backup was taken.
D. All archive logs created after this backup are kept for two years.
E. The spfile is included in the self-contained archival backup.
F. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

正解：B、D、E

質問 # 161
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

A. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
B. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
C. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
D. These backups can be written to disk or SBT.
E. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.

正解：A、D

質問 # 162
While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup istaking too long and suspect a performance bottleneck. Which three are true about diagnosing and tuning these problems? (Choose three.)

A. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/
B. Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.
C. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
D. If an RMAN BACKUP VALIDATE command takes noticeably lessthan an actual backup, then write I/O is a likely bottleneck.
E. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.
F. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
G. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

正解：B、C、D

質問 # 163
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

A. Media Management messages for SBT devices are always written to sbtio.log.
B. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
C. Media Management messages for SBT devices are written to an Oracle trace file.
D. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
E. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
F. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

正解：B、E

解説：
The sbtio.log contains information written by the media management software, not Oracle Database. Thus, you must consult your media vendor documentation to interpret the error codes and messages. If no information is written to the sbtio.log, then contact your media manager support to ask whether they are writing error messages in some other location, or whether there are steps you must take to have the media manager errors appear in sbtio.log.
Read the messages from the bottom up, because this is the order in which RMAN issues the messages. The last one or two errors displayed in the stack are often the most informative.
https://docs.oracle.com/database/121/BRADV/rcmtroub.htm#BRADV89875

質問 # 164
Examine this configuration:

While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted.
To recover from this critical failure, you execute these commands:

What will be the outcome?

A. It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
B. It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
C. It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
D. It will fail because there is no autobackup of the controlfiles.
E. It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'

正解：B

質問 # 165
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. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to PDB1.
C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to CDB$ROOT.
D. This cannot be done due to the lack of a clean restore point.
E. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to PDB1.

正解：E

解説：
Explanation/Reference:

質問 # 166
Choose three. Which three are performed by Oracle Automatic Storage Management (ASM) instances?

A. managing space allocation for Oracle ASM files
B. managing extent allocation for Oracle database segments
C. managing Allocation Units (AUs) for disk group content
D. acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
E. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
F. mounting disk groups

正解：A、C、F

質問 # 167
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

A. Flashback logs areautomatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
B. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
C. Flashback logs are monitored for being older than the retentionperiod defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
D. Flashback logs are automatically purged whenever the value of
DB_FLASHBACK_RETENTION_TARGET is changed.
E. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

正解：B、D

質問 # 168
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 restored only 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 PDB2.
D. Data file 24 can be restored and recovered 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.

正解：D、E、F

質問 # 169
Choose two. In performance management, which two factors might reduce the ability of an application to scale to a larger number of users?

A. poorly trained users who do not commit transactions
B. issuing multiple savepoints during a transaction
C. poorly written SQL
D. the number of tablespaces containing tables updated by a transaction
E. the number of data files containing extents belonging to tables updated by a transaction

正解：A、E

質問 # 170
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?
(Choose three.)

A. the log writer process (LGWR)
B. SYSAUX tablespaces
C. the Process Monitor Process (PMON)
D. the data dictionary in CDB$ROOT
E. temporary tablespaces
F. undo tablespaces

正解：A、C、D

解説：
https://www.doag.org/formes/pubfiles/8887426/2017-03-fma-multitenant-2.0-v01-doag.pdf

質問 # 171
Which three are true about opatchauto? (Choose three.)

A. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
B. Users must always input patch plans to opatchauto.
C. It applies patches in nonrolling mode by default.
D. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
E. It must be invoked by a user with root user privileges.
F. Patches are applied via opatchauto.
G. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

正解：E、F、G

質問 # 172
Which three are true about performing an Oracle Database install on Linux?

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

正解：A、B、F

質問 # 173
Which three are true in Oracle 19c and later releases? (Choose three.)

A. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
B. All the Oracle-supplied accounts are Schema Only accounts.
C. Schema Only accounts can be granted administrator privileges.
D. If the password file location changes, then the new location is used automatically by the Oracle Server.
E. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
F. Unified Auditing can be configured to audit only events that are issued directly by an audited user.

正解：B、C、E

解説：
Explanation
Explanation/Reference: https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/

質問 # 174
Which two are true about server-generated alerts?

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

正解：D、E

質問 # 175
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 the PBD1 application PDB and synchronize it with PDB$SEED.
B. Create an application seed, and install HR_APP in it.
C. Create the PDB1 application PDB and install HR_APP in it.
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.

正解：B、D

質問 # 176
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)