[Jan 26, 2023] Fully Updated Oracle Database 19c (1Z0-083) Certification Sample Questions
Latest Oracle 1Z0-083 Real Exam Dumps PDF
Exam Topic for Oracle Database Administration II Exam Number: 1Z0-083
The following will be discussed in ORACLE 1Z0-083 exam dumps:
- Duplicating a Database
- Install Grid Infrastructure and Oracle Database
- Backup Strategies and Terminology
- Diagnosing Failures
- Backup and Duplicate
- Transporting Data
- Using Flashback Technologies
NEW QUESTION 64
Which three are true about Database Point-in-Time Recovery? (Choose three.)
- A. The database must be open RESETLOGS after Database Point-in-Time Recovery.
- B. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
- C. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
- D. The target point for the recovery must be specified as a stime or System Change Number (SCN).
- E. The Database must be in ARCHIVE LOG mode.
- F. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
Answer: A,C,E
NEW QUESTION 65
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 in all open PDBs except PDB$SEED.
- B. System statistics can be gathered only while connected to CDB$ROOT.
- C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
- D. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
- E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
Answer: C,D
Explanation:
Explanation
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%2
.
NEW QUESTION 66
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. Its collection level is determined by the value of the STATISTICS_LEVELdatabase parameter.
- B. AWR data is stored in the SYSTEMtablespace.
- C. By default, AWR snapshots are taken every 60 minutes.
- D. By default, AWR snapshots are retained for 7 days.
- E. The taking of AWR snapshots can be disabled.
Answer: A,C,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
NEW QUESTION 67
.Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?
- A. Oracle wallet for the encryption must be set up.
- B. The password for the encryption must be set up.
- C. Oracle Database Vault must be enabled.
- D. All the tablespaces in the database must be encrypted
Answer: A
NEW QUESTION 68
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
- A. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
- B. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
- C. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
- D. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
- E. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- F. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
Answer: C,D,E
Explanation:
Reference:
https://books.google.com.pk/books?id=0iwrL9P25Z0C&pg=PA35&lpg=PA35&dq=FLASHBACK+transaction
+query+requires+undo+to+retrieve+all+versions+of+a+row+that+existed+between+two+points+in
+time&source=bl&ots=MJnYl5CZ1u&sig=ACfU3U0dWP-NPd- U8uu3zbaoi3YZzT0FTQ&hl=en&sa=X&ved=2ahUKEwigi5_Jl9joAhXzUBUIHUh4DksQ6AEwAnoECAsQJg#v= onepage&q=FLASHBACK%20transaction%20query%20requires%20undo%20to%20retrieve%20all% 20versions%20of%20a%20row%20that%20existed%20between%20two%20points%20in%20time&f=false
https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm
NEW QUESTION 69
Examine this configuration:
1. CDB1is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
2. PDB$SEEDis open READ ONLY
3. PDB1is open READ WRITE
4. PDB2 is MOUNTED.
5. ORACLE_HOMEis /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:
For which databases will fixup scripts be created?
- A. CDB1and PDB$SEEDonly
- B. PDB$SEED, PDB1, and PDB2only
- C. CDB1, PDB$SEED, PDB1, and PDB2
- D. CDB1, PDB$SEED, and PDB1 only
- E. CDB1, PDB1, and PDB2only
Answer: D
NEW QUESTION 70
Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?
- A. undo tablespaces
- B. the log writer process (LGWR)
- C. the data dictionary in CDB$ROOT
- D. the Process Monitor Process (PMON)
- E. SYSAUX tablespaces
- F. temporary tablespaces
Answer: B,C,D
NEW QUESTION 71
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It is part of the DBMS_ADVISOR package.
- B. It can recommend changes to improve the statistics gathering process.
- C. It is part of the DBMS_STATS package.
- D. It always analyzes all schemas in the database.
- E. It can be run only manually.
- F. It runs automatically every night by default.
Answer: B,C,E
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 72
While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup istaking 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 noticeably lessthan an actual backup, then write I/O is a likely bottleneck.
- B. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/
- C. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
- D. 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.
- E. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.
- F. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
- G. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
Answer: A,D,G
NEW QUESTION 73
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
- A. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
- B. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
- C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
- D. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
- E. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- F. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
Answer: C,D,E
NEW QUESTION 74
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?
- A. By default, MMON creates an AWR snapshot every 30 minutes.
- B. AWR snapshots must be deleted when no longer required by ADDM.
- C. ADDM can recommend shrinking the buffer cache.
- D. By default, AWR snapshots are automatically purged after eight days.
- E. ADDM performs its analysis only when a DBA requests it.
- F. ADDM can recommend extending the buffer cache.
Answer: C,D,E
NEW QUESTION 75
choose three Which three are true about Transparent Data Encryption (TDE)?
- A. It stores the current and all past master keys in the keystore.
- B. It uses a single master key for a database.
- C. It encrypts only data on the client.
- D. It replaces secure application roles.
- E. It can encrypt data at the column level.
- F. Master encryption keys are managed by Oracle Database Vault.
Answer: A,E,F
NEW QUESTION 76
Choose two. 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?
- A. after losing a SYSAUX tablespace data file
- B. after losing an UNDO tablespace that is in use
- C. after losing all members of the CURRENT online redo log group
- D. after losing all members of an INACTIVE online redo log group
- E. after losing all copies of the control file
Answer: C,E
NEW QUESTION 77
Choose three. Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?
- A. It cannot be used to provision applications.
- B. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.
- C. It is an Oracle Grid Infrastructure service.
- D. It can be used to deploy Oracle Database homes.
- E. It cannot be used to provision middleware.
- F. It is an Oracle Database service.
Answer: B,C,D
NEW QUESTION 78
You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)
- A. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
- B. All files in any previous FRA that 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 the current 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 any previous FRA that have been backed up already, are backed up.
Answer: A,C,G
NEW QUESTION 79
choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE comman
- A. It fails because no parallel channels are allocated for the auxiliary databa
- B. Itsucceeds only if the target database is greater than 40
- C. It succeed
- D. No catalogued backup of the TARGET is used to duplicate the databa
- E. It fails because connection to the AUXILIARY instance must be as SYSD
Answer: C,D
NEW QUESTION 80
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)
- A. Data Recovery Advisor can be used if a database is closed.
- 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 proactively check for failures.
- 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: C,D
NEW QUESTION 81
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
- A. relocating a remote container database in interactive mode
- B. cloning a remote pluggable database in silent mode
- C. relocating a remote pluggable database in silent mode
- D. cloning a remote container database in interactive mode
- E. relocating a remote pluggable database in interactive mode
- F. relocating a remote container database in silent mode
- G. cloning a remote container database in silent mode
Answer: B,C,G
NEW QUESTION 82
Examine these queries and their output:
After a system crash, an instance restart and an attempted opening of the PDBs result in:
Which two are true? (Choose two.)
- A. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
- B. Data file 24 cannot be recovered while the CDB is opened.
- C. Data file 24 must be recovered while PDB2 is closed.
- D. Data file 24 must be recovered while the CDB is opened.
- E. Data file 24 can be recovered while PDB2 is opened.
Answer: D,E
Explanation:
Explanation
19c: PDB SYSTEM or UNDO Tablespace Recovery: The CDB and all other PDBs can be left opened. 1.
Connect to PDB 2. Shutdown abort the PDB, if its not automatically done. sqlplus sys@sales_pdb as sysdba sql> SHUTDOWN ABORT; OR ALTER PLUGGABLE DATABASE CLOSE ABORT; rman target sys@slaes_pdb rman> restore database; rman> recover database; rman> alter pluggable database sales_pdb open;
NEW QUESTION 83
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. Oracle DBCA templates can store only logical structure and not database files.
- B. New templates can only be created by modifying an existing user-created template.
- C. The Data Warehouse template is most suitable when transaction response time is the key criterion.
- D. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- E. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
Answer: D,E
Explanation:
Reference:
https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B22- 8BB67DCC9885.htm#ADMQS0235
NEW QUESTION 84
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 drop 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 version query requires that the recyclebin parameter be set to on.
- E. flashback transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- F. flashback version query requires undo to retrieve all versions of a row that existed between two points in time.
Answer: A,D,E
NEW QUESTION 85
Which three are true about opatchauto? (Choose three.)
- A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
- B. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
- C. Patches are applied via opatchauto.
- D. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
- E. Users must always input patch plans to opatchauto.
- F. It must be invoked by a user with root user privileges.
- G. It applies patches in nonrolling mode by default.
Answer: A,D,F
NEW QUESTION 86
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
- A. STATISTICS_LEVEL must be set to ALL to generate alerts.
- B. They are generated by SMON when a tablespace is 97% full.
- C. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
- D. A space usage management alert is automatically cleared after the underlying problem is resolved.
- E. Metrics are statistical counts for a specific unit.
- F. All metrics are instance related.
Answer: A,D,E
NEW QUESTION 87
......
Oracle 1Z0-083 Dumps - Secret To Pass in First Attempt: https://www.validbraindumps.com/1Z0-083-exam-prep.html
1Z0-083 Practice Test Questions Updated 279 Questions: https://drive.google.com/open?id=1Velpkn2ceV7zAleCgviZ2UvM53EMDFN-