Question 31 · 178 in bank
Select 2In which two situations can you use Database Upgrade Assistant? (Choose two.)
Show answer
Answer: CD
Oracle Database Administration II178 questions across 18 pages are complete and free, with no account or card.
178 questions in this bank
Free access · progress saved on this device
In which two situations can you use Database Upgrade Assistant? (Choose two.)
Answer: CD
Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)
Answer: DE
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
Answer: BC
A - FALSE. The ARCH process backs up online redo logs (by creating Arch redo logs), never the DBA. DBAs backup Archive Redo Logs, not online redo logs. B - TRUE. Control files are DB wide - backing them up, from the Container Root, is exactly where you do this. C - TRUE. Part of the point of Multitenant is that you have control of all PDBs from the CDB level. D - FALSE. An application root container is still below the main Container, so you cannot administer control files from here. E - FALSE. For the same reason as above, you can only create control file backups from the Root Container. So, BC is correct.
Source: Adapted from community discussion — xRodge
Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)
Answer: ABE
A - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated B - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated C - FALSE. You can create them manually. D - FALSE. The DB will, by default, create them automatically every hour E - TRUE. You can setup AWR Warehouse, allowing these reports to be kept, and queried, forever. F - FALSE. STATISTICS_LEVEL=BASIC stops them being generated So, ABE is correct. Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/STATISTICS_LEVEL.html
Source: Adapted from community discussion — xRodge
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 RMAN on 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 RMAN on the destination system. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?
Answer: C
easy way we must convert either on destination or source so A is incorrect (no option 3 and 6) we must copy data pump set from source to destination so B is incorrect (no step 5) no need to convert on destination if we aleady did conversion on source so D is incorrect (both step 3 and 6) are included we must make tablespace read only son E is incorrect so answer must be C
Source: Adapted from community discussion — asefa
Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)
Answer: ABD
AB correct - no doubts D is correct instead of C, because - on the PDB level you manage resources more/less the same as in non-CDB database hence you can limit uncommitted UNDO per consumer group: https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11853 while from CDB level you cannot limit CPU on particular session level in PDB (it can be done on PDB level) but you can "only" limit CPU generally for particular PDB: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/using-oracle-resource-manager-for-pdbs-with-sql-plus.html#GUID-19400E80-882F-424F-A19A-9FEB54F83577
Source: Adapted from community discussion — ObserverPL
How do you configure a CDB for local undo mode?
Answer: A
Agree, A correct. Tested couple of minutes ago in practice. It was not possible to change undo mode on the PDB level: SQL> alter database local undo OFF; alter database local undo OFF * ERROR at line 1: ORA-65040: operation not allowed from within a pluggable database
Source: Adapted from community discussion — ObserverPL
Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases? (Choose three.)
Answer: ABC
A. TRUE - Base catalog Owner must give access to metadata through "GRANT CATALOG FOR DATABASE" command to the VPC owner. "After you set up a virtual private catalog user, the administrator for the recovery catalog grants each virtual private catalog the privilege to use that catalog for one or more databases that are currently registered in the recovery catalog." The catalog owner receive access to the metadata for the PDBs which they manage. B. TRUE - By definition of a Virtual Private Catalog "A subset of the metadata in a base recovery catalog to which a database user is granted access. The owner of a base recovery catalog can grant or revoke restricted access to the recovery catalog to other database users. Each restricted user has full read/write access to his own virtual private catalog." C. TRUE - If a target database is not registered in the recovery catalog, then RMAN cannot use the catalog to store metadata for operations on this database. You can still perform RMAN operations on an unregistered database: RMAN always stores its metadata in the control file of the target database.
Source: Adapted from community discussion — musafir
Which three activities are possible for PDBs? (Choose three.)
Answer: CDE
CDE I believe C. converting an application seed to an application PDB TRUE, "An application seed enables you to create application PDBs quickly. It serves the same role within the application container as PDB$SEED serves within the CDB itself." D. converting an application PDB to an application seed Example 14-9 https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/creating-application-seeds.html#GUID-640F2ABE-998E-4F12-871E-2250EC6A0463 E. converting a regular PDB to an application PDB Yes, possible and referenced in http://oracle-help.com/oracle-database/multitenant/convert-regular-pdb-to-application-pdb/
Source: Adapted from community discussion — musafir
Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)
Answer: AD
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
1Z0-083 practice, question 31. 178 questions available.
Version 1.0.0. How we source questions