[Jul 29, 2021] 1Z0-083 Dumps Full Questions - Exam Study Guide [Q21-Q46]

[Jul 29, 2021] 1Z0-083 Dumps Full Questions - Exam Study Guide

Oracle Database 19c  Free Certification Exam Material from itPass4sure with 160 Questions

NEW QUESTION 21
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 MOUNT state.
• B. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
• C. 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.
• D. An Oracle database can be restored from backup files copied using O/S utilities.
• E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
• F. 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.
• G. Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

Answer: A,B,E

 

NEW QUESTION 22
Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

• A. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
• B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
• C. A table's constraints must be disabled before issuing the flashback.
• D. A table's indexes must be set to unusable before issuing the flashback.
• E. Row Movement must be enabled on the table being flashed back.

Answer: A,B

 

NEW QUESTION 23
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

• A. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
• B. CDB1 and CDB2 must be in shared undo mode.
• C. Cloning HR_ROOT automatically clones HR_PDB1.
• D. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
• E. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

Answer: C,E

 

NEW QUESTION 24
Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

• A. database instance memory management and sizes
• B. SQL statements
• C. general operating system health
• D. log writer performance
• E. database writer performance

Answer: B

 

NEW QUESTION 25
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?

• A. The root password cannot be specified in a response file.
• B. The sudo password can be specified in a response file.
• C. root.sh can be executed automatically by the Database installer only if it is provided with root credentials.
• D. root.sh can be executed automatically by the Database installer only by using sudo credentials.
• E. The sudo password must be specified in a response file.
• F. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

Answer: B,C

 

NEW QUESTION 26
How do you configure a CDB for local undo mode?

• A. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.
• B. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
• C. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
• D. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.
• E. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

Answer: D

 

NEW QUESTION 27
Examine this configuration:
1. CDB1 and CDB2 are two container databases.
2. PDB1 is a pluggable database in CDB1.
3. PDB1_C1_SRV is a service for PDB1.
4. CDB1_LINK is a database link in CDB2 referring to PDB1.
5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK
SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');
Which two are true? (Choose two.)

• A. PDB1_C2_SRV will be created but not started.
• B. PDB1 will be created in CDB2 and left in MOUNT state.
• C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
• D. PDB1_C2_SRV will be created and started automatically.
• E. PDB1 will be created in CDB2 and automatically opened.

Answer: C,E

 

NEW QUESTION 28
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. CDB1 is shut down.
• D. Uncommitted transactions in CDB1 and pdbi have been rolled back.
• E. PDB1 is closed.

Answer: B,D

 

NEW QUESTION 29
Your database is in ARCHIVELOG mode and you plan to use Flashback Database.
Which two features or parameters manage space availability in the fast recovery area? (Choose two.)

• A. the backup optimization policy
• B. the DB_RECOVERY_FILE_DEST parameter setting
• C. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
• D. the archived log deletion policy
• E. using guaranteed UNDO retention
• F. the backup retention policy

Answer: C,F

 

NEW QUESTION 30
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? (Choose two.)

• A. after losing an UNDO tablespace that is in use
• B. after losing all copies of the control file
• C. after losing all members of the CURRENT online redo log group
• D. after losing a SYSAUX tablespace data file
• E. after losing all members of an INACTIVE online redo log group

Answer: B,E

 

NEW QUESTION 31
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

• A. Using the Data Recovery Advisor list failure command always requires that the database for which failures are to be listed is in mount state.
• B. Data Recovery Advisor can be used if a database is closed.
• C. A failure can be closed only when it has been repaired.
• D. Data Recovery Advisor can proactively check for failures.
• E. The Data Recovery Advisor change failure command can be used only to change failure priorities.

Answer: B,C

 

NEW QUESTION 32
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

• A. AWR data is stored in the SYSTEMtablespace.
• B. By default, AWR snapshots are retained for 7 days.
• C. The taking of AWR snapshots can be disabled.
• D. Its collection level is determined by the value of the STATISTICS_LEVELdatabase parameter.
• E. By default, AWR snapshots are taken every 60 minutes.

Answer: C,D,E

Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214

 

NEW QUESTION 33
Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A. It can recommend changes to improve the statistics gathering process.
• B. It runs automatically every night by default.
• C. It is part of the DBMS_STATS package.
• D. It is part of the DBMS_ADVISOR package.
• E. It always analyzes all schemas in the database.
• F. It can be run only manually.

Answer: A,C,F

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 34
Which two are true about Oracle instance recovery? (Choose three.)

• A. Recovery reads redo until the end of the redo thread. SMON rollsback any dead transactions, and then the datanase is opened.
• B. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
• C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
• D. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
• E. Recovery begins from the last checkpoint position that wascalculated by the Database Writer before instance failure.
• F. Recovery begins from the beginning of the CURRENT redo log group.

Answer: A,D,E

 

NEW QUESTION 35
Which two are true about data movement between a non-CDB and a PDB using Data Pump?

• A. Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.
• B. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
• C. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
• D. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
• E. A new PDB is automatically created when importing a non-CDB into a CDB.
• F. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

Answer: A,E

 

NEW QUESTION 36
Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

• A. defining primary keys for all tables to speed up all queries
• B. the configuration of storage arrays
• C. using check constraints to speed up updates
• D. defining foreign keys for all tables to speed up joins
• E. the physical data model

Answer: B,E

 

NEW QUESTION 37
Which three are true about an application seed pluggable database (PDB)?

• A. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
• B. It is not required in an application container.
• C. A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
• D. It cannot be added to an application container after the application container has already been created.
• E. It is automatically synchronized with its application root PDB when an application is installed.
• F. It Is automatically synchronized with its application root PDB when an application is upgraded.
• G. It cannot be dropped from its application container.

Answer: A,C,E

 

NEW QUESTION 38
Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

• A. Run the SQL Access Advisor.
• B. Run the Memory Advisor for the shared pool.
• C. Run the Memory Advisor for the Program Global Area.
• D. Run the SQL Tuning Advisor.
• E. Run the Memory Advisor for the System Global Area.

Answer: B

 

NEW QUESTION 39
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

• A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
• B. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
• C. CDB$ROOT and PDB$SEED are automatically duplicated.
• D. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
• E. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.

Answer: B,E

Explanation:
Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV430

 

NEW QUESTION 40
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

• A. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• B. to specify the list oftablespaces to include when creating a PDB from the CDB seed
• C. to include specific user tablespaces only when relocating a PDB
• D. to exclude a temp tablespace when plugging in a PDB
• E. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
• F. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.

Answer: B,D

 

NEW QUESTION 41
Examine this configuration:
* CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
* PDB$SEED is open READ ONLY
* PDB1 is open READ WRITE
* PDB2 is MOUNTED.
* ORACLE_HOME is /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. CDB1, PDB1, and PDB2 only
• B. CDB1 and PDB$SEED only
• C. CDB1, PDB$SEED, PDB1, and PDB2
• D. PDB$SEED, PDB1, and PDB2 only
• E. CDB1, PDB$SEED, and PDB1 only

Answer: E

 

NEW QUESTION 42
Which two are true about Oracle instance recovery? (Choose three.)

• A. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
• B. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
• C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
• D. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
• E. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
• F. Recovery begins from the beginning of the CURRENT redo log group.

Answer: A,D,E

 

NEW QUESTION 43
Which two are true about backup set compression using RMAN default compression? (Choose two.)

• A. Binary compression adds CPU overhead to backup operations.
• B. Unused blocks below the high water mark are backed up.
• C. Compression can be done only for locally managed tablespaces.
• D. Compressed backups cannot have a section size defined.
• E. Compressed backups can be written only to media.

Answer: A,B

 

NEW QUESTION 44
Examine this configuration:
1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are INACTIVE.
4. Redo log group 3 is the CURRENT group.
All members of redo log group 3 are lost before it is archived.
Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABSE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABSE OPEN
10.ALTER DATABASE OPEB RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

• A. 1, 3, 5, 7, 10
• B. 1, 2, 5, 7, 4, 10
• C. 1, 3, 5, 6, 9
• D. 1, 3, 5, 8, 6, 10
• E. 1, 3, 5, 6, 10

Answer: E

 

NEW QUESTION 45
The users tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace?

• A. Backups can be taken only if the database is in archivelog mode.
• B. The database must be registered in an RMAN catalog.
• C. Backups must be done incrementally.
• D. Only consistent backups can be created.
• E. Backups must be contained in backup sets.
• F. Backups can be done incrementally.

Answer: E,F

 

NEW QUESTION 46
......

Dumps Brief Outline Of The 1Z0-083 Exam: https://www.itpass4sure.com/1Z0-083-practice-exam.html

Use Real 1Z0-083 - 100% Cover Real Exam Questions: https://drive.google.com/open?id=15xYhH2j36KyvfMJ6L8eytT90W8iWmpj0