合格させるOracle 1Z0-083にはPassTest提供の試験問題集で2024年09月更新 [Q133-Q148]

新問題 133
Which three are true about monitoring waits for sessions and services? (Choose three.)

V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

新問題 134
Which three are true about performing an Oracle Database install on Linux? (Choose three.)

The runfixup.sh script can install missing RPMs.

The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

It allows you to select the languages supported by the Oracle database server.

It can be done before installing Grid Infrastructure for a Standalone Server.

The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

It can be done after installing Grid Infrastructure for a Standalone Server.

The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.

新問題 135
Which three are true about managing memory components in an Oracle database instance?
(Choose three.)

With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

Automatic Memory Management must be used together with locking the System Global Area into physical memory.

With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

新問題 136
Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)

The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

Flashback commands help with repairing physical errors.

RMAN can always repair corrupt blocks.

The ADR can store metadata in an Oracle Database repository.

The Data Recovery Advisor uses the ADR.

新問題 137
A database is configured in ARCHIVELOG 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.)

after losing a SYSAUX tablespace data file

after losing all members of an INACTIVE online redo log group

after losing all members of the CURRENT online redo log group

after losing all copies of the control file

after losing an UNDO tablespace that is in use

新問題 138
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true? (Choose three.)

Application PDBs that are subsequently created in the APP1application container will be cloned from APP1$SEED.

An application seed PDB is created for APP1.

An application root PDB is created for APP1.

A default service is created for the application root APP1.

Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

APP1can never be unplugged.

新問題 139
Which two are true about RMAN encryption? (Choose two.)

RMAN encryption keys are stored in a database keystore.

RMAN can encrypt the Oracle Database password file.

Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.

The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.

Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

新問題 140
Which three are true about an application seed pluggable database (PDB)? (Choose three.)

It is automatically synchronized with its application root PDB when an application is upgraded.

It cannot be added to an application container after the application container has already been created.

A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

It is automatically synchronized with its application root PDB when an application is installed.

It cannot be dropped from its application container.

A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

It is not required in an application container.

新問題 141
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.)

oracle will be an owner of the Oracle Inventory.

oracle must be the owner of every Oracle Database installation.

oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

oracle will be granted the SYSASM privilege when installing the Oracle Database software.

The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

新問題 142
Which two are true about the Oracle database tuning methodology?

The database instance memory should always be tuned before tuning any file systems.

Tuning activities should stop once the user is satisfied with performance.

The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

SQL statements should always be tuned before tuning any file systems.

Tuning activities should stop once agreed service levels for performance have been met.

The alert log should be used to find the database and instance areas most in need of tuning.

新問題 143
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?

CDB1, PDB$SEED, PDB1, and PDB2

PDB$SEED, PDB1, and PDB2only

CDB1and PDB$SEEDonly

CDB1, PDB1, and PDB2only

CDB1, PDB$SEED, and PDB1 only

新問題 144
Which three are true about backing up the control file?

It cannot be backed up manually as a binary copy.

It gets backed up automatically by RMAN as a trace file containing SQL statements for control file recreation when a database backup occurs.

It can be backed up manually as a binary copy.

It can get backed up automatically as a binary copy.

It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.

It can be backed up manually as a trace file containing SQL statements for control file recreation.

新問題 145
You have configured RMAN SBT channels to write backups to medi
a. You then take an RMAN backup by using this command: Which three are true? (Choose three.)

The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

All archive logs created after this backup are kept for two years.

The SPFILE is included in the self-contaied archival backup.

The control file is included in the self-contained archival backup.

The restore point is a label for the system change number (SCN) before the archival backup was taken.

新問題 146
Which two are true about instance recovery?

It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

It is performed by the Recovery Writer (rvwr) background process.

It is performed automatically while the database remains in mount state. Then the database is opened.

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.

It is not possible if an archived log is missing.

Setting fast_start_mttr_target to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.

新問題 147
Which two are true about instance recovery? (Choose two.)

It is not possible if an archived log is missing.

It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

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.

It is performed by the Recovery Writer (RVWR) background process.

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.

It is performed automatically while the database remains in MOUNT state. Then the database is opened.

新問題 148
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the dataabse be in the MOUNT state.

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.

An Oracle database can be restored from backup files copied using O/S utilities.

Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.

Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.

Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

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.

合格させるOracle 1Z0-083にはPassTest提供の試験問題集で2024年09月更新 [Q133-Q148]

コメントを残すコメントをキャンセル

1Z0-083練習テスト

関連認証

最近の投稿

アーカイブ

カテゴリー

合格させるOracle 1Z0-083にはPassTest提供の試験問題集で2024年09月更新 [Q133-Q148]

コメントを残す コメントをキャンセル

1Z0-083練習テスト

関連認証

最近の投稿

アーカイブ

カテゴリー

コメントを残すコメントをキャンセル