[Jan-2022] 1Z1-083 Braindumps – 1Z1-083 Questions to Get Better Grades
1Z1-083 Exam Dumps - Try Best 1Z1-083 Exam Questions - PracticeMaterial
NEW QUESTION 41
Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)
- A. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
- B. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
- C. The entire PGA is located in the System Global Area (SGA) when using shared servers.
- D. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
- E. Sorts and Hash Joins use PGA memory.
Answer: A,B
NEW QUESTION 42
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)
- A. CDB$ROOT and PDB$SEED are automatically duplicated.
- B. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
- C. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
- D. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
- E. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
Answer: C,D
NEW QUESTION 43
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 PDB1 have been rolled back.
- B. CDB1 is in mount state
- C. PDB1 is closed.
- D. CDB1 is shut down.
- E. Uncommitted transactions in CDB1 and pdbi have been rolled back.
Answer: B,E
NEW QUESTION 44
Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose two.)
- A. It uses a single RPM that automatically extracts and installs the Oracle Database software.
- B. It can only install and configure Oracle Database software. The database has to be created separately.
- C. It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.
- D. It can be used for both Oracle Database and Oracle Grid Infrastructure installation.
- E. It does not require the setup wizard.
Answer: C,D
NEW QUESTION 45
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 fails because of the active transaction in the parent container.
- C. The inserts on USER1.EMP were rolled back when the session connected to pdb2.
- D. The insert on user2.dept Is a recursive autonomous transaction by the child session and is committed.
- E. The inserts on USER 1 . EMP remain uncommitted when the session connected to pdb2.
- F. The inserts on USER1 . EMP were committed when the session connected to pdb2.
- G. The insert on user2.dept is uncommitted.
Answer: D,G
NEW QUESTION 46
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
- B. An existing Oracle base can be used.
- C. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
- D. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
- E. Only the griduser can perform the upgrade.
- F. Existing Oracle Database instances must be shut down before starting the upgrade.
Answer: C,E,F
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/CWLIN/procstop.htm#CEGEDCDB
NEW QUESTION 47
A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?
- A. VSSESSTAT
- B. VSSESSION_WAIT_CLASS
- C. VSSESSION_EVENT
- D. V$SESSION_WAIT
- E. VSSESSION
Answer: D
NEW QUESTION 48
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
- A. Data Recovery Advisor can be used if a database is closed.
- B. The Data Recovery Advisor change failure command can be used only to change failure priorities.
- 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. Data Recovery Advisor can proactively check for failures.
Answer: A,E
NEW QUESTION 49
Which three are true about monitoring waits for sessions and services? (Choose three.)
- A. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
- B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
- C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
- D. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
- E. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
- F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
Answer: A,B,E
NEW QUESTION 50
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)
- A. It provides before and after execution statistics for each SQL statement in the analysis task
- B. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
- C. It is integrated with the SQL Access Advisor.
- D. SQL statements that were originally run concurrently are run concurrently by SPA.
- E. It predicts the impact of system changes on SQL workload response time.
Answer: B,E
NEW QUESTION 51
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. PDB_FILE_NAME_CONVERT must be set before executing the command.
- B. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
- C. PDB1 must be dropped from CDB1.
- D. PDB1 data files already exist in the correct location.
- E. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
Answer: A,B
NEW QUESTION 52
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 must be recovered while PDB2 is closed.
- B. Data file 24 can be recovered while PDB2 is opened.
- C. Data file 24 must be recovered while the CDB is opened.
- D. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
- E. Data file 24 cannot be recovered while the CDB is opened.
Answer: C,E
NEW QUESTION 53
Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
- A. A lost PFILE can be re-created alert.log using SQL*PLUS.
- B. A lost password file can be manually re-created with the orapwd utility.
- C. A lost index tablespace can be re-created without performing any recovery.
- D. A lost password file can be re-created with SQL*PLUS.
- E. A lost SPFILE can be recovered from memory using SQL*PLUS.
- F. A lost TEMPFILE must always be re-created manually.
Answer: A,B,D
NEW QUESTION 54
Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?
- A. the configuration of storage arrays
- B. defining primary keys for all tables to speed up all queries
- C. the physical data model
- D. using check constraints to speed up updates
- E. defining foreign keys for all tables to speed up joins
Answer: C,E
NEW QUESTION 55
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLEDdatabase property is set to FALSEin the CDB.
Data file 24 of PDB2was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASEcommand while connected to CDB$ROOT.
Which three are true? (Choose three.)
- A. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- B. Data file 24 can be recovered while connected to PDB2.
- C. Data file 24 can be restored only while connected to CDB$ROOT.
- D. Data file 24 can be recovered while connected to CDB$ROOT.
- E. Data file 24 can be recovered only while connected to PDB2.
- F. Data file 24 can be restored only while connected to PDB2.
Answer: A,D,F
NEW QUESTION 56
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It is part of the DBMS_ADVISOR package.
- B. It is part of the DBMS_STATS package.
- 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 manually.
- F. It always analyzes all schemas in the database.
Answer: B,C,D
Explanation:
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
NEW QUESTION 57
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 all members of the current online redo log group
- B. after losing an undo tablespace that is in use
- C. after losing a sysaux tablespace data file
- 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 58
Which three are true about Database Point-in-Time Recovery? (Choose three.)
- A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
- B. The database must be open RESETLOGS after Database Point-in-Time Recovery.
- C. The target point for the recovery must be specified as a stime or System Change Number (SCN).
- D. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
- E. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
- F. The Database must be in ARCHIVELOG mode.
Answer: B,D,F
Explanation:
Explanation
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%
NEW QUESTION 59
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
- A. ADDM can recommend shrinking the buffer cache.
- B. AWR snapshots must be deleted when no longer required by ADDM.
- C. By default, AWR snapshots are automatically purged after eight days.
- D. ADDM performs its analysis only when a DBA requests it.
- E. ADDM can recommend extending the buffer cache.
- F. By default, MMON creates an AWR snapshot every 30 minutes.
Answer: A,B,C
NEW QUESTION 60
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 silent mode
- B. relocating a remote pluggable database in interactive mode
- C. cloning a remote container database in interactive mode
- D. relocating a remote pluggable database in silent mode
- E. relocating a remote container database in interactive mode
- F. cloning a remote pluggable database in silent mode
- G. cloning a remote container database in silent mode
Answer: D,F,G
Explanation:
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/clone-pdbs-using-dbca-silent- mode/index.html? learningpath=true&appuser=nobody&appsession=170971049395&contentid=26693&activityname=Clone% 20PDBs%20using%20DBCA%20in%20Silent%20Mode&eventid=6352
NEW QUESTION 61
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. All archive logs created after this backup are kept for two years.
- B. The SPFILE is included in the self-contaied archival backup.
- C. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
- D. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
- E. The control file is included in the self-contained archival backup.
- F. The restore point is a label for the system change number (SCN) before the archival backup was taken.
Answer: A,B,E
NEW QUESTION 62
Examine this output:
Which two are true? (Choose two.)
- A. Any PDB not specified in the plan will be unable to execute statements in parallel.
- B. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- C. PDB1is always limited to 40% of the available system resources regardless of demand.
- D. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
- E. PDB2is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- F. PDB3 can use all available parallel execution processes at times.
Answer: A,D
NEW QUESTION 63
Which three are true about Automatic Workload Repository (AWR)?
- A. Its collection level is determined by the value of the statistics_level database parameter.
- B. The taking of AWR snapshots can be disabled.
- C. AWR data is stored in the system tablespace.
- D. By default, AWR snapshots are taken every 60 minutes.
- E. By default, AWR snapshots are retained for 7 days.
Answer: A,B,D
NEW QUESTION 64
In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)
- A. issuing multiple savepoints during a transaction
- B. poorly written SQL
- C. the number of data files containing extents belonging to tables updated by a transaction
- D. poorly trained users who do not commit transactions
- E. the number of tablespaces containing tables updated by a transaction
Answer: B,E
NEW QUESTION 65
Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)
- A. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
- B. AWR snapshots can be created in a PDB.
- C. AWR reports can be generated while connected to any container.
- D. AWR snapshots can be created in CDB$ROOT.
- E. ADDM can run in a nonroot container.
- F. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
Answer: A,B,C
NEW QUESTION 66
......
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:
- Oracle Database: Deploy, Patch and Upgrade Workshop
- Restore and Recovery Concepts
- Diagnosing Failures
- Using Flashback Technologies
- Duplicating a Database
- RMAN Troubleshooting and Tuning
- Patching Grid Infrastructure and Oracle Database
- Transporting Data
- Performing Recovery
- Creating an Oracle Database by using DBCA
Verified 1Z1-083 exam dumps Q&As with Correct 160 Questions and Answers: https://www.practicematerial.com/1Z1-083-exam-materials.html
Get New 1Z1-083 Certification – Valid Exam Dumps Questions: https://drive.google.com/open?id=11ScYBczoDdW3fAD_8uBwo2IahgdyAWMv
