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
Examine this configuration:
While CDB1 is open, `˜/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted. To recover from this critical failure, you execute these commands:
What will be the outcome?
Answer: C
Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVELOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?
Answer: D
D is the right answer. Step No 2 is required, so it must be contained in the choise Step 1 is optional Step 3 is not necessary Steps 4 & 5 are required Step 6 is not necessary
Source: Adapted from community discussion — Apollo5
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)
Answer: CG
I think CG http://ora-srv.wlv.ac.uk/oracle19c_doc/multi/introduction-to-the-multitenant-architecture.html#GUID-47847140-8DE4-4C4E-8C93-4E9C197D1402 A, B incorrects -> http://ora-srv.wlv.ac.uk/oracle19c_doc/multi/introduction-to-the-multitenant-architecture.html#GUID-47847140-8DE4-4C4E-8C93-4E9C197D1402 C correct, D,E,F incorrect -> https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-B00A0E48-C892-4DC8-8455-C6F2ABC8EF91 G -> correct -> A clone from a PDB snapshot is a full, standalone PDB. -> https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-22118625-3157-4C38-8A88-79A561A3E6ED
Source: Adapted from community discussion — ald85
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
Answer: AE
Reference: https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B22-8BB67DCC9885.htm#ADMQS0235
Source: Adapted from community discussion — Asmodeus
Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output:
Which two are true? (Choose two.)
Answer: CF
C and F are correct. Tested in lab with exact same setting like in the output shown. A. -> incorrect - The CONTAINERS clause can be used. B. -> incorrect - It can be also a range based. C. -> CORRECT - https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html#GUID-AAF93A02-7C70-4024-8758-E351C213543E D. -> incorrect - Regular table E. -> incorrect - shown in the output CONTAINER_MAP = YES F. -> CORRECT - because CONTAINERS_DEFAULT is not enabled for the revenue table.
Source: Adapted from community discussion — michael_live
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)
Answer: BE
I didn't find any support to this claim. On the contrary, everything leads to think that, even in open mode, your cloned PDB will be mounted after the creation: "After you create the PDB, it is in mounted mode, and its status is NEW. " https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/cloning-a-pdb.html#GUID-D4900E43-DF38-4629-9A1F-D1C11EC8EC8F
Source: Adapted from community discussion — SimoneF
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
Answer: CDE
A,B,G are not right because the question is telling us 'without RMAN'. To put it in mount/open or so, are necessary only in case of using RMAN. Otherwise, using OS Utils, DB must be closed or maximum in NOMOUNT state.
Source: Adapted from community discussion — julica
Which two are true about common objects? (Choose two.)
Answer: DF
READ THIS: A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object. Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT. You can create most schema objects—such as tables, views, PL/SQL and Java program units, sequences, and so on—as common objects in an application root. If the object exists in an application root, then it is called an application common object. ACCORDING THE LECTURE, CORRECT ANSWERS ARE: DF D: they can exist in CDB$ROOT and application root. F: they can be created only in application root.
Source: Adapted from community discussion — erial
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? (Choose two.)
Answer: AD
sure is A,D: Version 19.6.0.0.0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY YES 3 PDB1 READ WRITE YES 4 PDB2 READ WRITE YES 5 PDB3 MOUNTED SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. . Database mounted. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 PDB1 MOUNTED 4 PDB2 MOUNTED 5 PDB3 MOUNTED SQL>
Source: Adapted from community discussion — julica
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
Answer: BCE
I Think BCE F is incorrect, grid OS system can be named anyway. D patches won't be apply automatically A Oracle Grid only supports out-of-place upgrades
Source: Adapted from community discussion — ald85
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
1Z0-083 practice, question 131. 178 questions available.
Version 1.0.0. How we source questions