1z0-083 Free Practice Test

Which two are true about server-generated alerts? (Choose two.)

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

Correct Answer: BC
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.

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

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

Correct Answer: BCD

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

1. A. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.
2. B. Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.
3. C. A new PDB is automatically created when importing a non-CDB into a CDB.
4. D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
5. E. Moving data from a PDB to anon-CDB is only possible by using transportable tablespace export and import.
6. F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Correct Answer: DE

Which four are true about a Recovery Manager (RMAN)duplication without a TARGET connection? (Choose four.)

1. A. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
2. B. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
3. C. RMAN “pushes” the backups of the database to be duplicated over the network to the auxiliary instance.
4. D. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database wasin ARCHIVELOG mode.
5. E. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
6. F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
7. G. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
8. H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Correct Answer: ABGH

Which three are true about transporting databases across platforms usingRecovery Manager (RMAN) image copies? (Choose three.)

1. A. By default, the transported database will use Oracle Managed Files (OMF)
2. B. Data files can be converted on the destination system.
3. C. Data files can be converted on the source system.
4. D. A new DBIDis automatically created for the transported database.
5. E. Databases can be transported between systems with different endian formats.
6. F. The password file is automatically converted by RMAN.

Correct Answer: BCE
Password file is automatically converted by RMAN.