1Z1-083 Actual Questions - Instant Download 285 Questions
Download Free Latest Exam 1Z1-083 Certified Sample Questions
To take the exam, candidates must have a solid understanding of basic database administration concepts and practices, as well as experience working with Oracle Database technology. They must also have completed the Oracle Database Administration I exam (1Z0-082) or have equivalent knowledge and experience. 1Z1-083 exam consists of 80 multiple-choice questions and has a time limit of 120 minutes.
NEW QUESTION # 119
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
- A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the dataabse be in the MOUNT state.
- B. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
- C. An Oracle database can be restored from backup files copied using O/S utilities.
- D. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
- E. 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.
- F. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
- 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: B,C,F
NEW QUESTION # 120
Which two are true about automatic block repair?
- 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. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
- C. It is not possible for media corrupt blocks.
- D. Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.
- 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,C
NEW QUESTION # 121
Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)
- A. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
- B. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
- C. The sudo password can be specified in a response file.
- D. root.sh can be executed automatically by the Database installer only by using sudo credentials.
- E. The root password cannot be specified in a response file.
- F. The sudo password must be specified in a response file.
Answer: D,E
NEW QUESTION # 122
Which three are true about opatchauto? (Choose three.)
- A. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
- B. It applies patches in nonrolling mode by default.
- C. Patches are applied via opatchauto.
- D. It must be invoked by a user with root user privileges.
- E. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
- F. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
- G. Users must always input patch plans to opatchauto.
Answer: A,C,D
NEW QUESTION # 123
Which three are true? (Choose three.)
- A. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
- B. Unified auditing can be automatically synchronized to all application PDBs in an application container.
- C. Application-common TSDP policies are always container specific.
- D. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
- E. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
- F. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
- G. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
Answer: B,E,F
NEW QUESTION # 124
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)
- A. It is always possible for RMAN to connect to a pluggable database as a target.
- B. A Virtual Private Catalog used to register a container database can be created in a non-container database.
- C. It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
- D. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
- E. A Virtual Private Catalog used to register a container database can be created in a pluggable database.
- F. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
Answer: A,B,E
Explanation:
Explanation/Reference:
NEW QUESTION # 125
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 only in CDB$ROOT.
- B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
- C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
- D. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
- E. System statistics can be gathered only while connected to CDB$ROOT.
Answer: B,C
Explanation:
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%20have%20to,independently%20from%20the%20CDB%24ROOT.&text=Oracle%20Database%20automatically%20gathers%20fixed,Automatic%20Optimizer%20Statistics%20Collection%E2%80%9C) .
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/20/arpls/DBMS_STATS.html
NEW QUESTION # 126
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. Only the grid user can perform the upgrade.
- B. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
- C. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
- D. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
- E. An existing Oracle base can be used.
- F. Existing Oracle Database instances must be shut down before starting the upgrade.
Answer: D,E,F
NEW QUESTION # 127
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. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
- B. PDB1 must be dropped from CDB1.
- C. PDB_FILE_NAME_CONVERT must be set before executing the command.
- D. PDB1 data files already exist in the correct location.
- E. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
Answer: B,E
NEW QUESTION # 128
Which three methods can be used for heap table data migration after upgrading a database?
- A. using Database Upgrade Assistant
- B. using Oracle Data Pump
- C. using the create table AS select SQL statement
- D. using SQL Developer
- E. using Database Replay
- F. using operating system file copy utilities
Answer: A,D,E
NEW QUESTION # 129
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. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
- B. Add only the CREATE_FILE_DEST clause to the statement.
- C. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
- D. Set only the PDB_FILE_NAME_CONVERT parameter.
- E. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
- F. Enable only OMF.
Answer: B,D,F
NEW QUESTION # 130
Which two are true about RMAN encryption? (Choose two.)
- A. RMAN can encrypt the Oracle Database password file.
- B. RMAN encryption keys are stored in a database keystore.
- C. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- D. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.
- E. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.
Answer: C,E
NEW QUESTION # 131
Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)
- A. Results are written to the alert log.
- B. It analyzes a period of time corresponding to the 12 hours of activity.
- C. It runs automatically after each AWR snapshot.
- D. It analyzes a period of time corresponding to the last day of activity.
- E. A DBA can run it manually.
Answer: A,C
NEW QUESTION # 132
Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?
- A. Run the Memory Advisor for the System Global Area.
- B. Run the Memory Advisor for the Program Global Area.
- C. Run the SQL Access Advisor.
- D. Run the SQL Tuning Advisor.
- E. Run the Memory Advisor for the shared pool.
Answer: E
NEW QUESTION # 133
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 can be used even if no RMAN compression is configured.
- B. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
- C. The SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously
- D. SBT tape compression and RMAN backup compression should be used in parallel.
- E. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
Answer: A,D
NEW QUESTION # 134
choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy?
- A. archived redo log files that have multiple copies in a different archive location
- B. flashback logs
- C. user-managed backups of data files and control files
- D. RMAN backups that are obsolete
Answer: B,D
NEW QUESTION # 135
......
Free Oracle 1Z1-083 Exam 2024 Practice Materials Collection: https://www.actual4exams.com/1Z1-083-valid-dump.html
Prepare for your exam certification with our 1Z1-083 Certified Oracle: https://drive.google.com/open?id=1jZ3-DVQrDvCXpbesGMDMPGyL6QNL0k5F