TestBraindump 1Z1-083 dumps & Oracle Database 19c Sure Practice with 160 Questions
New 1Z1-083 Exam Questions| Real 1Z1-083 Dumps
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.
NEW QUESTION 15
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 create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
- C. It will fail because there is no autobackup of the controlfiles.
- D. It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
- E. It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
Answer: D
NEW QUESTION 16
Which three are true about opatchauto?
- A. It must be invoked by a user with root user privileges.
- B. It applies patches in nonrolling mode by default.
- C. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
- D. Patchsets are applied via opatchauto.
- E. Users must always input patch plans to opatchauto.
- F. It Is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
- G. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
Answer: B,D,G
NEW QUESTION 17
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 18
Which two are true about gathering optimizer statistics? (Choose two.)
- A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
- B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
- C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
- D. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
- E. System statistics can be gathered only while connected to CDB$ROOT.
Answer: A,D
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 19
Examine this configuration:
1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCL uses disk group +FRA for 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 and the +DATA and +FRA disk groups are started.
- B. Only the ORCL database and the ASM instances are started.
- C. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
- D. Only the ORCL database instance is started.
- E. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
Answer: C
NEW QUESTION 20
Which two are true about Recovery Manager (RMAN) diagnostic message output?
- A. Media Management messages for SBT devices are always written to sbtio.log.
- B. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
- C. Media Management messages for SBT devices are written to an Oracle trace file.
- D. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
- E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
- F. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
Answer: A,C
NEW QUESTION 21
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. The taking of AWR snapshots can be disabled.
- B. By default, AWR snapshots are taken every 60 minutes.
- C. AWR data is stored in the SYSTEM tablespace.
- D. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
- E. By default, AWR snapshots are retained for 7 days.
Answer: A,B,D
Explanation:
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
NEW QUESTION 22
Which three activities are possible for PDBs? (Choose three.)
- A. converting an application container into another application container in the same CDB
- B. converting an application PDB to an application seed
- C. converting an application PDB to an application root
- D. converting an application PDB to a regular PDB
- E. converting an application seed to an application PDB
- F. converting a regular PDB to an application PDB
- G. converting an application container into another application container in a different CDB
Answer: A,D,F
NEW QUESTION 23
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. V$SESSTAT
- B. V$SESSION_WAIT_CLASS
- C. V$SESSION_EVENT
- D. V$SESSION
- E. V$SESSION_WAIT
Answer: C
Explanation:
Reference:
https://docs.oracle.com/cd/E29597_01/server.1111/e16638/instance_tune.htm
NEW QUESTION 24
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. PDB1 data files already exist in the correct location.
- B. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
- C. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
- D. PDB1 must be dropped from CDB1.
- E. PDB_FILE_NAME_CONVERT must be set before executing the command.
Answer: A,D
NEW QUESTION 25
Which two are true about automatic block repair?
- A. It is not possible for media corrupt blocks.
- B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
- C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
- D. Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.
- E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
Answer: A,E
NEW QUESTION 26
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?
- A. All archive logs created after this backup are kept for two years.
- B. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
- C. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
- D. The control file is included in the self-contained archival backup.
- E. The spfile 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,D,E
NEW QUESTION 27
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)
- A. Media Management messages for SBT devices are always written to sbtio.log.
- B. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
- C. Media Management messages for SBT devices are written to an Oracle trace file.
- D. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
- E. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
- F. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
Answer: C,D
NEW QUESTION 28
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)
- A. orainstRoot.shcan be executed automatically by the Database installer by using sudoor root credentials.
- B. The rootpassword cannot be specified in a response file.
- C. The sudopassword must be specified in a response file.
- D. root.shcan be executed automatically by the Database Installer only if it is provided with root credentials.
- E. root.shcan be executed automatically by the Database installer only by using sudocredentials.
- F. The sudopassword can be specified in a response file.
Answer: A,B
Explanation:
Explanation
NEW QUESTION 29
Which two are true about changing the LOCAL_UNDO_ENABLEDproperty to false in a CDB? (Choose two.)
- A. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
- B. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
- C. Undo tablespaces existing in PDBs must be dropped before the change.
- D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
- E. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- F. After the change, only one undo tablespace can exist in CDB$ROOT.
Answer: B,D
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/creating-and-configuring-a- cdb.html#GUID-12ADA04D-F81D-4579-A68C-0958CC7D6C2F
NEW QUESTION 30
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
- A. A backup of the target database is always required.
- B. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
- C. A connection to the target database instance is always required.
- D. A subset of the target database can be duplicated.
- E. A connection to an auxiliary instance is always required.
- F. Duplication can be done by having the auxiliary databaseinstance pull backup sets from the target database instance.
- G. A connection tothe recovery catalog instance is always required.
- H. A new DBID is always created for the duplicated database.
Answer: A,B,E,F
NEW QUESTION 31
Examine this configuration:
You execute these commands before upgrading the database to the current release:
For which databases will fixup scripts be created?
- A. CDB1, PDB$SEED, PDB1, and PDB2
- B. CDB1, PDB$SEED, and PDB1 only
- C. PDB$SEED, PDB1, and PDB2 only
- D. CDB1 and PDB$SEED only
- E. CDB1, PDB1, and PDB2 only
Answer: D
NEW QUESTION 32
......
How much Oracle Database Administration II Exam Number: 1Z0-083 costs
- Types of questions: Performance Based Questions
- Examination Name: Oracle Database Administration II Exam Number: 1Z0-083
- Examination Fees: $250 USD
- Length of Exam: 150 min
- No. of Questions: 85 Questions
- Passing Score: 60% or higher
Oracle 1Z1-083 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
1Z1-083 Braindumps – 1Z1-083 Questions to Get Better Grades: https://www.testbraindump.com/1Z1-083-exam-prep.html
Get New 1Z1-083 Certification – Valid Exam Dumps Questions: https://drive.google.com/open?id=1nY2Terr0--R2pqHmLU7rQrfUPkkq9sCn
