Latest Jan 05, 2022 Real 1Z1-083 Exam Dumps Questions Valid 1Z1-083 Dumps PDF
Oracle 1Z1-083 Exam Dumps - PDF Questions and Testing Engine
NEW QUESTION 65
Which three are true about patchsets? (Choose three.)
- A. They are only released quarterly.
- B. Installing a patchset is considered an "upgrade".
- C. They are installed via OPatch or OPatchAuto.
- D. They can introduce new features.
- E. They can be applied in a rolling fashion for Clusterware and the databases.
- F. A base release is not needed to install patchsets.
Answer: A,B,F
NEW QUESTION 66
Which three are true about monitoring waits for sessions and services? (Choose three.)
- A. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
- B. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
- C. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
- D. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
- E. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
- F. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
Answer: B,D,F
NEW QUESTION 67
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 20th of August
- B. all backups prior to 22nd of August
- C. all backups prior to 17th of August
- D. all backups prior to 10th of August
- E. all backups prior to 24th of August
Answer: E
NEW QUESTION 68
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. SBT tape compression and RMAN backup compression should be used in parallel.
- B. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
- C. SBT tape compression can be used even if no RMAN compression is configured.
- D. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
- E. The SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously
Answer: A,C
NEW QUESTION 69
Which two are true about changing the LOCAL_UNDO_ENABLEDproperty to false in a CDB? (Choose two.)
- A. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
- C. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
- D. Undo tablespaces existing in PDBs must be dropped before the change.
- E. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
- F. After the change, only one undo tablespace can exist in CDB$ROOT.
Answer: C,E
Explanation:
Explanation/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 70
You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:
Which two are true? (Choose two.)
- A. The insert on USER2.DEPT fails because of the active transaction in the parent container.
- B. The inserts on USER1.EMP were committed when the session connected to PDB2.
- C. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
- D. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
- E. The insert on USER2.DEPT is uncommitted.
- F. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
- G. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
Answer: B,E
NEW QUESTION 71
Which two are true about an RPM-based Oracle Database installation? (Choose two.)
- A. From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.
- B. It uses a service configuration script to create a single-instance database as part of the installation.
- C. It requires an Unbreakable Linux Network (ULN) subscription.
- D. It includes the Oracle Preinstallation RPM.
- E. It performs a software-only Oracle Database installation.
Answer: C,D
NEW QUESTION 72
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases?
- A. A PDB snapshot is always a full copy of the source PDB
- B. A snapshot copy PDB can be created from a stand-alone clone PDB
- C. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system
- 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 PDB snapshot depends on a storage snapshot which can be stored on any file system
- G. A PDB snapshot is always a sparse copy of the source PDB
Answer: E,G
NEW QUESTION 73
Examine this configuration:
1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2.ORCL uses disk group +FRA for the Fast Recovery Area.
3.LISTENER is the listener for ORCL.
4.The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5.All components are currently shut down.
You execute this command:
What is the outcome?
- A. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
- B. Only the ORCL database instance is started.
- C. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
- D. Only the ORCL database instance and the +DATA and +FRA disk groups are started.
- E. Only the ORCL database and the ASM instances are started.
Answer: C
NEW QUESTION 74
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
- B. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
- C. Existing Oracle Database instances must be shut down before starting the upgrade.
- D. Only the grid user can perform the upgrade.
- E. An existing Oracle base can be used.
- F. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
Answer: C,D,F
Explanation:
Reference:
https://docs.oracle.com/database/121/CWLIN/procstop.htm#CEGEDCDB
NEW QUESTION 75
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)
- A. The number of table rows is considered when evaluating the cost of accessing a table using an index.
- B. Statistics collected using DBMS_STATS always yield the best optimizer result.
- C. Index balanced B*Tree height is considered when evaluating the cost of using an index.
- D. The Statistics Advisor generates actions for all recommendations.
- E. The Statistics Advisor can help recommend the best way to gather statistics.
Answer: B,E
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics- advisor.html#GUID-D81A7708-FDA0-45BB-A6E2-103858B047AE
NEW QUESTION 76
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
- A. A space usage management alert is automatically cleared after the underlying problem is resolved.
- B. All metrics are instance related.
- C. Metrics are statistical counts for a specific unit.
- D. They are generated by SMON when a tablespace is 97% full.
- E. STATISTICS_LEVEL must be set to ALL to generate alerts.
- F. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
Answer: A,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 77
Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)
- A. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
- B. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
- C. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
- D. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
- E. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
- F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
- G. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
- H. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
Answer: C,E,G,H
NEW QUESTION 78
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)
- A. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
- B. It can be used to provision applications.
- C. It can be used to provision middleware.
- D. It is an Oracle Database service
- E. It cannot be used to upgrade Oracle Database homes.
Answer: B,C
NEW QUESTION 79
PDB1 and PBD2 are pluggable databases in CDB1.
Examine these commands:
CDB1 is then restarted.
Which three are true? (Choose three.)
- A. PDB1 will be MOUNTED.
- B. PDB$SEED will be opened READ ONLY.
- C. PDB1 will be opened READ WRITE.
- D. PDB2 will be MOUNTED.
- E. PDB$SEED will be MOUNTED.
- F. PDB2 will be opened READ WRITE.
Answer: B,C,F
NEW QUESTION 80
For which two requirements can you use the user_tablespaces clause with the create pluggable database command?
- A. to exclude all tablespaces except system, sysaux, and temp when plugging in a PDB
- B. to specify a default tablespace in a PDB cloned from another PDB in the same CDB
- C. to exclude a temp tablespace when plugging in a PDB
- D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
- E. to include specific user tablespaces only when relocating a PDB
- F. to specify the list of tablespaces to include when creating a PDB from the CDB seed
Answer: A,C
NEW QUESTION 81
Which two are true about gathering optimizer statistics? (Choose two.)
- A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
- B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
- C. System statistics can be gathered only while connected to CDB$ROOT.
- D. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
- E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
Answer: A,B
Explanation:
Explanation
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%2
.
NEW QUESTION 82
Which two are true about memory advisors? (Choose two.)
- A. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
- B. If Automatic Memory Management is enabled, no memory advisors are available.
- C. All memory advisors use data from Automatic Workload Repository.
- D. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.
- E. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
Answer: A,B
NEW QUESTION 83
Which three are true about Audit policies In container databases (CDBs)?
- A. A common unified audit policy can be created at the CDB level.
- B. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
- C. All audit records are written to the audit trail in CDB$ROOT
- D. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.
- E. An application PDB cannot have a local audit policy.
- F. A common unified audit policy can be created at the application root level.
Answer: B,D,E
NEW QUESTION 84
Which two are true about RMAN encryption?
- A. Password encryption can be persistently configured using the configure encryption command.
- B. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- C. RMAN can encrypt the Oracle Database password file.
- D. RMAN encryption keys are stored in a database keystore.
- E. The set encryption command overrides encryption settings specified by the configure encryption command.
Answer: D,E
NEW QUESTION 85
......
Reliable Oracle Database 19c 1Z1-083 Dumps PDF Jan 05, 2022 Recently Updated Questions: https://prep4sure.examtorrent.com/1Z1-083-exam-papers.html
