[Dec-2021] Oracle Database 19c 1Z0-083 Exam Practice Dumps
2021 1Z0-083 Premium Files Test pdf - Free Dumps Collection
Exam Topic for Oracle Database Administration II Exam Number: 1Z0-083
The following will be discussed in ORACLE 1Z0-083 exam dumps:
- Backup Strategies and Terminology
- Recovery and Flashback
- Backup and Duplicate
- Diagnosing Failures
- Manage Application PDBs
- Duplicating a Database
- Transporting Data
- Using Flashback Technologies
- Creating CDBs and Regular PDBs
- Restore and Recovery Concepts
- Install Grid Infrastructure and Oracle Database
How to book the Oracle Database Administration II Exam Number: 1Z0-083
You can schedule the exam anytime at Pearson VUE. You can pay directly from a credit card or redeem a voucher purchased from Oracle.
NEW QUESTION 74
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
- A. to exclude a temp tablespace when plugging in a PDB
- B. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
- C. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
- D. to specify the list of tablespaces to include when creating a PDB from the CDB seed
- E. to include specific user tablespaces only when relocating a PDB
- F. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
Answer: A,D
NEW QUESTION 75
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)
- A. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
- B. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
- C. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
- D. Media Management messages for SBT devices are always written to sbtio.log.
- E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
- F. Media Management messages for SBT devices are written to an Oracle trace file.
Answer: B,C
NEW QUESTION 76
Which two are true about server-generated alerts? (Choose two.)
- A. Stateful alerts must be created by a DBA after resolving the problem.
- B. Stateless alerts can be cleared manually.
- C. Stateful alerts are purged automatically from the alert history.
- D. Stateless alerts are automatically cleared.
- E. Stateless alerts can be purged manually from the alert history.
Answer: B,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.
Reference:
https://jameshuangsj.wordpress.com/2019/12/01/clears-stateless-alerts-in-oem-by-using-emcli/
NEW QUESTION 77
Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)
- A. Use of a recovery catalog is always required to support the creation and use of archival backups.
- B. They are never considered obsolete by RMAN.
- C. Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.
- D. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
- E. They can optionally be written to a fast recovery area (FRA).
- F. The SPFILE is included in the archival backup.
- G. All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.
Answer: E,F,G
NEW QUESTION 78
Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
(Choose three.)
- A. They cannot drop tablespaces.
- B. They can view data from any data dictionary view or dynamic performance view.
- C. They can view data from any user-defined tables.
- D. They can drop any tablespace.
- E. They can create any table.
- F. They cannot create restore points.
Answer: A,E
NEW QUESTION 79
Which two are true about common objects? (Choose two.)
- A. They can be only metadata-linked in an application container.
- B. They can be created only in CDB$ROOT.
- C. They can exist in user-defined schemas only in application containers.
- D. They can exist in CDB$ROOTand an application root.
- E. They can be created only in an application root.
- F. They can be extended data-linked in CDB$ROOT.
Answer: E,F
Explanation:
Explanation/Reference: https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharing-of- data-in-application-common-objects
NEW QUESTION 80
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.)
- A. after losing all copies of the control file
- B. after losing all members of an INACTIVE online redo log group
- C. after losing an UNDOtablespace that is in use
- D. after losing a SYSAUXtablespace data file
- E. after losing all members of the CURRENTonline redo log group
Answer: A,B
NEW QUESTION 81
Which two are true about the character sets used in an Oracle database? (Choose two.)
- A. Single-byte character sets provide better performance than multibyte character sets.
- B. Multibyte character sets allow more efficient space utilization than single byte character sets.
- C. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
- D. Single-byte character sets always use 8-bit encoding schemes.
- E. Unicode enables information from any language to be stored using a single character set.
- F. Single-byte character sets always use 7-bit encoding schemes.
Answer: A,E
Explanation:
Reference:
https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG166
NEW QUESTION 82
Which three are true about Database Point-in-Time Recovery? (Choose three.)
- A. The database must be open RESETLOGS after Database Point-in-Time Recovery.
- B. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
- C. The target point for the recovery must be specified as a stime or System Change Number (SCN).
- D. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
- E. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
- F. The Database must be in ARCHIVELOG mode.
Answer: A,D,F
Explanation:
Explanation
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%
NEW QUESTION 83
Which three are true about an application seed pluggable database (PDB)?
- A. It cannot be added to an application container after the application container has already been created.
- B. It is automatically synchronized with its application root PDB when an application is installed.
- C. It Is automatically synchronized with its application root PDB when an application is upgraded.
- D. 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.
- E. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
- F. It is not required in an application container.
- G. It cannot be dropped from its application container.
Answer: A,B,D,E
NEW QUESTION 84
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)
- A. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- B. Data file 24 can be recovered while connected to PDB2.
- C. Data file 24 can be recovered only while connected to PDB2.
- D. Data file 24 can be restored only while connected to CDB$ROOT.
- E. Data file 24 can be restored only while connected to PDB2.
- F. Data file 24 can be recovered while connected to CDB$ROOT.
Answer: A,E,F
NEW QUESTION 85
Which two are true about RMAN encryption? (Choose two.)
- A. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- B. RMAN encryption keys are stored in a database keystore.
- C. RMAN can encrypt the Oracle Database password file.
- D. Password encryption can be persistently configured using the CONFIGURE ENCRYPTIONcommand.
- E. The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.
Answer: A,E
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#BRADV89476
NEW QUESTION 86
Which three true about recovering tables using RMAN? (Choose three.)
- A. RMAN can recover a table after a DDL operation has altered the table structure.
- B. RMAN can recover tables in the SYSAUX tablespace.
- C. RMAN can recover tables owed by the SYSTEM user.
- D. RMAN can recover tables in a standby database.
- E. RMAN always uses an auxiliary instance.
- F. RMAN can recover tables in the SYSTEM tablespace.
- G. RMAN can recover tables owned by the SYS user.
Answer: B,E,F
NEW QUESTION 87
Which three are true about Database Point-in-Time Recovery?
- A. The database must be in archivelog mode.
- B. The database must be in mount state when performing Database Point-in-Time Recovery.
- C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
- D. The target point for the recovery must be specified as a time or System Change Number (SCN).
- E. The database must be open resetlogs after Database Point-in-Time Recovery.
- F. The database must have flashback database on to perform Database Point-in-Time Recovery.
Answer: A,D,E
NEW QUESTION 88
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
- A. They are generated by SMON when a tablespace is 97% full.
- B. Metrics are statistical counts for a specific unit.
- C. A space usage management alert is automatically cleared after the underlying problem is resolved.
- D. All metrics are instance related.
- E. STATISTICS_LEVEL must be set to ALL to generate alerts.
- F. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
Answer: B,C,F
Explanation:
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2
NEW QUESTION 89
Examine this configuration:
1. CDB1 is an Oracle Database 12c Release 2 container database (CDB).
2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:
What is the outcome?
- A. It fails because PDB2 is not in UPGRADE state.
- B. It fails because PDB$SEED is in MIGRATE state.
- C. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
- D. Only CDB$ROOT and PDB$SEED are upgraded.
- E. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
- F. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
Answer: D
NEW QUESTION 90
Which three are true? (Choose three.)
- A. Application-common TSDP policies are always container specific.
- B. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
- C. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
- D. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
- E. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
- F. Unified auditing can be automatically synchronized to all application PDBs in an application container.
- G. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
Answer: B,E,F
NEW QUESTION 91
Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?
- A. seven
- B. six
- C. eight
- D. five
- E. three
Answer: A
NEW QUESTION 92
For which two requirements can you use the user_tablespaces clause with the create pluggable database command?
- A. to exclude a temp tablespace when plugging in a PDB
- B. to specify the list of tablespaces to include when creating a PDB from the CDB seed
- C. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
- D. to specify a default tablespace in a PDB cloned from another PDB in the same CDB
- E. to include specific user tablespaces only when relocating a PDB
- F. to exclude all tablespaces except system, sysaux, and temp when plugging in a PDB
Answer: A,F
NEW QUESTION 93
......
Get ready to pass the 1Z0-083 Exam right now using our Oracle Database 19c Exam Package: https://www.guidetorrent.com/1Z0-083-pdf-free-download.html
A fully updated 2021 1Z0-083 Exam Dumps exam guide from training expert GuideTorrent: https://drive.google.com/open?id=1Mxih1idgOVIuGv-vYSlfmj6KaAl5Ufx5