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

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

Correct Answer: AB

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

1. A. The number of table rows is considered when evaluating the cost of accessing a table using an index.
2. B. Index balanced B*Tree height is considered whenevaluating the cost of using an index.
3. C. The Statistics Advisor can help recommend the best way to gather statistics.
4. D. Statistics collected using DBMS_STATS always yield the best optimizer result.
5. E. The Statistics Advisor generates actions for all recommendations.

Correct Answer: CD

Examine this configuration:
CDB1is a container database.
PDB1andPDB2arepluggable databases inCDB1.
PDB1andPDB2areOPENinREAD WRITEmode.
You execute these commands successfully:

Which two are true? (Choose two.)

1. A. Uncommitted transactions in PDB1 have been rolled back.
2. B. PDB1 is closed.
3. C. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
4. D. CDB1 is shut down.
5. E. CDB1 is in MOUNT state

Correct Answer: AB

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

1. A. Duplication can be done by having the auxiliary databaseinstance pull backup sets from the target database instance.
2. B. A connection to an auxiliary instance is always required.
3. C. A subset of the target database can be duplicated.
4. D. A new DBID is always created for the duplicated database.
5. E. A connection tothe recovery catalog instance is always required.
6. F. A backup of the target database is always required.
7. G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
8. H. A connection to the target database instance is always required.

Correct Answer: ABCG
A duplicate database is a copy of your target database. With the FOR STANDBY clause, it keeps the same unique database identifier(DBID); If FOR STANDBY not specified it creates a new DBID. The duplicate database can include the same content or only a subset from the source database. It can be in the same host or a separate host. The principal work of the duplication is performed by the auxiliary channels.These channels correspond to a server session on the auxiliary instance on the destination host for backup based duplication. For active database duplication the target channels perform the work of pushing data file copies to the auxiliary instance (if number of allocated target channels is greater than the number of allocated auxiliary channels).