Prüfungsangst entsteht vor allem durch das Unbekannte. Die Test-Engine von Fast2test simuliert die Prüfungsumgebung der 1Z0-060 Prüfung realistisch, sodass Sie Ablauf und Fragenformate der Oracle Upgrade to Oracle Database 12c schon vor dem großen Tag kennen.

Oracle 1Z0-060 Prüfungsübersicht:

Oracle 1Z0-060 Prüfungsthemen:

Häufig gestellte Fragen zur Oracle Upgrade to Oracle Database 12c

Oracle Upgrade to Oracle Database 12c 1Z0-060 Prüfungsfragen mit Lösungen

Frage #1

Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

A. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
B. In a PDB plan, subplans may be used with up to eight consumer groups.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated toconsumergroups across all PDBs in the CDB.
D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
E. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

Frage #2

Which two statements are true regarding single row functions?

A. CONCAT: can be used to combine any number of values
B. SYSDATE: returns the database server current date and time
C. MOD: returns the quotient of a division
D. TRUNC: can be used with number and date values
E. TRIM: can be used to remove all the occurrences of a character from a string
F. INSTR: can be used to find only the first occurrence of a character in a string

Frage #3

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

A. All users except sys and SCOTT
B. All users except SYS
C. All users except sys, system, and SCOTT
D. All users except SCOTT

Frage #4

You are the DBA for an Oracle Database 11g Release 1 data warehouse database running on Oracle Linux with little endianness.
You want to plug in a transportable tablespace with a 16K blocksize from an Oracle Database
10g database that is running on a SPARC-based Oracle Solaris system with big endianness.
The data warehouse database has the following parameters set:

The following parameters are not explicitly set:

What action must you perform on the data warehouse database to prepare it for the transportable tablespace plug in operation?

A. Set ALTER SYSTEM SET DB_CACHE_SIZE=192M followed by ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M;
B. Do nothing, because Automatic Memory Management will size DB_16K_CACHE_SIZE automatically
C. Set ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M and leave other parameters set to their current settings.
D. Do nothing, because Automatic Shared Memory Management will size DB_16K_CACHE_SIZE automatically.
E. Do nothing, because you cannot transport a tablespace between databases with different endian formats.

Frage #5

Which three statements are true concerning unplugging a pluggable database (PDB)?

A. The PDB must be dosed.
B. The PDB must be open in read only mode.
C. The PDB data files are automatically removed from disk.
D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
E. The unplugged PDB can be plugged into another CDB.
F. The unplugged PDB becomes a non-CDB.

Fragen und Antworten: