Summer Goodies - 55% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: av5rz84q

Exact2Pass Menu

Question # 4

Choose three. Which three are true about cloning databases into an existing CDB with RMAN?

A.

A non-CDB can be cloned into a PDB.

B.

A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

C.

Only one PDB can be cloned at a time.

D.

Two or more PDBs can be cloned with the same command.

E.

A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.

F.

The target and auxiliary instance passwords must be the same.

Full Access
Question # 5

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

A.

The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

B.

Settingthetargettablespacetoread-only

C.

The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D.

Setting the target tablespace offline

E.

The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct

Full Access
Question # 6

Choose three. Which three are true about corrupted data blocks and their recovery in an Oracle Database?

A.

If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.

B.

DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.

C.

A media corrupt block is one where the block is not formatted correctly.

D.

The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.

E.

If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.

F.

DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.

Full Access
Question # 7

Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

A.

when free space in a dictionary managed tablespace falls below a specified percentage

B.

when free space in a locally managed tablespace falls below a specified percentage

C.

when the total number of locked user account exceeds a specific value

D.

when the number of logons per second exceeds a specific value

E.

when a resumable statement is suspended

F.

when the total number of logons exceeds a specific value

Full Access
Question # 8

choose two You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI?

A.

You can

B.

You can

C.

You can

D.

You can

E.

You can

Full Access
Question # 9

Which two are true about common objects? (Choose two.)

A.

They can be created only in CDB$ROOT.

B.

They can be only metadata-linked in an application container.

C.

They can exist in user-defined schemas only in application containers.

D.

They can exist in CDB$ROOT and an application root.

E.

They can be extended data-linked in CDB$ROOT. F. They can be created only in an application root.

Full Access
Question # 10

Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?

A.

CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4

B.

CDB$ROOT, PDB2, PDB1, and PDB3

C.

CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

D.

CDB$ROOT, PDB1, PDB2, PDB3, and PDB4

E.

CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

Full Access
Question # 11

Choose the best answer. 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: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?

A.

SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

B.

SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.

C.

It will return an error because the SYNC operation is not allowed when constraints are added to common objects.

D.

It will return an error because EMP is not empty in APP_ROOT.

E.

It will return an error because EMP.SAL is empty in APP_ROOT.

Full Access
Question # 12

Choose two. Which two are true about backup encryption?

A.

The Transparent Data Encryption (TDE) keystore is backed up using RMAN.

B.

Vendor-specific media management software can be used for making encrypted RMAN backups to media.

C.

The BACKUP BACKUPSET command can encrypt and decrypt backup sets.

D.

Image copies can be encrypted.

E.

Keystore-based encryption is the default mode for RMAN backup encryption.

F.

Backup encryption can be enabled selectively for specific tablespaces.

Full Access
Question # 13

Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

A.

redo logs

B.

control files

C.

all data dictionary metadata

D.

user-defined PL/SQL packages

E.

temporary tablespaces

F.

mandatory Oracle-supplied PL/SQL packages

G.

undo tablespaces

Full Access
Question # 14

Choose the best answer. You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian Examine this list of steps:. 1. Make the UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

A.

3,4,6

B.

2,3,4,5,6,7

C.

1,3,4,6,8

D.

1,2,3,4,5,6,7,8

Full Access
Question # 15

Choose three. Which three are true about Rapid Home Provisioning of Oracle software?

A.

It can be used to patch existing Oracle software installations.

B.

It can be used only on nodes with Oracle Grid Infrastructure installed.

C.

It can be used to create a single-instance Oracle Database in an already-installed Oracle home. D)It can be used to deploy new homes without disrupting active databases.

D.

It can be used to create templates of Oracle homes as gold images of only Oracle databases.

E.

It can be used to upgrade only single-instance databases running on Oracle Restart.

Full Access
Question # 16

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

A.

Media Management messages for SBT devices are always written to sbtio.log.

B.

RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

C.

RMAN error stacks should be read from the top down as that is the order in which errors are generated.

D.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

E.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

F.

Media Management messages for SBT devices are written to an Oracle trace file.

Full Access
Question # 17

Choose three. Which three are true in Oracle 19c and later releases?

A.

Tablespaces always remain in read/write mode during transportable tablespace operations.

B.

Tablespaces never remain in read/write mode during transportable tablespace operations.

C.

A transportable data pump import can leave a plugged-in tablespace in read-only mode.

D.

Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

E.

A transportable data pump import can leave a plugged-in tablespace in read/write mode.

F.

An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Full Access
Question # 18

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

A.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C.

The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D.

The UNDO TABLESPACE clause is never required.

E.

RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

Full Access
Question # 19

Which two are true about automatic block repair? (Choose two.)

A.

Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.

B.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

C.

Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

D.

It is not possible for media corrupt blocks.

E.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Full Access
Question # 20

Choose three. Which three are true about Oracle Restart?

A.

It is used in both clustered and non-clustered environments.

B.

You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands.

C.

It runs from the Oracle Grid Infrastructure home.

D.

If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.

E.

The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.

F.

It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.

Full Access
Question # 21

choose one .Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command?

A.

It succeeds and creates multisection backup sets that are used for active database duplication.

B.

It fails because there is no connection to a recovery catalog.

C.

It succeeds only if the target database is in MOUNT state.

D.

It fails because no parallel channels are allocated for the auxiliary database.

Full Access
Question # 22

You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: Which three are true? (Choose three.)

A.

The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

B.

The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

C.

All archive logs created after this backup are kept for two years.

D.

The SPFILE is included in the self-contaied archival backup.

E.

The control file is included in the self-contained archival backup.

F.

The restore point is a label for the system change number (SCN) before the archival backup was taken.

Full Access
Question # 23

Choose two. Which two are true in Oracle 19c and later releases?

A.

Schema Only accounts can be granted administrator privileges.

B.

If the password file location changes, then the instance must be restarted.

C.

Unified Auditing can be configured to audit only events that are issued directly by an audited user.

D.

All the Oracle-supplied accounts are Schema Only accounts.

E.

Unified Auditing can be configured to audit only events that are issued indirectly by all users

Full Access
Question # 24

Choose three. Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A.

It requires Oracle ASMLib to manage Automatic Storage Management (ASM) disks.

B.

It creates one disk group during installation.

C.

It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

D.

Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.

E.

It requires Oracle ASM Fitter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks.

F.

It requires the operating system ORACLE_BASE environment variable to be predefined before installation.

Full Access
Question # 25

Choose two. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

A.

to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

B.

to generate an XML metadata file from any unplugged PDB

C.

to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure

D.

to generate a . pdb archive file for any PDB in the current CDB

E.

to generate an XML metadata file that describes the current plugged-in PDB

Full Access
Question # 26

choose three Which three are true about unified auditing in full mode?

A.

The unified audit trail is written to a read-only table.

B.

The unified audit trail is written to a read-only external file.

C.

Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D.

Audit records are created for SYS.

E.

Audit records are created for non-sys users.

Full Access
Question # 27

Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?

A.

Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

B.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F

C.

If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

D.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

E.

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.

Full Access
Question # 28

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

A.

defining primary keys for all tables to speed up all queries

B.

using check constraints to speed up updates

C.

defining foreign keys for all tables to speed up joins

D.

the physical data model

E.

the configuration of storage arrays

Full Access
Question # 29

Choose three. Which three are true about Oracle pluggable databases (PDBs)?

A.

A PDB can be plugged into a CDB only if both are of the same Oracle Database release.

B.

An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.

C.

A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.

D.

A non-CDB can be converted into a PDB.

E.

A PDB in a remote CDB can be accessed transparently thereby aggregating results from local and remote PDBs.

F.

A PDB created from PDB$SEED must be set to READ WRITE after loading data.

G.

A PDB created from PDB$SEED must be set to READ ONLY after loading data.

Full Access
Question # 30

Choose three. Which three capabilities require the use of the RMAN recovery catalog?

A.

using RMAN stored scripts

B.

creating encrypted backups

C.

creating customized reports about a single database's backups

D.

using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

E.

using the KEEP FOREVER clause with the BACKUP command

F.

using the REPORT SCHEMA command to list a database's current data files and tablespaces

Full Access
Question # 31

A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it. The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT. Which three are true? (Choose three.)

A.

Data file 24 can be recovered only while connected to PDB2.

B.

Data file 24 can be restored and recovered while connected to CDB$ROOT.

C.

Data file 24 can be restored only while connected to CDB$ROOT.

D.

Data file 24 can be restored only while connected to PDB2.

E.

Data file 24 can be recovered while connected to PDB2.

F.

Data file 24 can be recovered while connected to CDB$ROOT.

Full Access
Question # 32

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

A.

PDB1 data files already exist in the correct location.

B.

DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

C.

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

E.

PDB1 must be dropped from CDB1.

Full Access
Question # 33

Choose two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?

A.

when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

B.

when a new tablespace is added to a registered target database

C.

when a backup of the current control file is created

D.

when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

E.

when the target is first registered

Full Access
Question # 34

Choose three. Which three are true about SGA memory management in a multitenant database?

A.

SGA_MIN_SIZE cannot be set for a PDB.

B.

Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.

C.

Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.

D.

The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.

E.

Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.

F.

The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.

Full Access
Question # 35

Choose two. Examine this configuration: 1. CDB1 is a container database. 2. APP1_ROOT is an application container contained in CDB1. 3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT. 4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT. 5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0. 6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> ALTER SESSION SET CONTAINER=app1_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> GRANT CREATE SESSION TO USER1; Grant succeeded. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO '2.0'; Pluggable database altered SQL> ALTER SESSION SET CONTAINER=app1_pdb1; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC; Pluggable database altered. Which two are true?

A.

USER1 can connect to CDB1.

B.

USER1 can connect to APP1_ROOT and APP1_PDB1.

C.

USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.

D.

USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.

E.

USER1 can connect only to APP1_ROOT.

Full Access
Question # 36

Choose three. Which three are true about recovering tables using RMAN?

A.

RMAN can recover tables owned by the SYSTEM user.

B.

RMAN can recover tables owned by the SYS user.

C.

RMAN can recover tables in the SYSTEM tablespace.

D.

RMAN always uses an auxiliary instance.

E.

RMAN can recover a table after a DDL operation has altered the table structure.

F.

RMAN can recover tables in the SYSAUX tablespace.

G.

RMAN can recover tables in a standby database.

Full Access
Question # 37

Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area?

A.

the backup retention policy

B.

the backup optimization policy

C.

the DB_CREATE_ONLINE_LOG_DEST_n parameter setting

D.

the archived log deletion policy

E.

the DB_RECOVERY_FILE_DEST parameter setting

F.

using guaranteed UNDO retention

Full Access
Question # 38

Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

A.

The control file is backed up whenever a new tablespace is created.

B.

The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

C.

The control file is backed up whenever a new table is created.

D.

The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

E.

It requires the use of fast recovery area (FRA).

F.

The control file is backed up automatically each time the SPFILE is backed up manually.

Full Access
Question # 39

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?

A.

an operating system user to own this installation

B.

the Oracle Inventory group oinstall

C.

an operating system account called grid

D.

a group called dba

E.

the installation of Oracle ASMLIB

Full Access
Question # 40

Choose three. The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true?

A.

A proxy PDB must exist in the application root in the local CDB.

B.

PDB3's application root replica must exist in the local CDB.

C.

The HR_ROOT replica must exist in the remote CDB.

D.

A database link must exist in the remote CDB referring to the local CDB.

E.

A proxy PDB must exist in the application root in the remote CDB.

F.

A database link must exist in the local CDB root referring to the remoteCDB.

Full Access
Question # 41

Choose three. Which three actions are mandatory post database upgrade?

A.

Updating client scripts with the new Oracle home.

B.

Resetting passwords to enforce case-sensitivity.

C.

Run OPatch commands from the new Oracle home.

D.

Setting threshold values for tablespace alerts.

E.

Migration to unified auditing.

F.

Upgrading user tables that depend on Oracle-maintained abstract data types.

Full Access
Question # 42

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

A.

It is integrated with the SQL Access Advisor.

B.

It predicts the impact of system changes on SQL workload response time.

C.

It provides before and after execution statistics for each SQL statement in the analysis task

D.

It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

E.

SQL statements that were originally run concurrently are run concurrently by SPA.

Full Access