Pass Oracle 1Z0-083 With Actual4Dumps Exam Dumps - Updated on Oct-2021
Fully Updated 1Z0-083 Dumps - 100% Same Q&A In Your Real Exam
Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083
The following will be discussed in the ORACLE 1Z0-083 dumps:
- Detect and repair database and database block corruption
- Configure your Database to support Flashback
- Duplicate Databases
- Diagnosing Database Issues
- Diagnosing Failures - Oracle Database: Backup and Recovery Workshop
- Configuring and using RMAN - Oracle Database: Backup and Recovery Workshop
- Employ the best Oracle Database recovery technology for your failure situation
- Duplicating a Database - Oracle Database: Backup and Recovery Workshop
- Using Flashback Technologies - Oracle Database: Backup and Recovery Workshop
- Perform flashback operations
- Configure and using an RMAN recovery catalog
- Restore and Recovery Concepts - Oracle Database: Backup and Recovery Workshop
- Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry
- Configure RMAN and the Database for Recoverability
NEW QUESTION 10
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. AWR data is stored in the SYSTEMtablespace.
- B. The taking of AWR snapshots can be disabled.
- C. By default, AWR snapshots are taken every 60 minutes.
- D. Its collection level is determined by the value of the STATISTICS_LEVELdatabase parameter.
- E. By default, AWR snapshots are retained for 7 days.
Answer: B,C,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
NEW QUESTION 11
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)
- A. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
- B. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- C. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- D. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
- E. These backups can be written to disk or SBT.
Answer: A,E
NEW QUESTION 12
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_sync_io.discrete_bytes_per_second are a potential performance bottleneck when synchronous I/O is used.
- B. If an rman backup validate command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
- C. If an rman backup validate command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.
- D. If an rman backup validate command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
- E. Data files with a high value in v$backup_async_io.short_waits are a potential performance bottleneck when asynchronous I/O is used.
Answer: D,E
NEW QUESTION 13
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true?
- A. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
- B. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- C. These backups can be written to disk or SBT.
- D. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- E. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
Answer: A,B
NEW QUESTION 14
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
- A. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
- B. A subset of the target database can be duplicated.
- C. A connection to the target database instance is always required.
- D. A connection to an auxiliary instance is always required.
- E. A backup of the target database is always required.
- F. A connection to the recovery catalog instance is always required.
- G. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
- H. A new DBID is always created for the duplicated database.
Answer: A,B,D,G
Explanation:
A duplicate database is a copy of your target database. With the FOR STANDBY clause, it keeps the same unique database identifier(DBID); If FOR STANDBY not specified it creates a new DBID. The duplicate database can include the same content or only a subset from the source database. It can be in the same host or a separate host. The principal work of the duplication is performed by the auxiliary channels.These channels correspond to a server session on the auxiliary instance on the destination host for backup based duplication. For active database duplication the target channels perform the work of pushing data file copies to the auxiliary instance (if number of allocated target channels is greater than the number of allocated auxiliary channels).
NEW QUESTION 15
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)
- A. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
- B. A PDB snapshot is always a sparse copy of the source PDB.
- C. A PDB snapshot is always a full copy of the source PDB.
- D. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
- E. A snapshot copy PDB can be created from a stand-alone clone PDB.
- F. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
- G. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
Answer: C,F
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-pdb- snapshots.html#GUID-35B03C37-00BA-4945-BF20-9A7C4C541955
NEW QUESTION 16
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:
# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall) , 54322(dba) Which two are true?
- A. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.
- B. oracle must be the owner of every Oracle Database installation.
- C. oracle will be an owner of the Oracle Inventory.
- D. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
- E. oracle will be granted the sysasm privilege when installing the Oracle Database software.
Answer: D
NEW QUESTION 17
Which two are true about the Oracle dataabsemethodology? (Choose two.)
- A. The alert log should be used to find the database and instance areas most in need of tuning.
- B. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
- C. SQL statements should always be tuned before tuning any file systems.
- D. Tuning activities should stop onceagreed service levels for performance have been met.
- E. Tuning activities should stop once the user is satisfied with performance.
- F. The database instance memory should always be tuned before tuning any file systems.
Answer: A,D
NEW QUESTION 18
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?
- A. AWR snapshots must be deleted when no longer required by ADDM.
- B. ADDM can recommend shrinking the buffer cache.
- C. ADDM performs its analysis only when a DBA requests it.
- D. By default, AWR snapshots are automatically purged after eight days.
- E. ADDM can recommend extending the buffer cache.
- F. By default, MMON creates an AWR snapshot every 30 minutes.
Answer: B,C,D
NEW QUESTION 19
Which two are true in Oracle 19c and later releases?
- A. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
- B. Schema Only accounts can be granted administrator privileges.
- C. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
- D. If the password file location changes, then the new location is used automatically by the Oracle Server.
- E. All the Oracle-supplied accounts are Schema Only accounts.
Answer: B,D
NEW QUESTION 20
Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?
- A. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
- B. It can be used to recover a dropped tablespace.
- C. It can be used to recover a truncated table.
- D. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
- E. It can be performed using an auxiliary instance managed by RMAN.
- F. flashback database must be enabled for it to work.
- G. RMAN always includes tablespaces containing undo segments in the recovery set.
- H. It can be performed using an auxiliary instance managed by a DBA.
Answer: D,E,F,H
NEW QUESTION 21
Which two are true about automatic block repair? (Choose two.)
- A. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
- B. It is not possible for media corrupt blocks.
- C. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
- D. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
- E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
Answer: A,E
NEW QUESTION 22
Examine this output:
Which two are true? (Choose two.)
- A. Any PDB not specified in the plan will be unable to execute statements in parallel.
- B. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- C. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- D. PDB1 is always limited to 40% of the available system resources regardless of demand.
- E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
- F. PDB3 can use all available parallel execution processes at times.
Answer: A,E
NEW QUESTION 23
Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)
- A. Space might be reclaimed proactively before space pressure occurs.
- B. Space is always reclaimed proactively before space pressure occurs.
- C. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
- D. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)
- E. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
Answer: D,E
NEW QUESTION 24
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
- A. ADDM can recommend shrinking the buffer cache.
- B. AWR snapshots must be deleted when no longer required by ADDM.
- C. By default, AWR snapshots are automatically purged after eight days.
- D. ADDM performs its analysis only when a DBA requests it.
- E. ADDM can recommend extending the buffer cache.
- F. By default, MMON creates an AWR snapshot every 30 minutes.
Answer: A,B,C
Explanation:
Explanation/Reference: https://books.google.com.pk/books?id=DeQkU5E75DUC&pg=PA869&lpg=PA869&dq=By+default,
+AWR+snapshots+are+automatically+purged+after+eight
+days&source=bl&ots=DfoGmJfCMy&sig=ACfU3U0Pf2RgIs72LUV4HUzs5UIXI8sXEQ&hl=en&sa=X&ved=2ah UKEwjb8bKhu9noAhUwTxUIHRpYAuMQ6AEwA3oECAsQLA#v=onepage&q=By%20default%2C%20AWR%
20snapshots%20are%20automatically%20purged%20after%20eight%20days&f=false
NEW QUESTION 25
Which two are true about server-generated alerts? (Choose two.)
- A. Stateless alerts are automatically cleared.
- B. Stateful alerts must be created by a DBA after resolving the problem.
- C. Stateless alerts can be purged manually from the alert history.
- D. Stateless alerts can be cleared manually.
- E. Stateful alerts are purged automatically from the alert history.
Answer: B,D
NEW QUESTION 26
Which three are true about an application seed pluggable database (PDB)?
- A. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
- B. It is not required in an application container.
- C. 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.
- D. It Is automatically synchronized with its application root PDB when an application is upgraded.
- E. It cannot be added to an application container after the application container has already been created.
- F. It cannot be dropped from its application container.
- G. It is automatically synchronized with its application root PDB when an application is installed.
Answer: A,C,G
NEW QUESTION 27
Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)
- A. They can optionally be written to a fast recovery area (FRA).
- B. They are never considered obsolete by RMAN.
- C. All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.
- D. 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.
- E. The SPFILE is included in the archival backup.
- F. Use of a recovery catalog is always required to support the creation and use of archival backups.
- G. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
Answer: A,C,E
NEW QUESTION 28
......
Latest 1Z0-083 Exam Dumps - Valid and Updated Dumps: https://www.actual4dumps.com/1Z0-083-study-material.html
Verified 1Z0-083 Exam Questions Certain Success: https://drive.google.com/open?id=1WfUtAfNIAMk_PzlgZdtUT51XMMNiEDEH