2021 Realistic iPassleader 1Z1-083 Dumps PDF - 100% Passing Guarantee
Free Oracle 1Z1-083 Exam Questions & Answer
NEW QUESTION 14
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
(Choose two.)
- A. SQL statements doing joins always do more physical I/O than single table queries.
- B. Poorly performing SQL statements can be tuned automatically by the Oracle server.
- C. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
- D. SQL statements doing only logical reads never require tuning because they do no physical I/O.
- E. The solution that best optimizes one SQL statement can degrade the performance of others.
Answer: B,D
NEW QUESTION 15
Which operating system group is NOT needed to perform an Oracle Database installation?
- A. OSOPER
- B. OSKMDBA
- C. OSRACDBA
- D. OSDBA
- E. OSASM
Answer: C
NEW QUESTION 16
Which three are true? (Choose three.)
- A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
- B. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
- C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
- D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
- E. Application-common TSDP policies are always container specific.
- 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: D,E,F
NEW QUESTION 17
Which two are true about automatic block repair? (Choose two.)
- A. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
- B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
- C. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
- D. It is not possible for media corrupt blocks.
- E. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
Answer: B,E
NEW QUESTION 18
Which two are true about RMAN persistent configuration settings, administration, and their effects?
- A. Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.
- B. Backups older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
- C. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- D. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
- E. A target database's persistent RMAN configuration settings are always stored in the target's control file
Answer: B,E
NEW QUESTION 19
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)
- A. root.shcan be executed automatically by the Database installer only by using sudocredentials.
- B. root.shcan be executed automatically by the Database Installer only if it is provided with root credentials.
- C. The sudopassword must be specified in a response file.
- D. The rootpassword cannot be specified in a response file.
- E. orainstRoot.shcan be executed automatically by the Database installer by using sudoor root credentials.
- F. The sudopassword can be specified in a response file.
Answer: D,E
Explanation:
Explanation
NEW QUESTION 20
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true?
- A. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- B. These backups can be written to disk or SBT.
- C. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
- D. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- E. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
Answer: C,D
NEW QUESTION 21
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
- A. cloning a remote container database in interactive mode
- B. relocating a remote pluggable database in interactive mode
- C. relocating a remote container database in interactive mode
- D. relocating a remote pluggable database in silent mode
- E. cloning a remote container database in silent mode
- F. cloning a remote pluggable database in silent mode
- G. relocating a remote container database in silent mode
Answer: B,D,E
NEW QUESTION 22
Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c? (Choose two.)
- A. The response file must contain the root or sudo password.
- B. Silent install always runs operating scripts automatically.
- C. The response file can specify the root or sudo password.
- D. The installer will prompt for the root or sudo password.
- E. The response file can specify the path of the sudo program.
Answer: A,E
NEW QUESTION 23
On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.
Level 0 backups are taken on the 10th, 17th, and 24th of August.
Differential level 1 incremental backups are taken daily between the level 0 backups.
Today is the 26th of August.
Which backups will be obsolete?
- A. all backups prior to 10th of August
- B. all backups prior to 17th of August
- C. all backups prior to 22nd of August
- D. all backups prior to 20th of August
- E. all backups prior to 24th of August
Answer: E
NEW QUESTION 24
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. AWR data is stored in the SYSTEM tablespace.
- B. By default, AWR snapshots are retained for 7 days.
- C. The taking of AWR snapshots can be disabled.
- D. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
- E. By default, AWR snapshots are taken every 60 minutes.
Answer: C,D,E
NEW QUESTION 25
You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)
- A. All files in any previous FRA that have not yet been backed up, are backed up.
- B. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
- C. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
- D. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
- E. All files in any previous FRA that have been backed up already, are backed up.
- F. All files in the current FRA that have been backed up already, are backed up.
- G. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.
Answer: C,E,G
NEW QUESTION 26
Which four are true about RMAN backup sets? (Choose four.)
- A. Blocks from multiple data files can be contained in one backup piece,
- B. Blocks from multiple data files can be contained in one backup set,
- C. A data file canbe split into multiple sections stored in different backup pieces in the same backup set.
- D. A data file can be split into multiple sections stored in different backup sets.
- E. A backup set must be written to media.
- F. A backup set can contain only one backup piece.
- G. A backup set must be written to disk.
- H. A backup piece can belong to only one backup set.
Answer: B,D,E,F
NEW QUESTION 27
A database is configured in ARCHIVELOG mode.
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 all members of the CURRENT online redo log group
- D. after losing an UNDO tablespace that is in use
- E. after losing a SYSAUX tablespace data file
Answer: A,C
NEW QUESTION 28
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 snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
- C. A PDB snapshot is always a sparse 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 PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
- F. A snapshot copy PDB can be created from a stand-alone clone PDB.
- G. A PDB snapshot is always a full copy of the source PDB.
Answer: D,F
NEW QUESTION 29
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives?
- A. The SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously
- B. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
- C. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
- D. SBT tape compression can be used even if no RMAN compression is configured.
- E. SBT tape compression and RMAN backup compression should be used in parallel.
Answer: D,E
NEW QUESTION 30
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:
Which three are true?
- A. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
- B. A default service Is created for the application root APP1.
- C. APP1 can never be unplugged.
- D. An application root PDB is created for APP1.
- E. An application seed PDB Is created for APP1.
- F. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
Answer: A,D,E
NEW QUESTION 31
Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)
- A. using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past
- B. creating encrypted backups
- C. using RMAN stored scripts
- D. using the KEEP FOREVER clause with the BACKUP command
- E. creating customized reports about a single database's backups
- F. using the REPORT SCHEMA command to list a database's current data files and tablespaces
Answer: C,D,F
NEW QUESTION 32
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It can recommend changes to improve the statistics gathering process.
- B. It can be run only manually.
- C. It is part of the DBMS_STATSpackage.
- D. It is part of the DBMS_ADVISORpackage.
- E. It runs automatically every night by default.
- F. It always analyzes all schemas in the database.
Answer: A,C,F
Explanation:
Explanation/Reference: https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2
NEW QUESTION 33
A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)
- A. after losing an archived log from before the most recent backup
- B. after losing an archived log from after the most recent backup
- C. after losing all copies of the control file
- D. after losing the SYSTEM tablespace
- E. when any archived log from, before, or after the most recent backup is corrupt.
Answer: A,D
NEW QUESTION 34
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
- A. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
- B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
- C. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- D. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
- E. After the change, only one undo tablespace can exist in CDB$ROOT.
- F. Undo tablespaces existing in PDBs must be dropped before the change.
Answer: B,E
Explanation:
You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property. When the database property LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO tablespace that is created in the CDB root, and that is shared by all containers. When LOCAL_UNDO_ENABLE is TRUE, every container in the CDB uses local undo and each PDB must have its own local UNDO tablespace. To maintain ease of management and provisioning, UNDO tablespace creation happens automatically and does not require any action from the user. When a PDB is opened and an UNDO tablespace is not available, its automatically created.
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/creating-and-configuring-a- cdb.html#GUID-12ADA04D-F81D-4579-A68C-0958CC7D6C2F
NEW QUESTION 35
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 to a patched Oracle Database home
- B. to switch to a read-only Oracle home
- C. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
- D. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
- E. to switch back to the previous Oracle home as part of a rollback operation
Answer: A,E
Explanation:
Explanation
You can use rhpctl move gihome command with the same syntax to switch from the current Oracle Grid Infrastructure home to a patched home. The rhpctl command enables you to switch from your current Oracle Grid Infrastructure or Oracle Database home to patched Oracle home so that you can provision the new Oracle home as gold image. You can also use the rhpctl command to switch back to the old Oracle home, if you want to roll back the operation.
NEW QUESTION 36
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)
- A. Media Management messages for SBT devices are written to an Oracletrace file.
- B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
- C. RMAN 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 commandcompilation to be written to a log file and to standard output.
- F. Media Management messages for SBT devices are always written to sbtio.log.
Answer: A,D
NEW QUESTION 37
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
- A. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
- B. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- C. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
- D. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
- E. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
- F. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
Answer: B,C,E
NEW QUESTION 38
......
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.
Verified 1Z1-083 dumps Q&As Latest 1Z1-083 Download: https://www.ipassleader.com/Oracle/1Z1-083-practice-exam-dumps.html
Updated 100% Cover Real 1Z1-083 Exam Questions - 100% Pass Guarantee: https://drive.google.com/open?id=1X_4dhZjV8yl4kBttRVr1djdp2iMarPQA