無料セールまもなく終了！100%有効1Z0-083試験問題集に283問題と解答が待ってます
検証済み1Z0-083問題集と解答であなたを合格確定させるOracle Database 19c試験解答！
質問 # 116
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?
- A. by creating a new database in the new host, and then using the RMAN recover command
- B. by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host
- C. by using the RMAN switch command to set the new location for the data files
- D. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
正解：D
質問 # 117
Choose two. Which two are true about the SQL Tuning Advisor?
- A. It prevents performance regressions for SQL statements when changes are made.
- B. It only recommends syntactic changes to SQL statements.
- C. It considers all SQL statements being analyzed by the advisor task as a group.
- D. It can recommend semantic changes to SQL statements.
- E. It checks each query being analyzed for missing or stale statistics.
正解：D、E
質問 # 118
Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS);
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY- MM-DD HH:MI:SS);
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customer FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
- A. 2,3,5,6
- B. 1,3,6
- C. 3,4,5
- D. 1,2,5
正解：D
質問 # 119
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? (Choose two.)
- A. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
- B. Data file 24 cannot be recovered while the CDB is opened.
- C. Data file 24 must be recovered while the CDB is opened.
- D. Data file 24 can be recovered while PDB2 is opened.
- E. Data file 24 must be recovered while PDB2 is closed.
正解：C、D
解説：
Explanation
19c: PDB SYSTEM or UNDO Tablespace Recovery: The CDB and all other PDBs can be left opened. 1.
Connect to PDB 2. Shutdown abort the PDB, if its not automatically done. sqlplus sys@sales_pdb as sysdba sql> SHUTDOWN ABORT; OR ALTER PLUGGABLE DATABASE CLOSE ABORT; rman target sys@slaes_pdb rman> restore database; rman> recover database; rman> alter pluggable database sales_pdb open;
質問 # 120
Which two are true about automatic block repair? (Choose two.)
- A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
- B. It is not possible for media corrupt blocks.
- C. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
- D. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
- E. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
正解：C、D
解説：
You can use an Oracle Active Data Guard standby database for automatic repair of data corruptions detected by the primary database. Additionally if the corruption is discovered on an Active Data Guard physical standby database the corruption will be automatically repaired with a good block from the Primary.
質問 # 121
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)
- A. It is always possible for RMAN to connect to a pluggable database as a target.
- B. A Virtual Private Catalog used to register a container database can be created in a non-container database.
- C. A Virtual Private Catalog used to registera container database can be created in a pluggable database.
- D. It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
- E. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
- F. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
正解：A、B、C
質問 # 122
Choose three. Which three are true about the Oracle Optimizer?
- A. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
- B. It obeys all hints.
- C. It considers the filters in WHERE clauses when generating execution plans for SQL statements.
- D. It can re-optimize execution plans after previous executions detect suboptimal plans.
- E. It considers object statistics when generating execution plans for SQL statements.
- F. It updates stale object statistics in the Data Dictionary.
正解：C、D、F
質問 # 123
RMAN has just been connected to a target database and the recovery catalog database.
In which two cases would an automatic partial resynchronization occur between this target database's control file and the RMAN recovery catalog?
- A. When any control file metadata for archive log backups or image copies is now older than CONTROL_FILE_RECORD_KEEP_TIME.
- B. When the target is first registered.
- C. When any control file metadata for data file backups or image copies is now older than CONTROL_FILE_RECORD_KEEP_TIME.
- D. When a backup of the current SPFILE is created.
- E. When a new data file is added to a tablespace in a registered target database.
正解：B、E
解説：
In a full resynchronization, RMAN updates all changed records, including those for the database schema. RMAN performs a full resynchronization after structural changes to database (adding or dropping database files, creating new incarnation, and so on) or after changes to the RMAN persistent configuration.
When a database is registered with a recovery catalog for the first time a full catalog synchronization is performed
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery- catalog.html#GUID-6B077FE7-8E10-4603-8FDB-CAE3357E85C9
質問 # 124
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? (Choose two.)
- A. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
- B. Data file 24 cannot be recovered while the CDB is opened.
- C. Data file 24 must be recovered while PDB2 is closed.
19c: PDB SYSTEM or UNDO Tablespace Recovery: The CDB and all other PDBs can be left opened. 1. Connect to PDB 2. Shutdown abort the PDB, if its not automatically done. sqlplus sys@sales_pdb as sysdba sql> SHUTDOWN ABORT; OR ALTER PLUGGABLE DATABASE CLOSE ABORT; rman target sys@slaes_pdb rman> restore database; rman> recover database; rman> alter pluggable database sales_pdb open; - D. Data file 24 must be recovered while the CDB is opened.
- E. Data file 24 can be recovered while PDB2 is opened.
正解：D、E
質問 # 125
Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- A. using the KEEP FOREVER clause with the BACKUP command
- B. using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past
- C. using the REPORT SCHEMA command to list a database's current data files and tablespaces
- D. creating encrypted backups
- E. creating customized reports about a single database's backups
- F. using RMAN stored scripts
正解：A、B、F
質問 # 126
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:
Which two are true? (Choose two.)
- A. oracle will be granted the SYSASM privilege when installing the Oracle Database software.
- B. oracle will be an owner of the Oracle Inventory.
- C. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
- D. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.
- E. oracle must be the owner of every Oracle Database installation.
正解：B、C
解説：
The SYSASM Privilege for Administering Oracle ASM
SYSASM is a system privilege that enables the separation of the SYSDBA database administration privilege from the Oracle ASM storage administration privilege. Access to the SYSASM privilege is granted by membership in an operating system group that is designated as the OSASM group. This is similar to SYSDBA and SYSOPER privileges, which are system privileges granted through membership in the groups designated as the OSDBA and OSOPER operating system groups. You can designate one group for all of these system privileges, or you can designate separate groups for each operating system privilege.
質問 # 127
Choose two. You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 . CDB1 user SYS executes these commands after connecting successfully to PDB2: SQL> ALTER SESSION SET CONTAINER=pdb1; Session altered. SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ; 1 row created. SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ; 1 row created. SQL> ALTER SESSION SET CONTAINER=pdb2; Session altered. SQL> INSERT INTO user2.dept VALUES(1, 'IT'); Which two are true? Which two are true? (Choose two.)
- A. The inserts on USER1.EMP were rolled back when the session connected to PDB2
- B. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
- C. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
- D. The insert on USER2.DEPT is uncommitted.
- E. The insert on USER2.DEPT fails because of the active transaction in the parent container.
- F. The inserts on USER1.EMP were committed when the session inserted a row into USER2. DEPT.
- G. The inserts on USER1.EMP were committed when the session connected to PDB2.
正解：B、E
質問 # 128
You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy?
- A. RMAN backups that are obsolete
- B. flashback logs
- C. archived redo log files that have multiple copies in a different archive location
- D. user-managed backups of data files and control files
正解：A、B
質問 # 129
Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)
- A. It requires Oracle Automatic Storage Management (ASM) components to be installed separately.
- B. It must be installed before the Oracle database software is installed.
- C. It supports volume management, file system, and automatic restart capabilities.
- D. It can manage database resources on the server where it is installed or on a different server.
- E. The CSS daemon runs from the Grid Infrastructure home.
正解：B、C
質問 # 130
choose two Which two are true about RMAN image copies?
- A. They can be used as a level 1 incremental backup.
- B. They are the only backup option available for databases in NOARCHIVELOG mode.
- C. They can be encrypted using Transparent Data Encryption (TDE).
- D. They can only be written to disk.
- E. They can be used as a level 0 incremental backup.
正解：D、E
質問 # 131
In which two situations can you use Database Upgrade Assistant? (Choose two.)
- A. when the operating system (OS) needs to be changed as part of the upgrade
- B. when a character set conversion is required during the upgrade
- C. when multiple pluggable databases in a container database have to be upgraded in a specific sequence
- D. when the hardware platform needs to be changed as part of the upgrade
- E. when the target and source database are on the same platform
正解：C、E
質問 # 132
A database is configured in ARCHIVE LOG 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 members of the CURRENT online redo log group
- B. after losing an UNDO tablespace that is in use
- C. after losing a SYSAUX tablespace data file
- D. after losing all copies of the control file
- E. after losing all members of an INACTIVE online redo log group
正解：A、D
質問 # 133
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. PDB1 and PDB2 are in MOUNT state.
- D. PDB1 and PDB2 are in READ ONLY state.
- E. Redo logs are opened.
正解：A、C
質問 # 134
Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------------------------------------------------------------2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?
- A. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
- B. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
- C. Only CDB$ROOT and PDB$SEED are upgraded.
- D. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
- E. It fails because PDB$SEED is in MIGRATE state.
- F. It fails because PDB2 is not in UPGRADE state.
正解：F
質問 # 135
Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?
- A. RANDOM redaction is active on the HIREDATE column
- B. PARTIAL redaction is active on the MGR column.
- C. RANDOM redaction is active on the MGR column
- D. PARTIAL redaction is active of the HIREDATE column.
- E. FULL redaction is active on the SAL column
正解：A
質問 # 136
Which two are true about RMAN duplexed backup sets?
- A. A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.
- B. A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.
- C. A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.
- D. A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.
- E. A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.
- F. A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.
正解：B、F
質問 # 137
Which two are true about the Oracle dataabsemethodology? (Choose two.)
- A. Tuning activities should stop once the user is satisfied with performance.
- B. SQL statements should always be tuned before tuning any file systems.
- C. The alert log should be used to find the database and instance areas most in need of tuning.
- D. The database instance memory should always be tuned before tuning any file systems.
- E. Tuning activities should stop onceagreed service levels for performance have been met.
- F. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
正解：C、E
質問 # 138
......
Oracle 1Z0-083試験は、120分以内に完了する必要のある83個の多肢選択問題からなります。試験は、データベースアーキテクチャ、バックアップおよびリカバリ、パフォーマンスチューニング、セキュリティ、および高可用性など、幅広いトピックをカバーしています。試験は、データベース管理の経験を持ち、既にOracle Database Administration I試験を合格している専門家を対象としています。
1Z0-083試験問題集で100%合格率1Z0-083試験：https://jp.fast2test.com/1Z0-083-premium-file.html
試験問題集リアルOracle Database 19c問題集283問題と解答が待ってますを試そう：https://drive.google.com/open?id=1tUp_ronk46UUlXPlcT7kNC5nJjaJ5F76