Pass 1Z1-083 Exam in First Attempt Guaranteed 100% Cover Real Exam Questions [Nov-2021]
Valid 1Z1-083 test answers & Oracle 1Z1-083 exam pdf
For more info read reference:
1Z0-083 Official Certification Site Oracle Cloud Learning Resources
Oracle 1Z1-083 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
Certification Path for Oracle Database Administration II Exam Number: 1Z0-083
Oracle Database Administration II Exam Number: 1Z0-083 is an advanced exam. Successful completion by candidates of Data Administrator I and II will allow them to achieve Oracle Certified Database Administrator status.
NEW QUESTION 70
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases?
- A. It Is always possible for RMAN to connect to a pluggable database as a target.
- B. It Is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
- C. A Virtual Private Catalog used to register a container database can be created in a non-container database.
- D. A Virtual Private Catalog used to register a container database can be created in a pluggable database.
- E. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
- F. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
Answer: B,C,D
NEW QUESTION 71
Examine this configuration:
CDB1 is a container database.
PDB1 and PDB2 are pluggable databases in CDB1.
PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
- B. CDB1 is shut down.
- C. Uncommitted transactions in PDB1 have been rolled back.
- D. CDB1 is in MOUNT state
- E. PDB1 is closed.
Answer: C,E
NEW QUESTION 72
A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)
- A. PDB_FILE_NAME_CONVERT must be set before executing the command.
- B. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
- C. PDB1 must be dropped from CDB1.
- D. PDB1 data files already exist in the correct location.
- E. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
Answer: A,B
NEW QUESTION 73
Examine this output:
Which two are true? (Choose two.)
- A. Any PDB not specified in the plan will be unable to execute statements in parallel.
- B. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- C. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- D. PDB1 is always limited to 40% of the available system resources regardless of demand.
- E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
- F. PDB3 can use all available parallel execution processes at times.
Answer: A,E
NEW QUESTION 74
Which three are true about monitoring waits for sessions and services? (Choose three.)
- A. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
- B. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
- C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
- D. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
- E. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
- F. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
Answer: A,C,D
NEW QUESTION 75
Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)
- A. All pluggable databases are automatically upgraded as part of a container database upgrade.
- B. The database must be opened in read-only mode.
- C. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.
- D. DBUA must be launched from the target Oracle Home.
- E. The Pre-Upgrade Information Tool script is executed by DBUA.
- F. A whole database backup must exist before upgrade
Answer: A,E,F
NEW QUESTION 76
Which two are true about Oracle Flashback features? (Choose two.)
- A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
- B. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.
- 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,C
NEW QUESTION 77
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 PDB snapshot is always a sparse copy of the source PDB.
- C. A PDB snapshot is always a full 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 snapshot copy PDB can be created from a stand-alone clone PDB.
- F. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
- G. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
Answer: C,F
NEW QUESTION 78
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
- A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
- B. Undo tablespaces existing in PDBs must be dropped before the change.
- C. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
- E. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
- F. After the change, only one undo tablespace can exist in CDB$ROOT.
Answer: E,F
Explanation:
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.
NEW QUESTION 79
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
- B. All the Oracle-supplied accounts are Schema Only accounts.
- C. Schema Only accounts can be granted administrator privileges.
- D. If the password file location changes, then the new location is used automatically by the Oracle Server.
- E. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
- F. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
Answer: B,C,F
Explanation:
Reference:
https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/
NEW QUESTION 80
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 can be run only manually.
- E. It runs automatically every night by default.
- F. It always analyzes all schemas in the database.
Answer: B,C,D
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 81
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 runs automatically every night by default.
- E. It can be run only manually.
- F. It always analyzes all schemas in the database.
Answer: B,C,D
Explanation:
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
NEW QUESTION 82
Which two are true about monitoring waits for sessions and services?
- A. v$session_wait and v$session both contain details of the event on which a waiting session is currently waiting.
- B. v$session_event displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
- C. v$session_wait_class displays waits broken down by wait class only for waiting sessions.
- D. v$service_event displays wait counts for every wait event whether waited on or not, for each service.
- E. v$session_wait and v$session both contain details of the event on which a non-waiting session last waited.
Answer: B,D
NEW QUESTION 83
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,2,3,4, 5,6
- B. 1,2,4, 5
- C. 2, 4, 5, 6
- D. 1,3,4, 5
- E. 2, 4, 5
Answer: D
NEW QUESTION 84
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)
- A. creating thte oraInventory (oinstall) group
- B. creating the grid OS user
- C. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
- D. creating the OSDBA (dba) group
- E. configuring the OS for Oracle Automatic Storage Management shared storage access
- F. creating the oracle OS user
Answer: A,D,E
NEW QUESTION 85
Which two are true about automatic block repair? (Choose two.)
- A. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
- B. It is not possible for media corrupt blocks.
- C. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
- D. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
- E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
Answer: A,E
NEW QUESTION 86
Which three are true about managing memory components in an Oracle database instance?
- A. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
- B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
- C. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
- D. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
- E. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
- F. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
Answer: A,D,F
NEW QUESTION 87
Examine this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are pluggable databases in CDB1.
* PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. Uncommitted transactions in PDB1 have been rolled back.
- B. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
- C. CDB1 is in MOUNT state
- D. CDB1 is shut down.
- E. PDB1 is closed.
Answer: C,E
NEW QUESTION 88
Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)
- A. It analyzes a period of time corresponding to the 12 hours of activity.
- B. It runs automatically after each AWR snapshot.
- C. Results are written to the alert log.
- D. A DBA can run it manually.
- E. It analyzes a period of time corresponding to the last day of activity.
Answer: B,C
NEW QUESTION 89
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?
- A. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- B. Data file 24 can be restored only while connected to CDB$ROOT.
- C. Data file 24 can be recovered while connected to CDB$ROOT.
- D. Data file 24 can be recovered only while connected to PDB2.
- E. Data file 24 can be restored only while connected to PDB2.
- F. Data file 24 can be recovered while connected to PDB2.
Answer: A,C,F
NEW QUESTION 90
Which two are true about RMAN encryption? (Choose two.)
- A. Password encryption can be persistently configured using the CONFIGURE ENCRYPTIONcommand.
- 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 ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.
Answer: B,E
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#BRADV89476
NEW QUESTION 91
......
1Z1-083 Exam Questions – Valid 1Z1-083 Dumps Pdf: https://www.dumpexams.com/1Z1-083-real-answers.html
Verified 1Z1-083 dumps Q&As - Pass Guarantee: https://drive.google.com/open?id=1t394Abv3LHqUfF6z0Z-rogk-2zsDDhjZ