1Z0-083 practice questions 61–70

1. Question 61 · 178 in bank

   Select 3

   You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use? (Choose three.)

   • Athe DBMS_PDB package
   • BData Pump full database export and import
   • CData Pump transportable tablespaces
   • Dreplication using GoldenGate
   • Ecloning the non-CDB as a PDB
   • FData Pump full transportable database

   Show answer

   Answer: ABC

   Explanation

   https://oracle-base.com/articles/12c/multitenant-migrate-non-cdb-to-pdb-12cr1#using-replication A- false (The DBMS_PDB package allows you to generate an XML metadata file from a non-CDB 12c database) E - false (The 12.1.0.2 patchset introduced the ability to create a PDB as a clone of a remote non-CDB) C - true ( If the non-CDB is pre-11.2.0.3, then you can still consider using transportable tablespaces) D - true (use a replication product like Golden Gate) F - true (If the non-CDB is version 11.2.0.3 onward, you can consider using Transport Database)

   Source: Adapted from community discussion — dmees

   References

   • Oracle documentation
   • Oracle documentation

   Next question

2. Question 62 · 178 in bank

   Select 3

   Which three are true about backing up the control file? (Choose three.)

   • AIt gets backed up automatically by RMAN when the BACKUP SPFILE command is used
   • BIt can get backed up automatically as a binary copy
   • CIt can be backed up manually as a binary copy
   • DIt can be backed up manually as a trace file containing SQL statements for control file re-creation
   • EIt gets backed up automatically by RMAN as a trace file containing SQL statements for control file re-creation when a database backup occurs
   • FIt cannot be backed up manually as a binary copy

   Show answer

   Answer: BCD

   References

   • Oracle documentation

   Next question

3. Question 63 · 178 in bank

   Select 2

   Which two are true about PDB archive files? (Choose two.)

   • AThey contain all the data files only in compressed form for a PDB
   • BThey contain a PDB manifest file and all the data files in uncompressed form for a PDB
   • CThey contain all the data files only in uncompressed form for a PDB
   • DThey must be created using the DBMS_PDB package
   • EThey contain a PDB manifest file and all the data files in compressed form for a PDB
   • FDBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive

   Show answer

   Answer: EF

   Explanation

   EF An XML metadata file describes the unplugged PDB and the files associated with the PDB (such as the data files and wallet file). An archive file includes both the XML metadata file and the PDB files. The USING clause of the CREATE PLUGGABLE DATABASE statement specifies a XML metadata file or a compressed archive file with a .pdb extension.

   Source: Adapted from community discussion — sykoram

   References

   • Oracle documentation
   • Oracle documentation

   Next question

4. Question 64 · 178 in bank

   Select 2

   You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites? (Choose two.)

   • Aa group called dba
   • Bthe Oracle Inventory group oinstall
   • Can operating system user to own this installation
   • Dan operating system account called grid
   • Ethe installation of Oracle ASMLIB

   Show answer

   Answer: BC

   Explanation

   E is FALSE https://www.oracle.com/linux/technologies/asmlib/ Oracle ASMLib ASMLib is an optional support library for the Automatic Storage Management feature of the Oracle Database. Automatic Storage Management (ASM) simplifies database administration and greatly reduces kernel resource usage (e.g. the number of open file descriptors). It eliminates the need for the DBA to directly manage potentially thousands of Oracle database files, requiring only the management of groups of disks allocated to the Oracle Database. ASMLib allows an Oracle Database using ASM more efficient and capable access to the disk groups it is using.

   Source: Adapted from community discussion — LeandroHPN

   Next question

5. Question 65 · 178 in bank

   You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

   • AIt creates a file that contains SQL statements to re-create the control file
   • BIt creates a file that contains RMAN scripts to create a duplicate database
   • CIt creates a copy of the control file in the fast recovery area (FRA)
   • DIt creates a binary backup of the control file
   • EIt updates the alert log with the location and contents of the control file

   Show answer

   Answer: A

   Explanation

   A correct. BACKUP CONTROLFILE Clause TO TRACE Specify TO TRACE if you want Oracle Database to write SQL statements to a trace file rather than making a physical backup of the control file. You can use SQL statements written to the trace file to start up the database, re-create the control file, and recover and open the database appropriately, based on the created control file.

   Source: Adapted from community discussion — LeandroHPN

   References

   • Oracle documentation
   • Oracle documentation

   Next question

6. Question 66 · 178 in bank

   Select 3

   Which three are true about upgrading an application in an application container? (Choose three.)

   • AThe upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED
   • BAn application root clone gets created automatically
   • CAfter an application upgrade, the application container’s PDBs remain synchronized with the existing application root
   • DThe upgrade must be performed when connected to CDB$ROOT
   • EAn application name and version number must be specified to upgrade the application
   • FAfter an application upgrade, the application container’s PDBs are automatically synchronized with the application root clone

   Show answer

   Answer: BCE

   Explanation

   The correct answer are BCE E as "ALTER PLUGGABLE DATABASE APPLICATION saas_sales_app BEGIN UPGRADE '1.0' to '2.0'" During an application upgrade, the application remains available. To make this availability possible, Oracle Database clones the application root. applications pdbs remain syncronzed with clone application root

   Source: Adapted from community discussion — ilputto

   Next question

7. Question 67 · 178 in bank

   Select 2

   Which two are true about RMAN virtual private catalogs (VPCs)? (Choose two.)

   • ARMAN uses Oracle Virtual Private Database (VPD) to implement VPCs
   • BEach VPC is owned by the recovery catalog schema owner
   • CVPC functionality is enabled by default
   • DThe RMAN catalog owner can grant access for an already registered database to a new virtual catalog owner
   • EOnly one target database can be registered in a VPC

   Show answer

   Answer: AD

   Explanation

   A - Correct. 13.5.2 About Using the VPD Model for Virtual Private Catalogs RMAN uses the Virtual Private Database (VPD) functionality to implement virtual private catalogs. D - Correct.

   Source: Adapted from community discussion — LeandroHPN

   References

   • Oracle documentation

   Next question

8. Question 68 · 178 in bank

   Select 2

   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.)

   • APDB1 data files already exist in the correct location.
   • BDBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
   • CPDB_FILE_NAME_CONVERT must be set before executing the command.
   • D/u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
   • EPDB1 must be dropped from CDB1.

   Show answer

   Answer: DE

   Explanation

   The question gives the impression that the source files were held at /u01/app/oracle/oradata, but are now physically located at /u01/app/oracle/oradata. The xml description file is still at /u01/app/oracle/oradata/pdb1.xml So, for each: A: FALSE - SOURCE_FILE_NAME_CONVERT is only needed if the XML file does not accurately describe the current location of the pdb's files. B: FALSE - If pdb1 ran correctly before, it will run correctly now - assuming that no major upgrade of CDB1 has happened. C: FALSE - PDB_FILE_NAME_CONVERT is needed only when OMF is not used. The question tells us that OMF is enabled. D: TRUE - The use of the SOURCE_FILE_NAME_CONVERT parameter indicates that the DB files have been moved, so the xml file does not hold the correct locations E: TRUE - Unplugging a database will result in the PDB remaining in a MOUNT state. It is still part of the CDB and will still be backed up etc... After unplugging, a PDB needs to be dropped before a new PDB can be created with the same name. Therefore, DE are correct

   Source: Adapted from community discussion — xRodge

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

9. Question 69 · 178 in bank

   Select 2

   Which two are true about backup encryption? (Choose two.)

   • AKeystore-based encryption is the default mode for RMAN backup encryption
   • BVendor-specific media management software can be used for making encrypted RMAN backups to media
   • CImage copies can be encrypted
   • DBackup encryption can be enabled selectively for specific tablespaces
   • EThe BACKUP BACKUPSET command can encrypt and decrypt backup sets
   • FThe Transparent Data Encryption (TDE) keystore is backed up using RMAN

   Show answer

   Answer: AD

   Explanation

   D - TRUE : https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CONFIGURE.html#GUID-B5094E73-C26C-4FED-AE39-8C2E9540050A : ENCRYPTION : This configuration applies unless overridden with the SET ENCRYPTION command. Options specified for an individual tablespace take precedence over options specified for the whole database. A - TRUE: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-client-advanced.html#GUID-6ED708C7-1092-45FC-80C6-236F062D0DAC : Note: Keystore-based encryption is more secure than password-based encryption because no passwords are involved. Use password-based encryption only when it is absolutely necessary because your backups must be transportable.

   Source: Adapted from community discussion — vkra

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

10. Question 70 · 178 in bank

    Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADATA. 3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands:

    

    What will be the outcome and why?

    • AIt will return an error because EMP is not empty in APP_ROOT
    • BIt will return an error because the SYNC operation is not allowed when constraints are added to common objects
    • CSAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows
    • DSAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows
    • EIt will return an error because EMP.SAL is empty in APP_ROOT

    Show answer

    Answer: A

    Explanation

    DEFAULT_SHARING only aplies to new common objects you create, so it does nothing here. The table was metadata-linked, meaning the app pdbs could have their own data. When we sync the pdb, two things can happen: 1- If table was empty at pdb level, then it wil sync with no errors 2-If table had data at pdb level, it will return: ORA-01758: table must be empty to add mandatory (NOT NULL) column One way to fix this would be to ad a DEFAULT value to the column. There is no 100% correct answer to this question. A: table in app root is empty(because the constraint was added whitout errors), if it had data it would return an error, but it didn't B:It is allowed as long as the data doesnt violate constraints being added... it's not that you cant add constraints to a common object C:No null has been specified for the new column... this doesnt make sense D:No null has been specified for the new column... this doesnt make sense E: Table in root is empty, but still doesnt make any sense... it would return an error if table in root had data. So no correct answers.. :(

    Source: Adapted from community discussion — eleeitor

    References

    • Oracle documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

1Z0-083 practice, question 61. 178 questions available.