1z0-083 Free Practice Test

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 SQL Performance Analyzer (SPA)? (Choose two.)

1. A. It is integrated with the SQL Access Advisor.
2. B. It predicts the impact of system changes on SQL workloadresponse time.
3. C. It provides before and after execution statistics for each SQL statement in the analysis task
4. D. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
5. E. SQL statements that were originally run concurrently are run concurrently by SPA.

Correct Answer: BD

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

1. A. PDB1 data files already exist in the correct location.
2. B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
3. C. PDB_FILE_NAME_CONVERT must be set before executing the command.
4. D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data filesfor PDB1.
5. E. PDB1 must be dropped from CDB1.

Correct Answer: AE

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

1. A. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
2. B. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
3. C. An existing Oracle base can be used.
4. D. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
5. E. Existing Oracle Database instances must be shut down before starting the upgrade.
6. F. Only the grid user can perform the upgrade.

Correct Answer: DEF

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

1. A. SBT tape compression can be used even if no RMAN compression is configured.
2. B. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
3. C. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
4. D. SBT tape compression and RMAN backup compression should be used in parallel.
5. E. The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

Correct Answer: DE