[Feb 04, 2022] New Real 1Z1-083 Exam Dumps Questions

Pass Your 1Z1-083 Exam Easily with Accurate Oracle Database Administration II PDF Questions

NEW QUESTION 75
Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)

• A. The ADR can store metadata in an Oracle Database repository.
• B. RMAN can always repair corrupt blocks.
• C. The Data Recovery Advisor uses the ADR.
• D. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
• E. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
• F. Flashback commands help with repairing physical errors.

Answer: A,B,E

 

NEW QUESTION 76
While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance?

• A. Enable asynchronous disk I/O.
• B. Increase the level of RMAN multiplexing.
• C. Increase the size of the database buffer cache.
• D. Disable FORCE LOGGING for the database.
• E. Increase the size of tape I/O buffers.

Answer: B,D

 

NEW QUESTION 77
Which three are true about patchsets? (Choose three.)

• A. Installing a patchset is considered an "upgrade".
• B. They can introduce new features.
• C. They are only released quarterly.
• D. They are installed via OPatch or OPatchAuto.
• E. A base release is not needed to install patchsets.
• F. They can be applied in a rolling fashion for Clusterware and the databases.

Answer: A,C,E

 

NEW QUESTION 78
Which two are true about various Oracle security and auditing capabilities?

• A. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
• B. Unified auditing can be automatically synchronized to all application PDBs in an application container.
• C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch begin-end block.
• D. Application-common TSDP policies are always container specific.
• E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

Answer: A,C

 

NEW QUESTION 79
Which two are true about automatic block repair?

• A. It is not possible for media corrupt blocks.
• B. Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.
• C. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
• D. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
• E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Answer: A,E

 

NEW QUESTION 80
Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

• A. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.
• B. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
• C. It can be used for applications and middleware.
• D. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.
• E. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

Answer: D,E

Explanation:
Explanation
Reference https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwadd/rapid-homeprovisioning.
html#GUID-CCEC5960-EDA4-4A3F-9643-0CA308EA49AA

 

NEW QUESTION 81
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

• A. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
• B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
• C. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
• D. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
• E. CDB$ROOT and PDB$SEED are automatically duplicated.

Answer: C,E

 

NEW QUESTION 82
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

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

Answer: B,E,F

Explanation:
Password file is automatically converted by RMAN.

 

NEW QUESTION 83
Examine this configuration:
CDB1 is a container database.
COMMON_USER_PREFIX is C##.
PDB1 is a pluggable database contained in CDB1.
APP1_ROOT is an application container contained in CDB1.
APP1_PDB1 is an application PDB contained in APP1_ROOT.
You execute these commands successfully:

Which two are true? (Choose two.)

• A. P1_USER1 can be created in CDB1.
• B. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
• C. APP1_USER1 can be created in PDB1.
• D. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.
• E. C##_APP_USER1 can be created in CDB1.
• F. APP1_USER1 can be created in CDB1.

Answer: B,D

 

NEW QUESTION 84
Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)

• A. It can be used to convert a non-container database to a container database.
• B. It can be launched from both the command line and the Universal Installer (OUI) interfaces.
• C. It can be used to create container databases and non-container databases.
• D. It can be used to change the character set of an existing database.
• E. It can only be launched from the command line interface.

Answer: D,E

 

NEW QUESTION 85
Which four are true about RMAN backup sets?

• A. A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• B. A backup set must be written to media.
• C. A backup set can contain only one backup piece.
• D. Blocks from multiple data files can be contained in one backup piece.
• E. Blocks from multiple data files can be contained in one backup set.
• F. A backup set must be written to disk.
• G. A backup piece can belong to only one backup set.
• H. A data file can be split into multiple sections stored in different backup sets.

Answer: A,D,F,H

 

NEW QUESTION 86
Which two are true about Oracle Database Configuration Assistant (DBCA) templates?

• A. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
• B. Oracle DBCA templates can store only logical structure and not database files.
• C. The General Purpose or Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
• D. The Data Warehouse template is most suitable when transaction response time is the key criterion.
• E. New templates can only be created by modifying an existing user-created template.

Answer: B,D

 

NEW QUESTION 87
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)

• A. SYSAUX tablespaces
• B. undo tablespaces
• C. the data dictionary in CDB$ROOT
• D. the log writer process (LGWR)
• E. temporary tablespaces
• F. the Process Monitor Process (PMON)

Answer: C,E,F

 

NEW QUESTION 88
You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

• A. The restore point is a label for the system change number (SCN) before the archival backup was taken.
• B. The control file is included in the self-contained archival backup.
• C. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
• D. All archive logs created after this backup are kept for two years.
• E. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
• F. The SPFILEis included in the self-contaied archival backup.

Answer: B,D,F

 

NEW QUESTION 89
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. 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.
• B. If an rman backup validate command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
• C. If an rman backup validate command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.
• D. 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.
• 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: B,E

 

NEW QUESTION 90
......

1Z1-083 Certification Exam Dumps Questions in here: https://drive.google.com/open?id=1H2-Y-v-vC62s19pAc5kP9IkxKGEGbUWm

Updated 1Z1-083 Exam Practice Test Questions: https://www.vce4dumps.com/1Z1-083-valid-torrent.html