• Home
  • Articles
  • [Dec 08, 2021] Reliable 1Z0-083 Exam Tips Test Pdf Exam Material [Q45-Q70]

[Dec 08, 2021] Reliable 1Z0-083 Exam Tips Test Pdf Exam Material [Q45-Q70]

Share

[Dec 08, 2021] Reliable 1Z0-083 Exam Tips Test Pdf Exam Material

New 2021 1Z0-083 Test Tutorial (Updated 160 Questions)


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:

  • Configure your Database to support Flashback
  • Duplicate Databases
  • Using Flashback Technologies - Oracle Database: Backup and Recovery Workshop
  • Configure and using an RMAN recovery catalog
  • Restore and Recovery Concepts - Oracle Database: Backup and Recovery Workshop
  • Employ the best Oracle Database recovery technology for your failure situation
  • Configuring and using RMAN - Oracle Database: Backup and Recovery Workshop
  • Configure RMAN and the Database for Recoverability
  • Diagnosing Failures - Oracle Database: Backup and Recovery Workshop
  • Diagnosing Database Issues
  • Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry
  • Detect and repair database and database block corruption
  • Perform flashback operations
  • Duplicating a Database - Oracle Database: Backup and Recovery Workshop

 

NEW QUESTION 45
Which two are true about unplugging an application container from a container database and plugging it into a different container database?

  • A. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.
  • B. It requires local undo mode in both container databases.
  • C. Unplugging the application root from a CDB unplugs all its application PDBs.
  • D. It requires only local undo mode in the database where the application container will be unplugged.
  • E. Plugging the application root into a different CDB plugs In all its application PDBs.
  • F. Application PDBs In the application container must be unplugged before the application root Is unplugged.

Answer: C,F

 

NEW QUESTION 46
Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

  • A. Results are written to the alert log.
  • B. It analyzes a period of time corresponding to the last day of activity.
  • C. It runs automatically after each AWR snapshot.
  • D. A DBA can run it manually.
  • E. It analyzes a period of time corresponding to the 12 hours of activity.

Answer: A,C

 

NEW QUESTION 47
Which three are located by using environment variables? (Choose three.)

  • A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
  • B. default directories for temporary files used by temporary tablespaces
  • C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
  • D. the maximum number of database files that can be opened by a database instance
  • E. the temporary disk space used by Oracle Installer during installation
  • F. the location of Oracle Net Services configuration files

Answer: B,D,F

 

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

  • A. It is automatically synchronized with its application root PDB when an application is installed.
  • B. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
  • 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 not required in an application container.
  • 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 49
You must transport the university tablespace from one database to another. The university tablespace is currently open read/write. The source and destination platforms have different endian formats. Examine this list of actions:
1. Make the university tablespace read-only on the source system.
2. Export the university tablespace metadata using expdp.
3. Convert the university tablespace data files to the destination platform format using RMANon the source system.
4. Copy the university tablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the university tablespace data files to the destination platform format using RMANon the destination system.
7. Import the university tablespace metadata using impdp.
8. Make the university tablespace read/write on the destination system.
Which are the minimum number of actions required, in the correct order, to transport the university tablespace?

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

Answer: E

 

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

  • A. cdb$root and pdbSseed are automatically duplicated.
  • B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
  • C. The auxiliary Instance is automatically created with enable_pluggable_database = true.
  • D. Two or more PDBs can be duplicated with the same rmak duplicate command.
  • E. A user with sysdba or sysbkup must be logged in with RMAN to the PDB to duplicate it.

Answer: B,D

 

NEW QUESTION 51
Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true?

  • A. PDB1 and PDB2 are in mount state.
  • B. PDB1 and PDB2 are in read only state.
  • C. CDB$ROOT is in mount state.
  • D. Redo logs are opened.
  • E. PDB$SEED is in read only state.

Answer: C,D

 

NEW QUESTION 52
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

  • A. AWR snapshots must be deleted when no longer required by ADDM.
  • B. ADDM can recommend extending the buffer cache.
  • C. ADDM performs its analysis only when a DBA requests it.
  • D. By default, AWR snapshots are automatically purged after eight days.
  • E. By default, MMON creates an AWR snapshot every 30 minutes.
  • F. ADDM can recommend shrinking the buffer cache.

Answer: B,D,F

 

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

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

Answer: C,F

 

NEW QUESTION 54
Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

  • A. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
  • B. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
  • C. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
  • D. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
  • E. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
  • F. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
  • G. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
  • H. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.

Answer: B,D,G,H

 

NEW QUESTION 55
Examine this configuration:
CDB1 is a container database.
COMMON_USER_PREFIX is C##.
PDB1 is a pluggable database contained in CDB1.
APP1_ROOT is an application container contained in CDB1.
APP1_PDB1 is an application PDB contained in APP1_ROOT.
You execute these commands successfully:

Which two are true? (Choose two.)

  • A. P1_USER1 can be created in CDB1.
  • B. C##_APP_USER1 can be created in CDB1.
  • C. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.
  • D. APP1_USER1 can be created in PDB1.
  • E. APP1_USER1 can be created in CDB1.
  • F. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

Answer: C,F

 

NEW QUESTION 56
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, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
  • B. Only the ORCL database instance and the +DATA and +FRA disk groups are started.
  • C. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
  • D. Only the ORCL database and the ASM instances are started.
  • E. Only the ORCL database instance is started.

Answer: A

 

NEW QUESTION 57
Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

  • A. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.
  • B. It can be used for applications and middleware.
  • C. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.
  • D. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.
  • E. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.

Answer: C,D

Explanation:
Explanation
Reference https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwadd/rapid-homeprovisioning.
html#GUID-CCEC5960-EDA4-4A3F-9643-0CA308EA49AA

 

NEW QUESTION 58
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 SPFILE is included in the self-contaied archival backup.
  • C. The restore point is a label for the system change number (SCN) before 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. All archive logs created after this backup are kept for two years.

Answer: B,E,F

 

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

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

 

NEW QUESTION 60
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.
Examine these steps:
1. Install the SALES_APP application, including the common tables, in the application root.
2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
3. Create an application seed.
4. Install the SALES_APP application in the application seed.
5. Create the SALES_APP1 and SALES_APP2 application PDBs.
6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
8. Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence?

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

Answer: C

 

NEW QUESTION 61
Examine this command:
$ rhpctl move database -sourcehorae Oracle_horne_path -destinationhome Oracle_home_path For which two purposes can you use this command?

  • A. to switch to a read-only Oracle home
  • B. to switch back to the previous Oracle home as part of a rollback operation
  • C. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
  • D. to switch to a patched Oracle Database home
  • E. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server

Answer: A,E

 

NEW QUESTION 62
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)

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

Answer: A,E

 

NEW QUESTION 63
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

  • A. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
  • B. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
  • C. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
  • D. These backups can be written to disk or SBT.
  • E. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.

Answer: C,D

Explanation:
https://blog.toadworld.com/rman_-_using_the_flash_recovery_area

 

NEW QUESTION 64
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

  • A. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
  • B. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
  • C. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
  • D. The Oracle Grid Infrastructure installation must be owned by the grid user.
  • E. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
  • F. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.

Answer: A,C

Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/CWWIN/usrgrps.htm#CWWIN-GUID-6FD3C6AE-5A99-
4C6D-85D6-868CBA6F5DAE

 

NEW QUESTION 65
Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

  • A. RMAN always includes tablespaces containing undo segments in the recovery set.
  • B. It can be performed using an auxiliary instance managed by RMAN.
  • C. It can be used to recover a dropped tablespace.
  • D. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
  • E. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
  • F. flashback database must be enabled for it to work.
  • G. It can be performed using anauxiliary instance managed by a DBA.
  • H. It can be used to recover a truncated table.

Answer: B,D,F,G

 

NEW QUESTION 66
Which two are true about Optimizer Statistics? (Choose two.)

  • A. They are gathered by the SQL Tuning Advisor.
  • B. They are ignored by Optimizer if they are stale.
  • C. They provide real-time data about schema objects.
  • D. They can be gathered by the DBMS_STATS package.
  • E. By default, they are automatically gathered by a maintenance job.

Answer: D,E

 

NEW QUESTION 67
A container database called CDB1is OMF-enabled.
PDB_FILE_NAME_CONVERTis not configured in CDB1.
PDB1was unplugged from CDB1earlier 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 must be dropped from CDB1.
  • B. /u01/app/oracle/oradata/pdb1.xmldoes not contain the current locations of data files for PDB1.
  • C. PDB1 data files already exist in the correct location.
  • D. DBMS_PDB.CHECK_PLUG_COMPATIBILITYmust be run in CDB1before executing the command.
  • E. PDB_FILE_NAME_CONVERTmust be set before executing the command.

Answer: B,E

Explanation:
Explanation/Reference: http://anjaniappsdba.blogspot.com/2016/09/oracle-database-12102c-hot-cloning-of.html

 

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

Answer: A,B,E

 

NEW QUESTION 69
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 can be recovered while PDB2 is opened.
  • B. Data file 24 cannot be recovered while the CDB is opened.
  • C. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
  • D. Data file 24 must be recovered while PDB2 is closed.
  • E. Data file 24 must be recovered while the CDB is opened.

Answer: A,E

Explanation:
Explanation
19c: PDB SYSTEM or UNDO Tablespace Recovery: The CDB and all other PDBs can be left opened. 1.
Connect to PDB 2. Shutdown abort the PDB, if its not automatically done. sqlplus sys@sales_pdb as sysdba sql> SHUTDOWN ABORT; OR ALTER PLUGGABLE DATABASE CLOSE ABORT; rman target sys@slaes_pdb rman> restore database; rman> recover database; rman> alter pluggable database sales_pdb open;

 

NEW QUESTION 70
......

1Z0-083 Cert Guide PDF 100% Cover Real Exam Questions: https://www.actualtestsit.com/Oracle/1Z0-083-exam-prep-dumps.html

1Z0-083 Exam Questions Dumps, Selling Oracle Products: https://drive.google.com/open?id=1rYoEZ_i4Bo3_xGc8frp0W9MwB-3VtzSF 

Related Articles

more
Oracle 1Z0-083 Certification Practice Exam