New 2021 Guaranteed Success with TestSimulate 1Z1-083 Dumps Oracle PDF Questions

Exceptional Practice To Oracle Database Administration II Pass the First Time

NEW QUESTION 56
Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)

• A. It can be used to create container databases and non-container databases.
• B. It can be used to convert a non-container database to a container database.
• C. It can be launched from both the command line and the Universal Installer (OUI) interfaces.
• D. It can only be launched from the command line interface.
• E. It can be used to change the character set of an existing database.

Answer: D,E

 

NEW QUESTION 57
Which three are true about opatchauto? (Choose three.)

• A. It must be invoked by a user with root user privileges.
• B. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
• C. It applies patches in nonrolling mode by default.
• D. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
• E. Patches are applied via opatchauto.
• F. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
• G. Users must always input patch plans to opatchauto.

Answer: A,D,F

 

NEW QUESTION 58
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, PDB1, and PDB2 only
• B. CDB1, PDB$SEED, and PDB1 only
• C. CDB1, PDB$SEED, PDB1, and PDB2
• D. PDB$SEED, PDB1, and PDB2 only
• E. CDB1 and PDB$SEED only

Answer: D,E

 

NEW QUESTION 59
Which three are true about managing memory components in an Oracle database instance? (Choose three.)

• A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• B. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• C. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System 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 Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Answer: A,C,F

 

NEW QUESTION 60
A database is configured in ARCHIVELOGmode.
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 an archived log from after the most recent backup
• B. after losing the SYSTEMtablespace
• C. after losing all copies of the control file
• D. when any archived log from, before, or after the most recent backup is corrupt.
• E. after losing an archived log from before the most recent backup

Answer: D,E

 

NEW QUESTION 61
Which three are true about monitoring waits for sessions and services? (Choose three.)

• A. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
• B. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
• C. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
• 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$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

Answer: A,B,F

 

NEW QUESTION 62
Which two are true about RMAN encryption?

• A. RMAN can encrypt the Oracle Database password file.
• B. Password encryption can be persistently configured using the configure encryption command.
• C. The set encryption command overrides encryption settings specified by the configure encryption command.
• D. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
• E. RMAN encryption keys are stored in a database keystore.

Answer: C,E

 

NEW QUESTION 63
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

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

Answer: D,E,F

 

NEW QUESTION 64
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) that will be saved two years after the archival backup was taken.
• B. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
• C. All archive logs created after this backup are kept for two years.
• D. The SPFILEis included in the self-contaied archival backup.
• E. The restore point is a label for the system change number (SCN) before the archival backup was taken.
• F. The control file is included in the self-contained archival backup.

Answer: C,D,F

 

NEW QUESTION 65
You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

• A. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
• B. The insert on USER2.DEPT fails because of the active transaction in the parent container.
• C. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
• D. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
• E. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
• F. The insert on USER2.DEPT is uncommitted.
• G. The inserts on USER1.EMP were committed when the session connected to PDB2.

Answer: A,C

 

NEW QUESTION 66
Which four are true about RMAN backup sets?

• A. A backup piece can belong to only one backup set.
• B. Blocks from multiple data files can be contained in one backup set.
• C. A backup set can contain only one backup piece.
• D. A backup set must be written to disk.
• E. Blocks from multiple data files can be contained in one backup piece.
• F. A data file can be split into multiple sections stored in different backup sets.
• G. A backup set must be written to media.
• H. A data file can be split into multiple sections stored in different backup pieces in the same backup set.

Answer: A,D,E,F

 

NEW QUESTION 67
Which two are true about common objects? (Choose two.)

• A. They can be created only in an application root.
• B. They can be only metadata-linked in an application container.
• C. They can exist in user-defined schemas only in application containers.
• D. They can exist in CDB$ROOT and an application root.
• E. They can be created only in CDB$ROOT.
• F. They can be extended data-linked in CDB$ROOT.

Answer: A,D

 

NEW QUESTION 68
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. Addonly the CREATE_FILE_DEST clause to the statement.
• B. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• C. Set only the PDB_FILE_NAME_CONVERT parameter.
• D. Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)
• E. Enable only OMF.
• F. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

Answer: A,E,F

 

NEW QUESTION 69
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
(Choose two.)

• A. The solution that best optimizes one SQL statement can degrade the performance of others.
• B. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
• C. SQL statements doing joins always do more physical I/O than single table queries.
• D. SQL statements doing only logical reads never require tuning because they do no physical I/O.
• E. Poorly performing SQL statements can be tuned automatically by the Oracle server.

Answer: D,E

 

NEW QUESTION 70
Which three are true about opatchauto?

• A. It applies patches in nonrolling mode by default.
• B. Patchsets are applied via opatchauto.
• 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. It must be invoked by a user with root user privileges.
• E. It Is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
• F. Users must always input patch plans to opatchauto.
• G. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

Answer: A,B,G

 

NEW QUESTION 71
......

1Z1-083 EXAM DUMPS WITH GUARANTEED SUCCESS: https://www.testsimulate.com/1Z1-083-study-materials.html