1Z0-083模擬解説集、1Z0-083資格参考書1Z0-083認定試験を受験したいですか。1Z0-083認証資格を取得したいですか。試験に準備する時間が足りないあなたは、どうやって試験に合格できますか。しようがないわけではないです。短時間の準備でも楽に試験に合格することができるようになりますよ。それでは、どのようにすればそれを達成できますか。実は方法がとても簡単です。すなわちJPTestKingの1Z0-083問題集を利用して試験の準備をすることです。 Oracle Database Administration II 認定 1Z0-083 試験問題 (Q219-Q224):質問 # 219
Which two are true about server-generated alerts? (Choose two.)
A. Stateless alerts can be cleared manually.
B. Stateful alerts must be created by a DBA after resolving the problem.
C. Stateful alerts are purged automatically from the alert history.
D. Stateless alerts can be purged manually from the alert history.
E. Stateless alerts are automatically cleared.
正解:A、D
解説:
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.
質問 # 220
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
A. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
B. The solution that best optimizes one SQL statement can degrade the performance of others.
C. Poorly performing SQL statements can be tuned automatically by the Oracle server.
D. SQL statements doing only logical reads never require tuning because they do no physical I/O.
E. SQL statements doing joins always do more physical I/O than single table queries.
正解:B、C
質問 # 221
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
A. The RMAN SHOW ALL command displays only settings with nondefault values.
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. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
E. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
F. A target database's persistent RMAN configuration settings are always stored in the target's control file
G. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
正解:D、F、G
質問 # 222
Which two are true about RMAN image copies?
A. They can be used as a level 1 incremental backup.
B. They can be encrypted using Transparent Data Encryption (TDE).
C. They can only be written to disk.
D. They can be used as a level 0 incremental backup.
E. They are the only backup option available for databases in NOARCHIVELOG mode.
正解:C、D
質問 # 223
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. root.shcan be executed automatically by the Database installer only by using sudocredentials.
C. The rootpassword cannot be specified in a response file.
D. The sudopassword can be specified in a response file.
E. The sudopassword must be specified in a response file.
F. root.shcan be executed automatically by the Database Installer only if it is provided with root credentials.