1Z0-083試験問題集合格させるのは2022年最新の認証済み試験問題 [Q37-Q60]

1Z0-083試験問題集合格させるのは2022年最新の認証済み試験問題

1Z0-083試験問題でリアルに更新された問題PDF

質問 37
The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3.
Which three are true? (Choose three.)

A. A database link must exist in the local CDB root referring to the remote CDB.
B. A proxy PDB must exist in the application root in the remote CDB.
C. PDB3's application root replica must exist in the local CDB.
D. A database link must exist in the remote CDB referring to the local CDB.
E. The HR_ROOT replica must exist in the remote CDB.
F. A proxy PDB must exist in the application root in the local CDB.

正解: D,E,F

質問 38
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
(Choose two.)

A. SQL statements doing only logical reads never require tuning because they do no physical I/O.
B. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
C. The solution that best optimizes one SQL statement can degrade the performance of others.
D. SQL statements doing joins always do more physical I/O than single table queries.
E. Poorly performing SQL statements can be tuned automatically by the Oracle server.

正解: A,E

質問 39
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true?

A. An application seed PDB Is created for APP1.
B. APP1 can never be unplugged.
C. An application root PDB is created for APP1.
D. A default service Is created for the application root 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.

正解: C,D,E

質問 40
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. P1_USER1 can be created in CDB1.
B. APP1_USER1 can be created in CDB1.
C. C##_APP_USER1 can be created in CDB1.
D. APP1_USER1 can be created in PDB1.
E. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

正解: E,F

質問 41
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

A. A target database's persistent RMAN configuration settings are always stored in the target's control file
B. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
C. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
D. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
E. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
F. The RMAN SHOW ALL command displays only settings with nondefault values.
G. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

正解: A,E,G

解説:
Reference:
https://books.google.com.pk/books? id=pUEkAAAAQBAJ&pg=PA114&lpg=PA114&dq=V$RMAN_CONFIGURATION+view+displays+only+settings
+with+values+that+have+been+modified&source=bl&ots=fhC9A7ULeX&sig=ACfU3U2- cGhTjmAOpCZhvlL5R4j6ixLRAw&hl=en&sa=X&ved=2ahUKEwjJzf- WmtnoAhXT8eAKHQ9uBG8Q6AEwAHoECAwQJg#v=onepage&q=V%24RMAN_CONFIGURATION%20view
%20displays%20only%20settings%20with%20values%20that%20have%20been%20modified&f=false

質問 42
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

A. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
B. It provides before and after execution statistics for each SQL statement in the analysis task
C. It is integrated with the SQL Access Advisor.
D. SQL statements that were originally run concurrently are run concurrently by SPA.
E. It predicts the impact of system changes on SQL workload response time.

正解: A,E

解説:
Explanation/Reference: https://www.oracle.com/technetwork/database/manageability/spa-ow09-131455.pdf (4)

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

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

正解: C,E,G,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).

質問 44
RMAN has just been connected to a target database and the recovery catalog database.
In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog? (Choose two.)

A. when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
B. when the target is first registered
C. when a new tablespace is added to a registered target database
D. when a backup of the current control file is created
E. when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

正解: A,D

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

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

正解: C,E,F,G

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

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

正解: A,E

質問 47
Which two are true about changing the LOCAL_UNDO_ENABLEDproperty to false in a CDB? (Choose two.)

A. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
B. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
C. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
D. Undo tablespaces existing in PDBs must be dropped before the change.
E. After the change, only one undo tablespace can exist in CDB$ROOT.
F. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

正解: C,F

解説:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/creating-and-configuring-a- cdb.html#GUID-12ADA04D-F81D-4579-A68C-0958CC7D6C2F

質問 48
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?

A. The maptable table is a metadata-linked table.
B. The revenue table partitions are not pruned across the PDBs automatically.
C. The containers clause cannot be used in queries on the revenue table.
D. The revenue table must be a list-partitioned table.
E. The maptable table defines a logical partition key on a commonly used column for the revenue table.
F. A container map exists for the revenue table, but Is not enabled.

正解: A,F

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

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

正解: A,C,D

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

質問 50
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)

A. orainstRoot.shcan be executed automatically by the Database installer by using sudoor root credentials.
B. The sudopassword must be specified in a response file.
C. The sudopassword can be specified in a response file.
D. root.shcan be executed automatically by the Database installer only by using sudocredentials.
E. root.shcan be executed automatically by the Database Installer only if it is provided with root credentials.
F. The rootpassword cannot be specified in a response file.

正解: A,F

解説:
Explanation

質問 51
Which operating system group is NOT needed to perform an Oracle Database installation?

A. OSOPER
B. OSASM
C. OSDBA
D. OSKMDBA
E. OSRACDBA

正解: E

質問 52
Which three are true about using Database Resource Manager in an Oracle multitenant environment?
(Choose three.)

A. A CDB-level resource plan can limit PDB UNDO use.
B. A CDB-level resource plan can limit PDB CPU utilization.
C. A CDB-level resource plan is mandatory when using PDB-level resource plans.
D. A PDB-level resource plan can limit session PGA memory.
E. A CDB-level resource plan can limit session CPU utilization.
F. PDB-level resource plans can limit uncommitted UNDO per consumer group.

正解: A,C,E

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

正解: C,E

質問 54
Which two are true about Oracle Optimizer Statistics, their use, and their collection?

A. Index balanced B*Tree height is considered when evaluating the cost of using an index,
B. The Statistics Advisor generates actions for all recommendations.
C. The Statistics Advisor can help recommend the best way to gather statistics.
D. Statistics collected using DBMS_ATATS always yield the best optimizer result.
E. The number of table rows is considered when evaluating the cost of accessing a table using an index.

正解: B,E

質問 55
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

正解: A

質問 56
Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle
19c and later releases? (Choose three.)

A. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
B. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
C. A PDB snapshot can be a full copy of a source PDB.
D. A PDB snapshot depends on an existing storage snapshot of the source PDB.
E. A PDB snapshot can be a sparse copy of a source PDB.
F. A snapshot copy PDB can be a full copy of a source PDB.
G. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.

正解: D,E,F

質問 57
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

A. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
B. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
C. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
D. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
E. CDB$ROOT and PDB$SEED are automatically duplicated.

正解: D,E

質問 58
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)

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

正解: B,D

解説:
Explanation/Reference:

質問 59
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.)