Free 1Z0-083 pdf Files With Updated and Accurate Dumps Training
Top-Class 1Z0-083 Question Answers Study Guide
Oracle 1Z0-083 exam is a certification test designed for professionals who want to validate their skills in database administration. 1Z0-083 exam is a part of the Oracle Certified Professional (OCP) certification track and is considered as an intermediate-level exam. Passing 1Z0-083 exam is a prerequisite to becoming an OCP certified professional.
NEW QUESTION # 146
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 only while connected to CDB$ROOT.
- B. Data file 24 can be recovered only while connected to PDB2.
- C. Data file 24 can be recovered while connected to PDB2.
- D. Data file 24 can be restored and recovered 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,D,F
NEW QUESTION # 147
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?
- A. Decreasing PCTUSED
- B. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation
- C. Increasing the number of DBWN process
- D. Decreasing PCTFREE
- E. Using Automatic Segment Space Management (ASSM)
Answer: E
NEW QUESTION # 148
Which two are true about unplugging an application container from a container database and plugging it into a different container database?
- A. Plugging the application root into a different CDB plugs In all its application PDBs.
- B. It requires only local undo mode in the database where the application container will be unplugged.
- C. It requires local undo mode in both container databases.
- D. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.
- E. Unplugging the application root from a CDB unplugs all its application PDBs.
- F. Application PDBs In the application container must be unplugged before the application root Is unplugged.
Answer: E,F
NEW QUESTION # 149
Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)
- A. It can be used to change the character set of an existing 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 convert a non-container database to a container database.
- E. It can only be launched from the command line interface.
Answer: A,E
NEW QUESTION # 150
Which two are true about RMAN encryption? (Choose two.)
- A. The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.
- B. RMAN encryption keys are stored in a database keystore.
- C. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- D. Password encryption can be persistently configured using the CONFIGURE ENCRYPTIONcommand.
- E. RMAN can encrypt the Oracle Database password file.
Answer: A,C
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#BRADV89476
NEW QUESTION # 151
Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)
- A. DBUA must be launched from the target Oracle Home.
- B. All pluggable databases are automatically upgraded as part of a container database upgrade.
- C. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.
- D. The database must be opened in read-only mode.
- E. The Pre-Upgrade Information Tool script is executed by DBUA.
- F. A whole database backup must exist before upgrade
Answer: B,E,F
NEW QUESTION # 152
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)
- A. SBT tape compression and RMAN backup compression should be used in parallel.
- B. SBT tape compression can be used even if no RMAN compression is configured.
- C. The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.
- D. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
- E. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
Answer: A,C
NEW QUESTION # 153
Examine these actions:
1. Create a new database for a recovery catalog.
2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3. Configure archivelog mode for the catalog database.
4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.
5. Grant the recovery_catalog_owner role to the recovery catalog schema owner.
6. Grant the sysbackup privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the create catalog command?
- A. 2, 4, 5
- B. 2, 4, 5, 6
- C. 1,2,4, 5
- D. 1,3,4, 5
- E. 1,2,3,4, 5,6
Answer: D
NEW QUESTION # 154
Choose two. In which two situations can you use Database Upgrade Assistant?
- A. when multiple pluggable databases in a container database have to be upgraded in a specific sequence
- B. when the operating system (OS) needs to be changed as part of the upgrade
- C. when the hardware platform needs to be changed as part of the upgrade
- D. when a character set conversion is required during the upgrade
- E. when the target and source database are on the same platform
Answer: A,E
NEW QUESTION # 155
Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command
- A. Flashback must be enabled for the PROD database.
- B. RMAN must be connected to the target database instance and the auxiliary instance.
- C. A most recent backup set of the PROD database must exist.
- D. The target database must be in MOUNT state.
Answer: B
NEW QUESTION # 156
Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?
- A. SYSAUX tablespaces
- B. the data dictionary in CDB$ROOT
- C. the log writer process (LGWR)
- D. temporary tablespaces
- E. the Process Monitor Process (PMON)
- F. undo tablespaces
Answer: B,C,E
NEW QUESTION # 157
1.Which two are prerequisites for creating a backup-based duplicate database?
- A. matching the database identifier (DBID) of the source database and the duplicate database
- B. creating a password file for an auxiliary instance
- C. creating an SPFILE for the target database
- D. connecting to the target database and a recovery catalog to execute the duplicate command
- E. connecting to an auxiliary instance
Answer: B,E
NEW QUESTION # 158
Examine this command: $ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)
- A. to switch back to the previous Oracle home as part of a rollback operation
- B. to switch to a patched Oracle Database home
- C. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
- D. to switch to a read-only Oracle home
- E. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
Answer: A,B
NEW QUESTION # 159
hoose two. Which two are true about Recovery Manager (RMAN) diagnostic message output?
- A. Media Management messages for SBT devices are written to an Oracle trace file.
- B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
- C. MAN error stacks should be read from the top down as that is the order in which errors are generated.
- D. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
- 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.
Answer: C,D
NEW QUESTION # 160
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. Oracle DBCA templates can store only logical structure and not database files.
- B. The Data Warehouse template is most suitable when transaction response time is the key criterion.
- C. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
- D. New templates can only be created by modifying an existing user-created template.
- E. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
Answer: C,E
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B22-
8BB67DCC9885.htm#ADMQS0235
NEW QUESTION # 161
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)
- A. It cannot be used to upgrade Oracle Database homes.
- B. It is an Oracle Database service
- C. It can be used to provision applications.
- D. It can be used to provision middleware.
- E. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
Answer: D,E
NEW QUESTION # 162
Choose two. You plan to perform cross-platform PDB transport using XTTS. Which two are true?
- A. The source PDB must be in MOUNT state.
- B. The source and target platforms must have the same endianess.
- C. A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.
- D. Automatic conversion of endianess occurs.
- E. The source PDB must not be an application root.
- F. The source PDB can be in MOUNT or OPEN state.
Answer: B,F
NEW QUESTION # 163
Examine this configuration:
1. CDB1is a container database.
2. COMMON_USER_PREFIXis C##.
3. PDB1is a pluggable database contained in CDB1.
4. APP1_ROOTis an application container contained in CDB1.
5. APP1_PDB1is an application PDB contained in APP1_ROOT.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. APP1_USER1can have different privileges in each Application PDB contained in APP1_ROOT.
- B. APP1_USER1can be created in PDB1.
- C. C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.
- D. C##_APP_USER1can be created in CDB1.
- E. APP1_USER1can be created in CDB1.
- F. P1_USER1can be created in CDB1.
Answer: A,C
NEW QUESTION # 164
Examine this configuration:
1. CDB1is a container database.
2. PDB1 and PDB2are pluggable databases in CDB1.
3. PDB1 and PDB2are OPENin READ WRITEmode.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. Uncommitted transactions in PDB1have been rolled back.
- B. CDB1is in MOUNT state
- C. CDB1is shut down.
- D. Uncommitted transactions in CDB1and PDB1have been rolled back.
- E. PDB1is closed.
Answer: B,E
NEW QUESTION # 165
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 recovered only while connected to PDB2.
- B. Data file 24 can be recovered while connected to PDB2.
- C. Data file 24 can be restored only while connected to PDB2.
- D. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- E. Data file 24 can be recovered while connected to CDB$ROOT.
- F. Data file 24 can be restored only while connected toCDB$ROOT.
Answer: C,D,E
NEW QUESTION # 166
Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?
- A. Run the SQL Tunning Advisor.
- B. Run the Memory Advisor for the shared pool.
- C. Run the SQL Access Advisor.
- D. Run the Memory Advisor for the System Global Area.
- E. Run the Memory Advisor for the Program Global Area.
Answer: B
NEW QUESTION # 167
Choose two. Which two are true about backup encryption?
- A. The BACKUP BACKUPSET command can encrypt and decrypt backup sets.
- B. Vendor-specific media management software can be used for making encrypted RMAN backups to media.
- C. The Transparent Data Encryption (TDE) keystore is backed up using RMAN.
- D. Keystore-based encryption is the default mode for RMAN backup encryption.
- E. Backup encryption can be enabled selectively for specific tablespaces.
- F. Image copies can be encrypted.
Answer: A,D
NEW QUESTION # 168
......
Real Updated 1Z0-083 Questions & Answers Pass Your Exam Easily: https://www.fast2test.com/1Z0-083-premium-file.html
Easily To Pass New 1Z0-083 Verified & Correct Answers: https://drive.google.com/open?id=1OKxnPJSi9WFTnGCMdQxcnUBIGKU0UWUo