無料1Z1-083サンプル問題で100%カバー率のリアル試験問題（更新された283問あります) [Q70-Q92]

無料1Z1-083サンプル問題で100%カバー率のリアル試験問題（更新された283問あります)

今すぐダウンロード！リアルOracle 1Z1-083試験問題集テストエンジン試験問題

質問 # 70
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

A. The Data Recovery Advisor change failure command can be used only to change failure priorities.
B. Data Recovery Advisor can proactively check for failures.
C. A failure can be closed only when it has been repaired.
D. Data Recovery Advisor can be used if a database is closed.
E. Using the Data Recovery Advisor list failure command always requires that the database for which failures are to be listed is in mount state.

正解：B、D

質問 # 71
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 to a patched Oracle Database home
B. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
C. to switch to a read-only Oracle home
D. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
E. to switch back to the previous Oracle home as part of a rollback operation

正解：A、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.

質問 # 72
Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true?

A. Data file 24 can be recovered while PDB2 is opened.
B. Data file 24 can be recovered while CDB$ROOTand PDB$SEED are opened.
C. Data file 24 must be recovered while PDB2 is closed.
D. Data file 24 must be recovered while the CDB is opened.
E. Data file 24 cannot be recovered while the CDB is opened.

正解：A、D

質問 # 73
Which three are true about SGA memory management in a multitenant database? (Choose three.)

A. SGA_MIN_SIZE cannot be set for a PDB.
B. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
C. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
D. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
E. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
F. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.

正解：A、D、E

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

A. Stateless alerts can be purged manually from the alert history.
B. Stateless alerts can be cleared manually.
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.

正解：B、D

解説：
Explanation/Reference: https://jameshuangsj.wordpress.com/2019/12/01/clears-stateless-alerts-in-oem-by-using-emcli/

質問 # 75
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 an existing Oracle Database home to a newer release of Oracle software on the same server
C. to switch back to the previous Oracle home as part of a rollback operation
D. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
E. to switch to a patched Oracle Database home

正解：A、D

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

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

正解：B、C

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

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

正解：A、E

質問 # 78
Which three statements are true about the keystore storage framework for transparent data encryption?

A. It facilitates and helps to enforce keystore backup requirements.
B. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.
C. It handles encrypted data without modifying applications.
D. It transparently decrypts data for the database users and applications that access this data.
E. It enables a keystore to be stored only in a file on a file system.
F. It enables separation of duties between the database administrator and the security administrator.

正解：A、B、F

質問 # 79
Which two are true about instance recovery? (Choose two.)

A. It is performed automatically while the database remains in MOUNT state. Then the database is opened.
B. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
C. It is performed by the Recovery Writer (RVWR) background process.
D. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
E. It is not possible if an archived log is missing.
F. Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing The log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

正解：A、D

質問 # 80
Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

A. CDB$ROOT is in MOUNT state.
B. PDB$SEED is in READ ONLY state.
C. Redo logs are opened.
D. PDB1 and PDB2 are in MOUNT state.
E. PDB1 and PDB2 are in READ ONLY state.

正解：A、D

質問 # 81
You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)

A. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
B. All files in any previous FRA that have not yet been backed up, are backed up.
C. All files in any previous FRA that have been backed up already, are backed up.
D. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
E. All files in the current FRA that have been backed up already, are backed up.
F. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.
G. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.

正解：A、D、G

解説：
By default BACKUP RECOVERY AREA ; command enables backup optimization (do not backup files which are already backed up and not changed since last backup) with FORCE clause backup optimization OFF, i.e. backup oracle all recovery files from current FRA and all Previous FRA whether they are previously backed up or not backed up.

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

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

正解：A、B、D

質問 # 83
Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

A. It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.
B. It creates a full export of the root
C. It creates a full export of the root
D. It fails because Data Pump cannot be container.

正解：D

質問 # 84
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$SESSION_WAIT_CLASS
B. V$SESSION_WAIT
C. V$SESSION
D. V$SESSION_EVENT
E. V$SESSTAT

正解：D

解説：
The V$SESSION_EVENT view provides summary of all the events the session has waited for since it started.

質問 # 85
Choose three. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?

A. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
B. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
C. opening the cloned PDB
D. automatically dropping the database link to the remote database if it already exists
E. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
F. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
G. creating a new empty PDB in the local database from PDB$SEED

正解：A、B、D

質問 # 86
Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
3. PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully: Which two are true? (Choose two.)

A. Uncommitted transactions in PDB1 have been rolled back.
B. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
C. CDB1 is in MOUNT state
D. CDB1 is shut down.
E. PDB1 is closed.

正解：A、E

質問 # 87
Choose three. Which three are true about a container database (CDB)?

A. It contains predefined common roles in both the root and the seed.
B. It can have local users with the same name in different PDBs.
C. It can contain only one PDB$SEED, which is created when the CDB is created.
D. It can have any number of pluggable databases (PDBs) limited only by space availability.
E. It can be created from a non-CDB.
F. It can be created by cloning an existing CDB.
G. It can contain only one Application Container seed, which is created when the Application Container is created.

正解：A、C、F

質問 # 88
The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace?
(Choose two.)

A. Backups can be taken only if the database is in ARCHIVELOG mode.
B. Backups must be contained in backup sets.
C. Backups can be done incrementally.
D. The database must be registered in an RMAN catalog.
E. Only consistent backups can be created.
F. Backups must be done incrementally.

正解：A、C

解説：
A - FALSE. It CAN be done incrementally, not MUST
B - FALSE. They CAN be contained in backup sets, not MUST
C - TRUE. By definition, you can only take online backups in ARCHIVELOG mode D - TRUE. Yes, they CAN be done incrementally. They don't have to be.
E - FALSE. You CAN register in an RMAN catalog, you don't have to
F - FALSE. An online backup is INCONSISTENT.

質問 # 89
Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

A. They can optionally be written to a fast recovery area (FRA).
B. The SPFILE is included in the archival backup.
C. They are never considered obsolete by RMAN.
D. All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.
E. Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
F. Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

正解：B、F

質問 # 90
A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required?

A. CDB2 must be in archivelog mode.
B. CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.
C. CDB1 and CDB2 must be in shared UNDO mode.
D. CDB1 and CDB2 must both be in local UNDO mode.
E. CDB2 must be in shared UNDO mode only.
F. CDB1 must be in archivelog mode.

正解：A、D、F

質問 # 91
Which two are true about gathering optimizer statistics? (Choose two.)

A. System statistics can be gathered only while connected to CDB$ROOT.
B. Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics only in CDB$ROOT.
C. Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics in all open pluggable databases (PDBs)
D. Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to a PDB opened in read/write mode gathers object statistics for that PDB.
E. Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics in all open PDBs except PDB$SEED.

正解：B、C

解説：
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/20/arpls/DBMS_STATS.html

質問 # 92
......

最新1Z1-083テスト問題集を試そう！更新されたOracle試験が合格できます：https://jp.fast2test.com/1Z1-083-premium-file.html