1Z0-083 PDF Dumps Nov 17, 2021 Exam Questions – Valid 1Z0-083 Dumps
Ultimate 1Z0-083 Guide to Prepare Free Latest Oracle Practice Tests Dumps
What is Oracle Database Administration II Exam Number: 1Z0-083 Certification Exam and Retake policy
Oracle Cloud Certification credentials are only valid for a period of 18 months from the date you earn the credential. The certification will become inactive at the end of 18 months. However, for Oracle candidates, it is necessary to hold an active certification in order to have access to various certification benefits including, using Oracle certification logos, certificates, scoring reports, digital badges, and certification verification.
To stay current, candidates have to re-certify themselves with the latest version of the exam. Oracle Cloud Certifications include various titles with levels that are Oracle Certified Associate, Specialist, and Professional. Moreover, the Oracle Cloud Certifications are updated continuously throughout the year for keeping current with major product and service releases and re-released on an annual basis with a new title.
For more info read reference:
1Z0-083 Official Certification Site Oracle Cloud Learning Resources
NEW QUESTION 93
Which two are true about Oracle Flashback features? (Choose two.)
- A. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.
- B. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
- C. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
- D. FLASHBACK DROP can undrop an index when undropping a table.
- E. FLASHBACK TABLE can undrop a column.
Answer: A,D
NEW QUESTION 94
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)?
- A. The Oracle Grid Infrastructure Installation must be owned by the grid user.
- B. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
- C. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
- D. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
- E. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
- F. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
Answer: A,C
NEW QUESTION 95
Examine this configuration:
1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are INACTIVE.
4. Redo log group 3 is the CURRENT group.
All members of redo log group 3 are lost before it is archived.
Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABSE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABSE OPEN
10.ALTER DATABASE OPEB RESETLOGS
Choose the minimum required steps in the correct order to recover the database.
- A. 1, 3, 5, 7, 10
- B. 1, 2, 5, 7, 4, 10
- C. 1, 3, 5, 6, 9
- D. 1, 3, 5, 8, 6, 10
- E. 1, 3, 5, 6, 10
Answer: E
NEW QUESTION 96
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 97
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)
- A. Flashback logs are automatically purged whenever the value of
DB_FLASHBACK_RETENTION_TARGET is changed. - B. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
- C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
- D. Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
- E. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
Answer: A,B
NEW QUESTION 98
Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:
Which two are true? (Choose two.)
- A. The REVENUE table must be a list-partitioned table.
- B. The CONTAINERS clause cannot be used in queries on the REVENUE table.
- C. A container map exists for the REVENUE table, but is not enabled.
- D. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
- E. The MAPTABLE table is a metadata-linked table.
- F. The REVENUE table partitions are not pruned across the PDBs automatically.
Answer: C,D
NEW QUESTION 99
Your SALES_ROOTapplication container has two application PDBs.
The SALES_APPapplication has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:
Which two are true? (Choose two.)
- A. The MAPTABLEtables defines a logical partition key on a commonly used column for the REVENUEtable.
- B. The REVENUEtable partitions are not pruned across the PDBs automatically.
- C. A container map exists for the REVENUEtable, but is not enabled.
- D. The REVENUEtable must be a list-partitioned table.
- E. The CONTAINERSclause cannot be used in queries on the REVENUEtable.
- F. The MAPTABLE table is a metadata-linked table.
Answer: A,C
NEW QUESTION 100
A database is configured in ARCHIVELOGmode.
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 an UNDOtablespace that is in use
- D. after losing a SYSAUXtablespace data file
- E. after losing all members of the CURRENTonline redo log group
Answer: A,B
NEW QUESTION 101
Which two are true about duplicating pluggable databases (PDBs) with RMAN?
- A. cdb$root and pdbSseed are automatically duplicated.
- B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
- C. The auxiliary Instance is automatically created with enable_pluggable_database = true.
- D. Two or more PDBs can be duplicated with the same rmak duplicate command.
- E. A user with sysdba or sysbkup must be logged in with RMAN to the PDB to duplicate it.
Answer: B,D
NEW QUESTION 102
Which two are true about data movement between a non-CDB and a PDB using Data Pump?
- A. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
- B. A new PDB is automatically created when importing a non-CDB into a CDB.
- C. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
- D. Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.
- E. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
- F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
Answer: B,D
NEW QUESTION 103
The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3.
Which three are true? (Choose three.)
- A. A proxy PDB must exist in the application root in the remote CDB.
- B. The HR_ROOT replica must exist in the remote CDB.
- C. PDB3's application root replica must exist in the local CDB.
- D. A proxy PDB must exist in the application root in the local CDB.
- E. A database link must exist in the remote CDB referring to the local CDB.
- F. A database link must exist in the local CDB root referring to the remote CDB.
Answer: B,D,E
NEW QUESTION 104
A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?
- A. V$SESSION
- B. V$SESSTAT
- C. V$SESSION_WAIT
- D. V$SESSION_EVENT
- E. V$SESSION_WAIT_CLASS
Answer: E
NEW QUESTION 105
Which two are true about server-generated alerts? (Choose two.)
- A. Stateless alerts can be cleared manually.
- B. Stateful alerts are purged automatically from the alert history.
- C. Stateless alerts are automatically cleared.
- D. Stateful alerts must be created by a DBA after resolving the problem.
- E. Stateless alerts can be purged manually from the alert history.
Answer: A,D
NEW QUESTION 106
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
- A. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
- B. Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
- C. An Oracle database can be restored from backup files copied using O/S utilities.
- D. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
- E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance bestarted and the dataabse be in the MOUNT state.
- F. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
- G. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
Answer: A,D,F
NEW QUESTION 107
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
- A. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
- B. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
- C. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
- D. The Oracle Grid Infrastructure installation must be owned by the grid user.
- E. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
- F. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
Answer: A,C
NEW QUESTION 108
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 109
Which three are true about the Oracle Optimizer? (Choose three.)
- A. It can re-optimize execution plans after previous executions detect suboptimal plans.
- B. It considers object statistics when generating execution plans for SQL statements.
- C. It updates stale object statistics in the Data Dictionary.
- D. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
- E. It considers the filters in WHERE clauses when generating execution plans for SQL statements.
- F. It obeys all hints.
Answer: B,C,D
NEW QUESTION 110
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 111
Which two are true about Oracle Database Configuration Assistant (DBCA) templates?
- A. New templates can only be created by modifying an existing user-created template.
- B. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
- C. The General Purpose or Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- D. Oracle DBCA templates can store only logical structure and not database files.
- E. The Data Warehouse template is most suitable when transaction response time is the key criterion.
Answer: B,D
NEW QUESTION 112
Which two are true about a Recovery Manager (RMAN) duplication without a target connection?
- A. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
- B. RMAN SBT-based backups of the database to be duplicated can be used by 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 target instance.
- E. The undo tablespace clause is always required when no connection exists to the recovery catalog and the target database is closed.
Answer: C,E
NEW QUESTION 113
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. 1,3,4, 5
- B. 1,2,4, 5
- C. 2, 4, 5, 6
- D. 1,2,3,4, 5,6
- E. 2, 4, 5
Answer: A
NEW QUESTION 114
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It is part of the DBMS_ADVISOR package.
- B. It is part of the DBMS_STATS package.
- C. It can recommend changes to improve the statistics gathering process.
- D. It always analyzes all schemas in the database.
- E. It runs automatically every night by default.
- F. It can be run only manually.
Answer: B,C,F
Explanation:
https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf Reference:
https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2
NEW QUESTION 115
Which two are true about creating RMAN backups for an Oracle container database?
- A. The backup pluggable database command can be used to back up cdb$root.
- B. The backup database plus archivelog command will back up archive logs when RMAN is connected to a PDB.
- C. spfile backups can be created while connected to an application root PDB.
- D. The backup database command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
- E. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
Answer: B,D
NEW QUESTION 116
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)
- A. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
- B. It provides before and after execution statistics for each SQL statement in the analysis task
- C. SQL statements that were originally run concurrently are run concurrently by SPA.
- D. It predicts the impact of system changes on SQL workload response time.
- E. It is integrated with the SQL Access Advisor.
Answer: A,D
NEW QUESTION 117
A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?
- A. V$SESSION
- B. V$SESSTAT
- C. V$SESSION_WAIT
- D. V$SESSION_WAIT_CLASS
- E. V$SESSION_EVENT
Answer: E
Explanation:
Reference:
https://docs.oracle.com/cd/E29597_01/server.1111/e16638/instance_tune.htm
NEW QUESTION 118
......
Passing Key To Getting 1Z0-083 Certified Exam Engine PDF: https://www.actualvce.com/Oracle/1Z0-083-valid-vce-dumps.html
Get Top-Rated Oracle 1Z0-083 Exam Dumps Now: https://drive.google.com/open?id=1SJGpMO5DdD3jnykNQuHfXt1NKA9sX0sq