1Z0-083 Dumps 2022 - New Oracle 1Z0-083 Exam Questions
Free 1Z0-083 Braindumps Download Updated on Jan 17, 2022 with 160 Questions
NEW QUESTION 71
Examine this configuration:
1. CDB1is a container database.
2. PDB1 and PDB2are pluggable databases in CDB1.
3. PDB1 and PDB2are OPENin READ WRITEmode.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. CDB1is shut down.
- B. Uncommitted transactions in PDB1have been rolled back.
- C. PDB1is closed.
- D. Uncommitted transactions in CDB1and PDB1have been rolled back.
- E. CDB1is in MOUNT state
Answer: C,E
NEW QUESTION 72
Which three are true about the SQL Tuning Advisor? (Choose three.)
- A. It can recommend semantic changes to SQL statements.
- B. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
- C. It checks each query being analyzed for stale statistics.
- D. It only recommends syntactic changes to SQL statements.
- E. It checks each query being analyzed for missing statistics.
- F. It considers all SQL statements being analyzed by the advisor task as a group.
Answer: B,C,E
NEW QUESTION 73
PDB1 and PBD2 are pluggable databases in CDB1.
Examine these commands:
CDB1 is then restarted.
Which three are true? (Choose three.)
- A. PDB2 will be opened READ WRITE.
- B. PDB$SEED will be MOUNTED.
- C. PDB$SEED will be opened READ ONLY.
- D. PDB1 will be MOUNTED.
- E. PDB1 will be opened READ WRITE.
- F. PDB2 will be MOUNTED.
Answer: A,C,E
NEW QUESTION 74
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true?
- A. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
- B. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- C. These backups can be written to disk or SBT.
- D. All non-Oracle files in the current FRAthat have not been backed up already, are backed up.
- E. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
Answer: A
NEW QUESTION 75
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
- A. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
- B. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
- 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 version query requires that the RECYCLEBIN parameter be set to ON.
Answer: C,D,E
NEW QUESTION 76
Which three are true about Database Point-in-Time Recovery?
- A. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
- B. The target point for the recovery must be specified as a time or System Change Number (SCN).
- C. The database must be in mount state when performing Database Point-in-Time Recovery.
- D. The database must be open resetlogs after Database Point-in-Time Recovery.
- E. The database must be in archivelog mode.
- F. The database must have flashback database on to perform Database Point-in-Time Recovery.
Answer: B,D,E
NEW QUESTION 77
Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
3. PDB1 and PDB2 are open in read write mode.
You execute these commands successfully:
Which two are true?
- A. Uncommitted transactions in CDB1 and pdbi have been rolled back.
- B. CDB1 is in mount state
- C. CDB1 is shut down.
- D. PDB1 is closed.
- E. Uncommitted transactions in PDB1 have been rolled back.
Answer: A,B
NEW QUESTION 78
Which two are true about Oracle Database Configuration Assistant (DBCA) templates?
- A. The Data Warehouse template is most suitable when transaction response time is the key criterion.
- B. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
- C. Oracle DBCA templates can store only logical structure and not database files.
- D. The General Purpose or Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- E. New templates can only be created by modifying an existing user-created template.
Answer: B,C
NEW QUESTION 79
Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:
Which two are true? (Choose two.)
- A. The REVENUE table partitions are not pruned across the PDBs automatically.
- B. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
- C. The REVENUE table must be a list-partitioned table.
- D. The CONTAINERS clause cannot be used in queries on the REVENUE table.
- E. A container map exists for the REVENUE table, but is not enabled.
- F. The MAPTABLE table is a metadata-linked table.
Answer: B,E
NEW QUESTION 80
You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:
Which three are true? (Choose three.)
- A. The restore point is a label for the system change number (SCN) before the archival backup was taken.
- B. The SPFILE is included in the self-contaied archival backup.
- C. The control file is included in the self-contained archival backup.
- D. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
- E. All archive logs created after this backup are kept for two years.
- F. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
Answer: B,C,E
NEW QUESTION 81
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. after losing the SYSTEM tablespace
- C. after losing an archived log from before the most recent backup
- D. after losing an archived log from after the most recent backup
- E. when any archived log from, before, or after the most recent backup is corrupt.
Answer: C,E
NEW QUESTION 82
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)
- A. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
- B. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
- C. A snapshot copy PDB can be created from a stand-alone clone PDB.
- D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
- E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
- F. A PDB snapshot is always a sparse copy of the source PDB.
- G. A PDB snapshot is always a full copy of the source PDB.
Answer: A,C
NEW QUESTION 83
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- B. Oracle DBCA templates can store only logical structure and not database files.
- C. The Data Warehouse template is most suitable when transaction response time is the key criterion.
- D. Oracle DBCAtemplates can be used to create new databases and duplicate existing databases.
- E. New templates can only be created by modifying an existing user-created template.
Answer: A,D
NEW QUESTION 84
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)
- A. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
- B. The root password cannot be specified in a response file.
- C. root.sh can be executed automatically by the Database installer only by using sudo credentials.
- D. The sudo password must be specified in a response file.
- E. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
- F. The sudo password can be specified in a response file.
Answer: A,B
NEW QUESTION 85
Which two are true about gathering optimizer statistics? (Choose two.)
- A. System statistics can be gathered only while connected to CDB$ROOT.
- B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
- 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 PDBs except PDB$SEED.
- E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in 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 86
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 the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
- C. Enable only OMF.
- D. Add only the CREATE_FILE_DEST clause to the statement.
- E. Set only the PDB_FILE_NAME_CONVERT parameter.
- F. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
Answer: A,C,D
NEW QUESTION 87
Which two are true about the Optimizer Statistics Advisor?
- A. It can be run only manually.
- B. It always analyzes all schemas in the database.
- 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 automatically.
Answer: C,E
NEW QUESTION 88
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)
- A. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
- B. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- C. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
- D. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- E. These backups can be written to disk or SBT.
Answer: C,E
NEW QUESTION 89
Which two are true about gathering optimizer statistics?
- A. Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open PDBs except pdb$seed.
- B. Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open pluggable databases (PDBs).
- C. Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics only in cdbSroot.
- D. System statistics can be gathered only while connected to cdb$root.
- E. Executing dbms_stats.gather_database_stats while connected to a PDBopened in read/write mode gathers object statistics for that PDB.
Answer: B,C
NEW QUESTION 90
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)?
- A. 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.
- B. Backing up a database in noarchivelog mode using O/S utilities requires that the database instance be started and the database be in mount state.
- C. 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.
- D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as image copies.
- E. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
- F. An Oracle database can be restored from backup files copied using O/S utilities.
- G. Backing up a database in noarchivelog mode using O/S utilities requires that the database instance be shut down.
Answer: D,E,F
NEW QUESTION 91
Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)
- A. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)
- B. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
- C. Space is always reclaimed proactively before space pressure occurs.
- D. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
- E. Space might be reclaimed proactively before space pressure occurs.
Answer: A,D
NEW QUESTION 92
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
- A. 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.
- B. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance bestarted and the dataabse be in the MOUNT state.
- C. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
- D. 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.
- E. Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
- F. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
- G. An Oracle database can be restored from backup files copied using O/S utilities.
Answer: C,D,F
NEW QUESTION 93
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
- A. to specify the list oftablespaces to include when creating a PDB from the CDB seed
- B. to exclude a temp tablespace when plugging in 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 include specific user tablespaces only when relocating a PDB
- F. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
Answer: A,B
NEW QUESTION 94
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
- A. A space usage management alert is automatically cleared after the underlying problem is resolved.
- B. All metrics are instance related.
- C. They are generated by SMON when a tablespace is 97% full.
- D. STATISTICS_LEVEL must be set to ALL to generate alerts.
- E. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
- F. Metrics are statistical counts for a specific unit.
Answer: A,E,F
Explanation:
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2
NEW QUESTION 95
Examine this configuration:
1. The ORCLdatabase data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCLuses disk group +FRAfor the Fast Recovery Area.
3. LISTENER is the listener for ORCL.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:
What is the outcome?
- A. Only the ORCL database instance is started.
- B. Only the ORCLdatabase instance, the Oracle ASM instance, and the +DATAand +FRAdisk groups are started.
- C. Only the ORCLdatabase and the ASM instances are started.
- D. The ORCL database, the Oracle ASM instances, the +DATAand +FRAdisk groups, and the LISTENER are started.
- E. Only the ORCLdatabase instance and the +DATAand +FRAdisk groups are started.
Answer: B
NEW QUESTION 96
......
How much Oracle Database Administration II Exam Number: 1Z0-083 costs
- No. of Questions: 85 Questions
- Types of questions: Performance Based Questions
- Examination Fees: $250 USD
- Length of Exam: 150 min
Oracle 1Z0-083 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083
The following will be discussed in the ORACLE 1Z0-083 dumps:
- RMAN Troubleshooting and Tuning
- Transporting Data
- Oracle Database: Deploy, Patch and Upgrade Workshop
- Creating an Oracle Database by using DBCA
- Patching Grid Infrastructure and Oracle Database
Oracle 1Z0-083 Exam Practice Test Questions: https://www.practicetorrent.com/1Z0-083-practice-exam-torrent.html
Updated Certification Exam 1Z0-083 Dumps - Practice Test Questions: https://drive.google.com/open?id=1TdcmdJUsut9Fs1YtHzwlyO5L01W_MQcv