option
My Daypo

OCP 19c - 81 - 90

COMMENTS STADISTICS RECORDS
TAKE THE TEST
Title of test:
OCP 19c - 81 - 90

Description:
OCP 19c - 81 - 90

Author:
OCI Student
(Other tests from this author)

Creation Date:
22/10/2021

Category:
Others

Number of questions: 10
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
Which four are true about RMAN backup sets? (Choose four.) A backup piece can belong to only one backup set A data file can be split into multiple sections stored in different backup sets A data file can be split into multiple sections stored in different backup pieces in the same backup set Blocks from multiple data files can be contained in one backup piece, A backup set can contain only one backup piece. A backup set must be written to media. A backup set must be written to disk. Blocks from multiple data files can be contained in one backup set,.
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.) Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB. SPFILE backups can be created while connected to an application root PDB The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.) cloning a remote container database in interactive mode cloning a remote pluggable database in silent mode relocating a remote pluggable database in interactive mode relocating a remote container database in silent mode cloning a remote container database in silent mode relocating a remote pluggable database in silent mode relocating a remote container database in interactive mode.
Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this? Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT. This cannot be done due to the lack of a clean restore point.
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.) Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state. A failure can be closed only when it has been repaired Data Recovery Advisor can be used if a database is closed The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities. Data Recovery Advisor can proactively check for failures.
Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)? It can be performed using an auxiliary instance managed by a DBA It can be used to recover a truncated table. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained. RMAN always includes tablespaces containing undo segments in the recovery set. It can be performed repeatedly until the correct time is found without using an RMAN catalog. flashback database must be enabled for it to work. It can be used to recover a dropped tablespace. It can be performed using an auxiliary instance managed by RMAN.
Which two are true about unplugging an application container from a container database and plugging it into a different container database ? It requires local undo mode in both container databases. It requires only local undo mode in the database where the application container will be unplugged. Plugging the application root into a different CDB plugs In all its application PDBs. Application PDBs In the application container must be unplugged before the application root Is unplugged. Unplugging the application root from a CDB unplugs all its application PDBs. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.
Which three are true In Oracle 19c and later releases? Tablespaces always remain In read/write mode during transportable tablespace operations. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level. Tablespaces never remain In read/write mode during transportable tablespace operations. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported. A transportable data pump import can leave a plugged-in tablespace in read-only mode A transportable data pump import can leave a plugged-in tablespace In read/write mode.
Which three are true about Audit policies In container databases (CDBs)? All audit records are written to the audit trail in CDB$ROOT A common unified audit policy can be created at the application root level. A common unified audit policy can be created at the CDB level. An application PDB cannot have a local audit policy. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.
Which three are true about Oracle Grid Infrastructure for a Standalone Server? It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software. It creates one disk group during installation. It requires the operating system oracle_base environment variable to be predefined before installation. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.
Report abuse Terms of use
HOME
CREATE TEST
COMMENTS
STADISTICS
RECORDS
Author's Tests