正真正銘の1Z0-083問題集には100%合格率練習テスト問題集 [Q58-Q78]

正真正銘の1Z0-083問題集には100%合格率練習テスト問題集

Oracle 1Z0-083リアル試験問題保証付き更新された問題集

質問 # 58
Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?

A. 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. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F
C. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
D. 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.
E. If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

正解：A、D、E

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

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

正解：C、E

解説：
Explanation
Except for the tablespace space usage metric, which is database related, the other metrics are instance related.
Threshold alerts are also referred to as stateful alerts which are automatically cleared when an alert condition clears. Stateful alert appears in DBA_OUTSTANDING_ALERTS and when cleared go to DBA_ALERT_HISTORY. Other server-generated alerts correspond to specific database events such as ORA-* errors, "Snapshot too old" errors, Recovery Area Low on Free Space, Resumable Session Suspended.
These are non threshold based alerts, also referred to as stateless alerts. Stateless alerts go directly to the History table. +++ Most alerts (such as "Out of Space") are cleared automatically when the cause of the problem disappears. However, other alerts (such as generic alert log errors) are sent to you for notification and must be acknowledged by you. After taking the corrective measures, you acknowledge an alert by clearing or purging it. Clearing an alert sends the alert to the Alert History which is accessible from Monitoring sub menu.
Purging an alert removes it from the Alert History.

質問 # 60
Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

A. Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)
B. Enable only OMF.
C. Addonly the CREATE_FILE_DEST clause to the statement.
D. Set only the PDB_FILE_NAME_CONVERT parameter.
E. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
F. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

正解：B、C、F

質問 # 61
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?

A. The root password cannot be specified in a response file.
B. root.sh can be executed automatically by the Database installer only if it is provided with root credentials.
C. The sudo password must be specified in a response file.
D. root.sh can be executed automatically by the Database installer only by using sudo credentials.
E. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
F. The sudo password can be specified in a response file.

正解：B、F

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

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

正解：A、F、G

解説：
A, E sparse / full depending on storage
D - no configuration required:
https://docs.oracle.com/en/database/oracle/oracle-database/19/duplicate-cdbs-using-dbca-silent- mode/index.html

質問 # 63
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

A. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
B. Undo tablespaces existing in PDBs must be dropped before the change.
C. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
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、E

解説：
Explanation
You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property. When the database property LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO tablespace that is created in the CDB root, and that is shared by all containers. When LOCAL_UNDO_ENABLE is TRUE, every container in the CDB uses local undo and each PDB must have its own local UNDO tablespace. To maintain ease of management and provisioning, UNDO tablespace creation happens automatically and does not require any action from the user. When a PDB is opened and an UNDO tablespace is not available, its automatically created.

質問 # 64
Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
(Choose three.)

A. They can view data from any user-defined tables.
B. They can drop any tablespace.
C. They can create any table.
D. They can view data from any data dictionary view or dynamic performance view.
E. They cannot create restore points.
F. They cannot drop tablespaces.

正解：C、F

質問 # 65
Which three are true about the SQL Tuning Advisor? (Choose three.)

A. It considers all SQL statements being analyzed by the advisor task as a group.
B. It only recommends syntactic changes to SQL statements.
C. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
D. It checks each query being analyzed for missing statistics.
E. It can recommend semantic changes to SQL statements.
F. It checks each query being analyzed for stale statistics.

正解：C、D、F

質問 # 66
Which three are true about requirements for various FLASHBACK operations? (Choose three.)

A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
B. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
C. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
D. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
E. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
F. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

正解：A、C、F

解説：
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm#ADMIN01511 When you drop a table, the database does not immediately remove the space associated with the table. The database renames the table and places it and any associated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time. This feature is called Flashback Drop, and the FLASHBACK TABLE statement is used to restore the table.

質問 # 67
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 can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.
C. oracle must be the owner of every Oracle Database installation.
D. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
E. oracle will be an owner of the Oracle Inventory.

正解：A、B

質問 # 68
Examine this configuration:
1. CDB1is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
2. PDB$SEEDis open READ ONLY
3. PDB1is open READ WRITE
4. PDB2 is MOUNTED.
5. ORACLE_HOMEis /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

A. PDB$SEED, PDB1, and PDB2only
B. CDB1, PDB$SEED, PDB1, and PDB2
C. CDB1, PDB1, and PDB2only
D. CDB1and PDB$SEEDonly
E. CDB1, PDB$SEED, and PDB1 only

正解：E

質問 # 69
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true?

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

正解：C、D

質問 # 70
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

A. The number of table rows is considered when evaluating the cost of accessing a table 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. Index balanced B*Tree height is considered when evaluating the cost of using an index.
E. Statistics collected using DBMS_STATS always yield the best optimizer result.

正解：C、D

質問 # 71
Which two are true about a Recovery Manager (RMAN) duplication without a target connection?

A. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
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 target instance.
D. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
E. The undo tablespace clause is always required when no connection exists to the recovery catalog and the target database is closed.

正解：A、E

質問 # 72
Choose one You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

A. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.
B. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.
C. Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump.
D. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

正解：B

質問 # 73
Which three are true about Optimizer Statistics Advisor? (Choose three.)

A. It can recommend changes to improve the statistics gathering process.
B. It can be run only manually.
C. It is part of the DBMS_ADVISOR package.
D. It runs automatically every night by default.
E. It always analyzes all schemas in the database.
F. It is part of the DBMS_STATS package.

正解：A、E、F

質問 # 74
Which three are true about cloning databases into an existing CDB with RMAN?

A. Two or more PDBs can be cloned with the same command.
B. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.
C. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.
D. The target and auxiliary instance passwords must be the same.
E. Only one PDB can be cloned at a time.
F. A non-CDB can be cloned into a PDB.

正解：B、C、E

質問 # 75
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

A. relocating a remote pluggable database in silent mode
B. relocating a remote container database in silent mode
C. relocating a remote pluggable database in interactive mode
D. cloning a remote container database in interactive mode
E. cloning a remote pluggable database in silent mode
F. cloning a remote container database in silent mode
G. relocating a remote container database in interactive mode

正解：A、E、F

解説：
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/clone-pdbs-using-dbca-silent- mode/index.html? learningpath=true&appuser=nobody&appsession=170971049395&contentid=26693&activityname=Clone% 20PDBs%20using%20DBCA%20in%20Silent%20Mode&eventid=6352

質問 # 76
Which two are true about the Oracle database methodology? (Choose two.)

A. Tuning activities should stop once agreed service levels for performance have been met.
B. The alert log should be used to find the database and instance areas most in need of tuning.
C. Tuning activities should stop once the user is satisfied with performance.
D. SQL statements should always be tuned before tuning any file systems.
E. The database instance memory should always be tuned before tuning any file systems.
F. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

正解：D、F

解説：
A is correct. It will show what the database is spending most time on, that (usually) indicates where tuning is required.
B and C relate to user experience. We (DBAs) should work with users, to help achieve their requirements. However, we can be proactive outside of this. Just because a user is happy - doesn't mean we can't make them "happier" by doing tuning activities before things get bad. So, neither of these should be true.
D is incorrect, memory is much less likely to be a culprit of an issue, than a filesystem I/O issue.
E is correct. We should never try to tune a file system first. If we make a file system change that fixes one SQL statement - it might harm a different SQL statement. However, if we tune the first SQL statement, it will have no impact on the rest of the system. Therefore, we should try to tune
"bad SQL" first.
F is incorrect - the alert log gives us little/no information to do with tuning.

質問 # 77
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

A. An Oracle database can be restored from backup files copied using O/S utilities.
B. Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
C. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
D. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance bestarted and the dataabse be in the MOUNT state.
F. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
G. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.

正解：D、F、G

質問 # 78
......

検証済み！合格できる1Z0-083試験一発合格保証付き：https://www.goshiken.com/Oracle/1Z0-083-mondaishu.html

無料1Z0-083サンプル問題と 100%カバー率でリアル試験問題：https://drive.google.com/open?id=1AM7Ponn5uC-GNYgevVY498FuHAbXSlEA

関するブログ

もっと

1Z0-083無料問題集