1Z0-083 Dumps 2022 - New Oracle 1Z0-083 Exam Questions
Free 1Z0-083 braindumps download (1Z0-083 exam dumps Free Updated)
NEW QUESTION 21
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 22
Examine this output:
Which two are true?
- A. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
- B. PDB1 is always limited to 40% of the available system resources regardless of demand.
- C. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- D. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- E. Any PDB not specified in the plan will be unable to execute statements in parallel.
- F. PDB3 can use all available parallel execution processes at times.
Answer: E
NEW QUESTION 23
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. Data Recovery Advisor can proactively check for failures.
- C. Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.
- D. A failure can be closed only when it has been repaired.
- E. The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.
Answer: B,E
NEW QUESTION 24
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
- A. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.
- B. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.
- C. SPFILE backups can be created while connected to an application root PDB.
- D. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
- E. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
Answer: D,E
NEW QUESTION 25
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. An application root PDB is created for APP1.
- D. APP1 can never be unplugged.
- E. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
- F. A default service is created for the application root APP1.
Answer: A,B,E
NEW QUESTION 26
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
- A. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
- B. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
- C. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
- D. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
- E. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
- F. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
Answer: A,B,E
Explanation:
Reference:
https://docs.oracle.com/database/121/TGDBA/tune_shared_pool.htm
NEW QUESTION 27
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. Multibyte character sets allow more efficient space utilization than single byte character sets.
- C. Single-byte character sets always use 7-bit encoding schemes.
- 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 28
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 container database in silent mode
- C. relocating a remote pluggable database in interactive mode
- D. cloning a remote pluggable database in silent mode
- E. cloning a remote container database in interactive mode
- F. relocating a remote container database in silent mode
- G. relocating a remote pluggable database in silent mode
Answer: B,C,G
NEW QUESTION 29
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 30
Which two are true about various Oracle security and auditing capabilities?
- A. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
- B. Unified auditing can be automatically synchronized to all application PDBs in an application container.
- C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch begin-end block.
- D. Application-common TSDP policies are always container specific.
- E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
Answer: A,C
NEW QUESTION 31
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 32
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
- A. It empties the RECYCLE BIN.
- B. It sets all user tablespaces to "read-only" before starting the upgrade.
- C. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- D. It increases tablespace size, if required, to meet upgrade requirements.
- E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
- F. It recompiles all stored PL/SQL code by using utlrp.sql.
Answer: C,D,F
Explanation:
Reference:
https://oracle-base.com/articles/12c/upgrading-to-12c
NEW QUESTION 33
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)
- A. SBT tape compression and RMAN backup compression should be used in parallel.
- 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 drive to be used simultaneously.
- D. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
- E. SBT tape compression can be used even if no RMAN compression is configured.
Answer: A,C
NEW QUESTION 34
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 Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- E. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
Answer: D,E
NEW QUESTION 35
Examine this configuration:
While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted.
To recover from this critical failure, you execute these commands:
What will be the outcome?
- A. It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
- B. It will fail because there is no autobackup of the controlfiles.
- C. It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
- D. It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
- E. It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
Answer: C
NEW QUESTION 36
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)
- A. SYSAUX tablespaces
- B. undo tablespaces
- C. the data dictionary in CDB$ROOT
- D. the log writer process (LGWR)
- E. temporary tablespaces
- F. the Process Monitor Process (PMON)
Answer: C,E,F
NEW QUESTION 37
Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)
- A. AWR reports can be generated while connected to any container.
- B. ADDM can run in a nonroot container.
- C. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
- D. AWR snapshots can be created in a PDB.
- E. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
- F. AWR snapshots can be created in CDB$ROOT.
Answer: A,C,D
NEW QUESTION 38
Which two are true about the Oracle dataabse methodology? (Choose two.)
- A. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
- B. SQL statements should always be tuned before tuning any file systems.
- C. The database instance memory should always be tuned before tuning any file systems.
- D. Tuning activities should stop once agreed service levels for performance have been met.
- E. The alert log should be used to find the database and instance areas most in need of tuning.
- F. Tuning activities should stop once the user is satisfied with performance.
Answer: D,E
Explanation:
Reference:
https://flylib.com/books/en/4.322.1.9/1/
NEW QUESTION 39
......
Verified 1Z0-083 dumps Q&As - Pass Guarantee Exam Dumps Test Engine: https://www.actual4labs.com/Oracle/1Z0-083-actual-exam-dumps.html
1Z0-083 Dumps for Pass Guaranteed - Pass 1Z0-083 Exam: https://drive.google.com/open?id=1UTE3Qp1anCWc8bhzRFY6VWMrulc9Ttft