Which two are true about RMAN encryption? (Choose two.) RMAN encryption keys are stored in a database keystore. RMAN can encrypt the Oracle Database password file Dual-mode encrypted backups can be restored only if both the password and the keystore used
for encryption are available. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE
ENCRYPTION command. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION.
Choose two. 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? an operating system user to own this installation the Oracle Inventory group oinstall an operating system account called grid a group called dba the installation of Oracle ASMLIB.
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose
two.) RMAN error stacks should be read from the bottom up as that is the order in which errors are
generated. RMAN error stacks should be read from the top down as that is the order in which errors are The RMAN LOG command line clause causes output issued during RMAN command compilation
to be written to a log file and to standard output The RMAN LOG command line clause causes output issued during RMAN command compilation
to be written to a log file only. Media Management messages for SBT devices are written to an Oracle trace file.
Choose two. You plan to perform cross-platform PDB transport using XTTS. Which two are
true? Automatic conversion of endianess occurs. The source and target platforms must have the same endianess. The source PDB can be in MOUNT or OPEN state. The source PDB must not be an application root. A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM
clause.
choose two Which two are benefits of unified auditing in full mode? All audit data is written to both the traditional locations and to the unified location. The audit trail is in a single format Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the
unified location. The audit trail is read-only. The audit trail uses less space.
Which two are true about RMAN backups when using a media manager to write backups to
tape when there are only two tape drives? (Choose two.) SBT tape compression can be used even if no RMAN compression is configured. Any backup set written to the SBT device in this configuration can contain a maximum of two
backup pieces. Any backup written to the SBT device in this configuration can contain a maximum of two backup
sets. SBT tape compression and RMAN backup compression should be used in parallel. The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used
simultaneously.
Choose two. Which two are true about Oracle Database Configuration Assistant (DBCA)? It can only be launched from the command line interface. It can be launched from both the command line and the Universal Installer (OUI) interfaces. It can be used to create container databases and non-container databases. It can be used to change the character set of an existing database. It can be used to convert a non-container database to a container database.
Choose three. Which three are true about creating container databases (CDBs) and pluggable
databases (PDBs) in Oracle 19c and later releases? A snapshot copy PDB can be a full copy of a source PDB. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB. A PDB snapshot depends on an existing storage snapshot of the source PDB. A PDB snapshot can be a full copy of a source PDB. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with
no configuration required before starting the duplication. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before
starting the dup A PDB snapshot can be a sparse copy of a source PDB.
choose one You want to create a test database as a replica of your production database with
minimum intervention from a DBA.
Which method would you use? Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location. Use Database Configuration Assistant (DBCA) to create a template from the existing database to
contain the database structure. Use DBCA to create a template from the existing database to contain the database structure and
then manually copy the data by using Oracle Data Pump. Create the database by using the CREATE DATABASE . . . command and manually import data by
using Data Pump.
Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL>
SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME,
SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true
concerning the redaction policy? FULL redaction is active on the SAL column RANDOM redaction is active on the MGR column RANDOM redaction is active on the HIREDATE column PARTIAL redaction is active on the MGR column
PARTIAL redaction is active of the HIREFATE column.
Choose three. Which three are true about a whole database backup? It can consist of either backup sets or image copies It is the only possible backup type for a database in NOARCHIVELOG mode. It can be consistent. It can be created only by using RMAN. It can be inconsistent It always includes all data files, the current control file, the server parameter file, and archived redo
logs.
Choose two. Which two are true about the SQL Tuning Advisor? It can recommend semantic changes to SQL statements. It prevents performance regressions for SQL statements when changes are made. It checks each query being analyzed for missing or stale statistics. It considers all SQL statements being analyzed by the advisor task as a group It only recommends syntactic changes to SQL statements.
Choose three. Which three capabilities require the use of the RMAN recovery catalog using RMAN stored scripts creating encrypted backups creating customized reports about a single database's backups using the REPORT SCHEMA command to list a database's data files and tablespaces at times in
the past using the KEEP FOREVER clause with the BACKUP command using the REPORT SCHEMA command to list a database's current data files and tablespaces.
While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup istaking
too long and suspect a performance bottleneck. Which three are true about diagnosing and tuning
these problems? (Choose three.) If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then
both read and write I/O are likely bottlenecks. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using
synchronous I/O. If an RMAN BACKUP VALIDATE command takes noticeably lessthan an actual backup, then write
I/O is a likely bottleneck. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then
read I/O is a likely bottleneck. Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a
potential performance bottleneck when synchronous I/O is used. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using
asynchronous I/O/ Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance
bottleneck when asynchronous I/O is used.
Choose two. 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? PDB1_C2_SRV will be created but not started. PDB1 will be created in CDB2 and automatically opened. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV. PDB1 will be created in CDB2 and left in MOUNT state PDB1_C2_SRV will be created and started automatically.
Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to
upgrade a database? DBUA must be launched from the target Oracle Home. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously. A whole database backup must exist before upgrade. The Pre-Upgrade Information Tool script is executed by DBUA All pluggable databases are automatically upgraded as part of a container database upgrade. The database must be opened in read-only mode.
Which two are true about data movement between a non-CDB and a PDB using Data Pump?
(Choose two.) Tablespaces are automatically created as need while importing full exports in either a non-CDB or
a PDB. Oracle attempts to convert conventional database users to local users when moving schemas
from a non-CDB to a PDB A new PDB is automatically created when importing a non-CDB into a CDB. Oracle attempts to convert common users to conventional users when moving schemas from a
PDB to a non-CDB. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export
and import. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
Which two statements are true about RMAN duplexed backups? It is not supported for image copies. It is only supported for backups to tape via the media management interface. Duplex backups can be performed on either disk or media, but cannot be performed on media
and disk simultaneously. Duplex backups can contain only data files and control files. For performing duplexed backups, the parallelism for the device must be set equal to the number
of copies.
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for
the first time on a server. Examine this command and its outcome: Which two are true? (Choose rwo)
Examine this command and its outcome: oracle will be an owner of the Oracle Inventory. oracle must be the owner of every Oracle Database installation. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation. oracle will be granted the SYSASM privilege when installing the Oracle Database software. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
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 fies 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? 1, 2, 4, 5, 7, 8 1, 2, 4, 6, 7, 8 1, 2, 3, 4, 5, 7, 8 1, 2, 3, 4, 5, 6, 7, 8 2, 4, 5, 6, 7.
|
