HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

• A.Create the PDB1 application PDB and synchronize it with HR_ROOT.
• B.Create the PDB1 application PDB and synchronize it with poB$SEED.
• C.Create an application seed, and install HR_APP in it.
• D.Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.
• E.Create the PDB1 application PDB and install HR_APP in it.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the character sets used in an Oracle database? (Choose two.)

• A.Single-byte character sets provide better performance than multibyte character sets.
• B.Unicode enables information from any language to be stored using a single character set.
• C.Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
• D.Single-byte character sets always use 7-bit encoding schemes.
• E.Multibyte character sets allow more efficient space utilization than single byte character sets.
• F.Single-byte character sets always use 8-bit encoding schemes.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about backup encryption?

• A.Backup encryption can be enabled selectively for specific tablespaces.
• B.Image copies can be encrypted.
• C.The BACKUP BACKUPSET command can encrypt and decrypt backup sets.
• D.Keystore-based encryption is the default mode for RMAN backup encryption.
• E.The Transparent Data Encryption (TDE) keystore is backed up using RMAN.
• F.Vendor-specific media management software can be used for making encrypted RMAN backups to media.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

• A.CDB1, PDB1, and PDB2 only
• B.CDB1 and PDB$SEED only
• C.CDB1, PDB$SEED, PDB1, and PDB2
• D.PDB$SEED, PDB1, and PDB2 only
• E.CDB1, PDB$SEED, and PDB1 only

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

• A.V$SESSTAT
• B.V$SESSION_WAIT_CLASS
• C.V$SESSION_EVENT
• D.V$SESSION
• E.V$SESSION_WAIT

Comment: *

Name: *

Email: *

Verification: *