1Z1-083 Sample Practice Exam Questions 2022 Updated Verified
Exam Study Guide Free Practice Test LAST UPDATED 1Z1-083
Who should take the Oracle Database Administration II Exam Number: 1Z0-083
Oracle Database Administration II Exam Number: 1Z0-083 has is ideal for:
- DB Architects
- DB designers and analysts
- Development DBAs
- Production Database Administrators (DBAs)
NEW QUESTION 97
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. PDB1 is closed.
- C. CDB1 is in MOUNT state
- D. CDB1 is shut down.
- E. Uncommitted transactions in PDB1 have been rolled back.
Answer: B,C
NEW QUESTION 98
Choose two. Which two are true about RMAN backups when using a media manager?
- A. A media manager is required to create RMAN proxy copies.
- B. A media manager is required to create RMAN image copies.
- C. A media manager always writes RMAN requested backups to tape.
- D. By default, a request for a proxy copy may result in a backup set being created.
- E. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
Answer: C,D
NEW QUESTION 99
Choose three. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?
- A. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
- B. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
- C. automatically dropping the database link to the remote database if it already exists
- D. creating a new empty PDB in the local database from PDB$SEED
- E. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
- F. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
- G. opening the cloned PDB
Answer: B,C,E
NEW QUESTION 100
Which two are true about the character sets used in an Oracle database? (Choose two.)
- A. Unicode enables information from any language to be stored using a single character set.
- B. Single-byte character sets always use 7-bit encoding schemes.
- C. Multibyte character sets allow more efficient space utilization than single byte character sets.
- D. Single-byte character sets always use 8-bit encoding schemes.
- E. Single-byte character sets provide better performance than multibyte character sets.
- F. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
Answer: A,E
NEW QUESTION 101
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. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.
- C. The Pre-Upgrade Information Tool script is executed by DBUA.
- D. DBUA must be launched from the target Oracle Home.
- E. A whole database backup must exist before upgrade
- F. The database must be opened in read-only mode.
Answer: A,C,E
NEW QUESTION 102
Choose three. You issued this command: RMAN> BACKUP RECOVERY AREA FORCE; Which three are true?
- A. All Oracle recovery files normally written to the FRA and which have not yet been backed, are backed up.
- B. All files in any previous FRA that have not yet been backed up, are backed up.
- C. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
- D. All files in any previous FRA that have been backed up already, are backed up.
- E. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up. C)All files in the current FRA that have been backed up already, are backed up.
- F. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
Answer: C,D
NEW QUESTION 103
Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?
- A. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4
- B. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4
- C. CDB$ROOT, PDB2, PDB1, and PDB3
- D. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3
- E. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4
Answer: A
NEW QUESTION 104
A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)
- A. after losing all copies of the control file
- B. when any archived log from, before, or after the most recent backup is corrupt.
- C. after losing an archived log from after the most recent backup
- D. after losing an archived log from before the most recent backup
- E. after losing the SYSTEM tablespace
Answer: B,D
NEW QUESTION 105
You are managing this configuration:
1. CDB1 is a container database.
2. BDB1 and PDB2 are two pluggable databases in CDB1.
3. user1 .EMP Is a table In PDBI and user2.DEPT is a table in PDB2.
Which two are true?
- A. The inserts on USER1. EMP were committed when the session inserted a row into user2 .dept.
- B. The insert on user2.dept Is a recursive autonomous transaction by the child session and is committed.
- C. The inserts on USER 1 . EMP remain uncommitted when the session connected to pdb2.
- D. The inserts on USER1.EMP were rolled back when the session connected to pdb2.
- E. The insert on user2.dept is uncommitted.
- F. The inserts on USER1 . EMP were committed when the session connected to pdb2.
- G. The insert on user2.dept fails because of the active transaction in the parent container.
Answer: B,E
NEW QUESTION 106
Which three are true about Automatic Workload Repository (AWR) snapshots?
- A. They can be retained forever.
- B. They are generated if STATISTICS_LEVEL is set to TYPICAL.
- C. They are always created automatically.
- D. They are always created manually.
- E. They are generated if STATISTICS_LEVEL is set to ALL.
- F. They are generated if STATISTICS_LEVEL is set to BASIC.
Answer: B,C,E
NEW QUESTION 107
While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)
- A. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
- B. If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
- C. Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.
- D. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
- E. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
- F. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/
- G. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
Answer: B,C,D
Explanation:
Reference:
https://web.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/rcmtunin003.htm
NEW QUESTION 108
Choose two You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID ------------------------------------------------------------------------SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?
- A. Copy the password file from a sample file in the DBS dierectory
- B. Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
- C. Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.
- D. Re-create or migrate the password file to the Oracle Database 12c format
Answer: B,D
NEW QUESTION 109
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
- A. ItwillcreateaCDBwithrootopenedandseedmounted.
- B. ItwillcreateaCDBwithrootopenedandseedreadonly.
- C. It will create a CDB with root and seed opened and one PDB mounted.
- D. It will create a CDB that must be plugged into an existing CDB.
- E. It will create a multitenant container database (CDB) with only the root opened.
Answer: B
NEW QUESTION 110
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)
- A. A PDB snapshot is always a sparse copy of the source PDB.
- B. A PDB snapshot is always a full copy of the source PDB.
- C. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
- D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
- 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 only be stored on specific file systems.
Answer: B,F
Explanation:
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-pdb- snapshots.html#GUID-35B03C37-00BA-4945-BF20-9A7C4C541955
NEW QUESTION 111
Which three RMAN persistent settings can be set for a database?
- A. default backup device type
- B. multiple backup device types for a single backup
- C. default section size for backups
- D. default destinations for backups
- E. backup retention policy
Answer: A,D,E
NEW QUESTION 112
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
- A. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
- B. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
- C. 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.
- D. 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.
- E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
- F. An Oracle database can be restored from backup files copied using O/S utilities.
- G. 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.
Answer: B,E,G
NEW QUESTION 113
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:
What is the outcome?
- A. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
- B. Only CDB$ROOT and PDB$SEED are upgraded.
- C. It fails because PDB2 is not in UPGRADE state.
- D. It fails because PDB$SEED is in MIGRATE state.
- E. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
- F. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
Answer: B
NEW QUESTION 114
Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:
Which two are true?
- A. CDB$ROOT is in mount state.
- B. Redo logs are opened.
- C. PDB$SEED is in read only state.
- D. PDB1 and PDB2 are in read only state.
- E. PDB1 and PDB2 are in mount state.
Answer: B,D
NEW QUESTION 115
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:
Which three are true? (Choose three.)
- A. An application seed PDB is created for APP1.
- B. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
- C. A default service is created for the application root APP1.
- D. An application root PDB is created for APP1.
- E. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
- F. APP1 can never be unplugged.
Answer: A,B,E
NEW QUESTION 116
You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)
- A. All files in any previous FRA that have not yet been backed up, are backed up.
- B. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
- C. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.
- D. All files in any previous FRA that have been backed up already, are backed up.
- E. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
- F. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
- G. All files in the current FRA that have been backed up already, are backed up.
Answer: B,C,D
NEW QUESTION 117
......
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.
How much Oracle Database Administration II Exam Number: 1Z0-083 costs
- Types of questions: Performance Based Questions
- Passing Score: 60% or higher
- Examination Name: Oracle Database Administration II Exam Number: 1Z0-083
The New 1Z1-083 2022 Updated Verified Study Guides & Best Courses: https://www.prepawaypdf.com/Oracle/1Z1-083-practice-exam-dumps.html
Authentic 1Z1-083 Exam Dumps PDF - 2022 Updated: https://drive.google.com/open?id=10rlmP_ssow7wRrabRHgsLKt8ZqFkEHp1