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? (Choose two.)

• A.PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
• B.PDB1 will be created in CDB2 and automatically opened.
• C.PDB1 will be created in CDB2 and left in MOUNT state.
• D.PDB1_C2_SRV will be created and started automatically.
• E.PDB1_C2_SRV will be created but not started.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about the Optimizer Statistics Advisor?

• A.It can be run only manually.
• B.It can recommend changes to improve the statistics gathering process.
• C.It always analyzes all schemas in the database.
• D.It runs automatically every night by default. E) It can be run only automatically.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
(Choose two.)

• A.SQL statements doing joins always do more physical I/O than single table queries.
• B.SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
• C.Poorly performing SQL statements can be tuned automatically by the Oracle server.
• D.The solution that best optimizes one SQL statement can degrade the performance of others.
• E.SQL statements doing only logical reads never require tuning because they do no physical I/O.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome
Oracle_home_path
For which two purposes can you use this command? (Choose two.)

• A.to switch an existing Oracle Database home to a newer release of Oracle software on the same server
• B.to switch to a read-only Oracle home
• C.to switch back to the previous Oracle home as part of a rollback operation
• D.to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
• E.to switch to a patched Oracle Database home

Comment: *

Name: *

Email: *

Verification: *