1Z0-083 practice questions 41–50

1. Question 41 · 178 in bank

   Select 3

   Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)

   • AAll archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.
   • BThe SPFILE is included in the archival backup.
   • CThey are never considered obsolete by RMAN.
   • DArchive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.
   • EThe ARCHIVAL attribute for a backup overrides the RMAN retention policy.
   • FThey can optionally be written to a fast recovery area (FRA).
   • GUse of a recovery catalog is always required to support the creation and use of archival backups.

   Show answer

   Answer: BDE

   Explanation

   Some of facts about archival backup: • Use KEEP clause to create archival backup • Use RESTORE POINT clause to assign a name to a specific SCN ○ It create a consistency point in the control file ○ The SCN is captured after the data file backup complete • They are either considered obsolete only after a specific time that you specify or never considered obsolete • Any files that need to restore this backup (to a consistent state) are kept, include data files, control files, SPFILE, archived log files, and relevant autobackup files (so what are relevant autobackup files) • Cannot be stored in FRA, DBA must provide a FORMAT clause to specify a different location • Recovery catalog is required to create archival backup of an OPEN DB. Without recovery catalog, you must put the DB in MOUNT state • Without recovery catalog, you cannot use KEEP FOREVER as the backup will eventually age out of the control file

   Source: Adapted from community discussion — hkshado

   References

   • Oracle documentation

   Next question

2. Question 42 · 178 in bank

   Select 3

   Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 - ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1'; Which three are true about PDB1? (Choose three.)

   • AService PDB1 is created for remote logins to PDB1.
   • BIt is in mount state after creation.
   • CIt has no local users.
   • DIt has the same number of roles as CDB1.
   • EIt has the same common users defined as does CDB1.
   • FIt has only local roles.

   Show answer

   Answer: ABD

   Explanation

   The number of roles are the sema even when the condition common='YES' is removed. SQL> select con_id, count(1) from cdb_roles where con_id in (1,9) group by con_id; CON_ID COUNT(1) ---------- ---------- 1 89 9 89 Ref.: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/overview-of-the-multitenant-architecture.html#GUID-3BB161DA-9CC0-4D61-A2C1-5D3662E0DECF https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/overview-of-the-multitenant-architecture.html#GUID-16473474-7F47-4E40-A592-01836E7D911C

   Source: Adapted from community discussion — flaviogcmelo

   References

   • Oracle documentation

   Next question

3. Question 43 · 178 in bank

   Select 2

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

   • APDB1 will be created in CDB2 and automatically opened.
   • BPDB1 will be created in CDB2 and left in MOUNT state.
   • CPDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
   • DPDB1_C2_SRV will be created and started automatically.
   • EPDB1_C2_SRV will be created but not started.

   Show answer

   Answer: BE

   Explanation

   Sorry guys, but B and D are CORRECT as I tested in practice couple of minutes ago: SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1 SERVICE_NAME_CONVERT=('my_new_service_1','my_new_service_3'); Pluggable database created. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB_PHRDB MOUNTED 4 PDB1 READ WRITE NO 5 PDB2 MOUNTED 6 PDB3 MOUNTED SQL> alter session set container=PDB3; SQL> exec DBMS_SERVICE.start_service('my_new_service_3'); BEGIN DBMS_SERVICE.start_service('my_new_service_3'); END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_SERVICE.START_SERVICE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored SQL> alter database open; Database altered. SQL> exec DBMS_SERVICE.start_service('my_new_service_3'); PL/SQL procedure successfully completed.

   Source: Adapted from community discussion — ObserverPL

   References

   • Oracle documentation
   • Oracle documentation

   Next question

4. Question 44 · 178 in bank

   Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; What is true?

   • AIt will return an error because creation of a local role is not allowed in CDB$ROOT.
   • BROLE1 will be created only in CDB$ROOT and APP1_ROOT.
   • CROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
   • DROLE1 will be created only in CDB$ROOT.
   • EIt will return an error because common roles must start with C##.

   Show answer

   Answer: A

   Explanation

   SQL> alter system set common_user_prefix='' scope=spfile; System altered. SQL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 960495072 bytes Fixed Size 9141728 bytes Variable Size 306184192 bytes Database Buffers 637534208 bytes Redo Buffers 7634944 bytes Database mounted. Database opened. SQL> show parameter prefix NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ common_user_prefix string os_authent_prefix string ops$ private_temp_table_prefix string ORA$PTT_ SQL> SQL> SQL> create role role1 container=current; create role role1 container=current * ERROR at line 1: ORA-65049: Creation of local user or role is not allowed in this container SQL>

   Source: Adapted from community discussion — mtnetmaker

   References

   • Oracle documentation

   Next question

5. Question 45 · 178 in bank

   Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

   • AIt is a set of recommendations by the optimizer to create new indexes.
   • BIt is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
   • CIt is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
   • DIt is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
   • EIt is a set of recommendations by the optimizer to change the access methods used.

   Show answer

   Answer: D

   Explanation

   Oracle White Paper—SQL Profiles: Technical Overview SQL Profiles: Technical Overview What is a SQL profile? A SQL profile is a set of auxiliary information specific to a SQL statement. Conceptually, a SQL profile is to a SQL statement what statistics are to a table or index. The database can use the auxiliary information to improve execution plans. A SQL profile contains corrections for poor optimizer estimates discovered by the SQL Tuning advisor. This information can improve optimizer cardinality and selectivity estimates, which in turn leads the optimizer to select better plans. The SQL profile does not contain information about individual execution plans. Rather, the optimizer has the following sources of information when choosing plans: • The environment, which contains the database configuration, bind variable values, optimizer statistics, data set, etc. • The supplemental statistics in the SQL profile Therefore, SQL profiles just guide the optimizer to a better plan.

   Source: Adapted from community discussion — Felix_br

   References

   • Oracle documentation
   • Oracle documentation

   Next question

6. Question 46 · 178 in bank

   Select 2

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

   • ABy default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
   • BThe primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
   • CThe Oracle Grid Infrastructure installation must be owned by the grid user.
   • DThe Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
   • EThe Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
   • FThe same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

   Show answer

   Answer: BD

   Explanation

   It’s confirmed by the below quotes https://docs.oracle.com/database/121/CWLIN/usrgrps.htm#CWLIN483 The -g option specifies the primary group, which must be the Oracle Inventory group. For example: oinstall. You can designate a unique group for the SYSASM system privilege, separate from database administrator groups, or you can designate one group as the OSASM and OSDBA group, so that members of that group are granted the SYSASM and SYSDBA privilege to grant system privileges to administer both the Oracle ASM instances and Oracle Database instances. If you are creating this user to own both Oracle Grid Infrastructure and an Oracle Database installation, then this user must have the OSDBA for ASM group as a secondary group. In Oracle documentation, a user created to own the Oracle Grid Infrastructure binaries is called the grid user. This user owns both the Oracle Clusterware and Oracle Automatic Storage Management binaries.

   Source: Adapted from community discussion — Alejandrrro

   References

   • Oracle documentation
   • Oracle documentation

   Next question

7. Question 47 · 178 in bank

   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.

   • A1, 3, 5, 8, 6, 10
   • B1, 3, 5, 6, 10
   • C1, 3, 5, 7, 10
   • D1, 2, 5, 7, 4, 10
   • E1, 3, 5, 6, 9

   Show answer

   Answer: B

   Explanation

   RECOVER DATABASE UNTIL AVAILABLE; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "redo" RMAN-01007: at line 1 column 33 file: standard input RMAN> RECOVER DATABASE NOREDO; Starting recover at 16.01.2022 16:50:40 using channel ORA_DISK_1 Finished recover at 16.01.2022 16:50:40 So C must be incorrect. B - ok

   Source: Adapted from community discussion — egore0496

   Next question

8. Question 48 · 178 in bank

   Select 3

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

   • AIt can contain a single application.
   • BIt can contain multiple applications.
   • CIt must have an application seed PDB.
   • DIt must have an application root PDB.
   • ETwo application containers can share an application seed PDB.
   • FAn application PDB can belong to multiple application containers.

   Show answer

   Answer: ABD

   Explanation

   application pdbs can be create from application$seed (belong to that application pdb) and cdb$seed, I doubt that it can be shared.

   Source: Adapted from community discussion — RinD

   Next question

9. Question 49 · 178 in bank

   Select 3

   Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

   • AFLASHBACK LOGS are archived after a log switch.
   • BA database can be flashed back using SQL*PLUS.
   • CQueries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
   • DFLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
   • EIt always generates REDO and UNDO.
   • FIt requires that the target database be in ARCHIVELOG mode.

   Show answer

   Answer: BDF

   Explanation

   Well, E is wrong. One prerequisite for FLASHBACK DATABASE is that the database "must be mounted with a current control file". When mounted the redo log files are not online, and redo cannot be written to it. REF: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/FLASHBACK-DATABASE.html#GUID-584AC79A-40C5-45CA-8C63-DED3BE3A4511 In another point of the documentation, when using SQL*Plus: "Oracle Flashback Database returns your entire database or an entire PDB to a previous state without requiring you to restore files from backup." REF: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-flashback-dbpitr.html#GUID-2E5F3F62-17ED-472A-ABBD-FAAF107C6852 Going BDF on this one. If this is an actual question we can contact Oracle support after the exam to point this point.

   Source: Adapted from community discussion — piontk

   References

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

   Next question

10. Question 50 · 178 in bank

    Select 3

    Which three are true about patchsets? (Choose three.)

    • AThey can be applied in a rolling fashion for Clusterware and the databases.
    • BThey can introduce new features.
    • CThey are installed via OPatch or OPatchAuto.
    • DInstalling a patchset is considered an ג€upgradeג€.
    • EThey are only released quarterly.
    • FA base release is not needed to install patchsets.

    Show answer

    Answer: BDF

    Explanation

    Reference: https://docs.oracle.com/cd/E25290_01/doc.60/e25224/patchesupdates.htm

    Source: Adapted from community discussion — jorche

    Next question

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

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