[UPDATED 2023] Free Oracle 1Z1-083 Exam Questions Self-Assess Preparation
1Z1-083 Free Sample Questions to Practice One Year Update
The Oracle 1Z1-083 Exam is intended for experienced database administrators who have already passed the Oracle Database Administration I exam (1Z0-082). Candidates who pass this exam will earn the Oracle Database Administrator Certified Professional (OCP) certification, which is a recognized industry standard for database administrators.
The Oracle 1Z0-083 exam covers a wide range of topics related to Oracle database administration. These include backup and recovery strategies, database tuning and performance optimization, database security, and advanced database administration tasks. Candidates must have a thorough understanding of these topics and be able to apply their knowledge in real-world scenarios.
NEW QUESTION # 121
Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)
- A. It can be used to upgrade only single-instance databases running on Oracle Restart.
- B. It can be used to deploy new homes without disrupting active databases.
- C. It can be used to patch existing Oracle software installations.
- D. It can be used to create templates of Oracle homes as gold images of only Oracle databases.
- E. It can be used to create a single-instance Oracle Database in an already-installed Oracle home.
- F. It can be used only on nodes with Oracle Grid Infrastructure installed.
Answer: C,D,F
NEW QUESTION # 122
Examine the command for creating pluggable database PDB2 in container database CDB2.
Select three options, any one of which is required for it to execute successfully. (Choose three.)
- A. Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)
- B. Set only the PDB_FILE_NAME_CONVERT parameter.
- C. Addonly the CREATE_FILE_DEST clause to the statement.
- D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
- E. Enable only OMF.
- F. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
Answer: C,D,E
NEW QUESTION # 123
choose four Which four are true about performance-related Oracle tools?
- A. Database Replay always uses one replay client for each original database session.
- B. SQL Performance Analyzer can suggest schema changes.
- C. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.
- D. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non-consecutive periods.
- E. The Active Session History (ASH) report is based on wait event samples.
- F. Database Replay always uses one replay client for all the original database sessions.
- G. SQL Performance Analyzer can identify regressed SQL statements.
Answer: B,C,D,G
NEW QUESTION # 124
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. All the Oracle-supplied accounts are Schema Only accounts.
- B. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
- C. If the password file location changes, then the new location is used automatically by the Oracle Server.
- D. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
- E. Schema Only accounts can be granted administrator privileges.
- F. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
Answer: A,B,E
Explanation:
Explanation/Reference: https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/
NEW QUESTION # 125
Which three are true about requirements for various flashback operations?
- A. flashback data archive requires undo to store all versions of all rows of a table being tracked.
- B. flashback version query requires that the recyclebin parameter be set to on.
- C. flashback drop requires undo to retrieve all versions of a row that existed between two points in time.
- D. flashback transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- E. flashback drop requires that the recyclebin parameter be set to on.
- F. flashback version query requires undo to retrieve all versions of a row that existed between two points in time.
Answer: A,C,F
NEW QUESTION # 126
Choose three. Which three are true about recovering tables using RMAN?
- A. RMAN can recover tables owned by the SYSTEM user.
- B. RMAN always uses an auxiliary instance.
- C. RMAN can recover tables in the SYSTEM tablespace.
- D. RMAN can recover tables in a standby database.
- E. RMAN can recover a table after a DDL operation has altered the table structure.
- F. RMAN can recover tables owned by the SYS user.
- G. RMAN can recover tables in the SYSAUX tablespace.
Answer: A,B,E
NEW QUESTION # 127
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. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- C. Undo tablespaces existing in PDBs must be dropped before the change.
- D. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
- E. After the change, only one undo tablespace can exist in CDB$ROOT.
- F. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
Answer: D,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 # 128
Which three are true about managing memory components in an Oracle database instance?
- A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
- B. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
- C. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
- D. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
- E. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
- F. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
Answer: A,B,F
NEW QUESTION # 129
Choose three. Which three are true about Oracle Restart?
- A. If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.
- B. It is used in both clustered and non-clustered environments.
- C. It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.
- D. It runs from the Oracle Grid Infrastructure home.
- E. You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands.
- F. The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.
Answer: B,C,E
NEW QUESTION # 130
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
- A. Data Recovery Advisor can proactively check for failures.
- B. A failure can be closed only when it has been repaired.
- C. The Data Recovery Advisor change failure command can be used only to change failure priorities.
- D. Data Recovery Advisor can be used if a database is closed.
- E. Using the Data Recovery Advisor list failure command always requires that the database for which failures are to be listed is in mount state.
Answer: A,D
NEW QUESTION # 131
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
- A. to exclude a temp tablespace when plugging in a PDB
- B. to include specific user tablespaces only when relocating a PDB
- C. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
- D. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
- E. to specify the list of tablespaces to include when creating a PDB from the CDB seed
- F. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
Answer: A,E
NEW QUESTION # 132
Which two are true about RMAN encryption? (Choose two.)
- A. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- B. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.
- C. RMAN encryption keys are stored in a database keystore.
- D. RMAN can encrypt the Oracle Database password file.
- E. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.
Answer: C,E
NEW QUESTION # 133
Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?
- A. Identify poorly tuned SQL statements using the SQL Tuning Advisor.
- B. Tune individual SQL statements using the SQL Tuning Advisor.
- C. Test tuned SQL statements one at a time for all statements in the application.
- D. Test the application as a whole using tuned SQL statements.
- E. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.
- F. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
Answer: B,D,E
NEW QUESTION # 134
Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------------------------------------------------------------2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?
- A. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
- B. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
- C. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
- D. It fails because PDB$SEED is in MIGRATE state.
- E. It fails because PDB2 is not in UPGRADE state.
- F. Only CDB$ROOT and PDB$SEED are upgraded.
Answer: E
NEW QUESTION # 135
Choose two. Which two are true about creating RMAN backups for an Oracle container database?
- A. Online Redo Log backups can be created while connected to the root container.
- B. Control file backups can be created while connected to a nonroot container.
- C. Archived Redo Log backups can be created while connected to an application root CDB.
- D. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.
- E. Control file backups can be created while connected to the root container.
Answer: D,E
NEW QUESTION # 136
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:
Which two are true? (Choose two.)
- A. oracle will be granted the SYSASM privilege when installing the Oracle Database software.
- B. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
- C. oracle must be the owner of every Oracle Database installation.
- D. oracle will be an owner of the Oracle Inventory.
- E. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.
Answer: A,E
NEW QUESTION # 137
Choose the best answer. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
- A. SQL statements
- B. log writer performance
- C. general operating system health
- D. database instance memory management and sizes
- E. database writer performance
Answer: D
NEW QUESTION # 138
Examine this output:
Which two are true? (Choose two.)
- A. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- B. PDB1is always limited to 40% of the available system resources regardless of demand.
- C. Any PDB not specified in the plan will be unable to execute statements in parallel.
- D. PDB2is guaranteed at least 25% of the available parallel execution processes if there is enough 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: C,E
NEW QUESTION # 139
......
Oracle 1Z0-083 is a certification exam designed for individuals who want to validate their skills and knowledge in database administration. It is the second level of Oracle's database administration certification track and is intended for professionals who have already passed the Oracle 1Z0-082 exam. The exam focuses on advanced database administration concepts such as performance tuning, managing database security, configuring backup and recovery, and managing database storage structures.
Real exam questions are provided for Oracle Database 19c tests, which can make sure you 100% pass: https://prep4sure.examtorrent.com/1Z1-083-exam-papers.html
