Wenn Beruf und Alltag kaum Raum für stundenlanges Lernen lassen, brauchen Sie einen effizienten Weg zur Oracle Database 11g: New Features for Administrators Prüfung. Die 183 Übungsfragen von ITZert decken den prüfungsrelevanten Stoff der 1Z0-050 gezielt ab, sodass Sie auch mit wenig Zeit strukturiert vorgehen.

Oracle 1Z0-050 Prüfungsübersicht:

Zertifizierungsanbieter:	Oracle
Prüfungsname:	Oracle Database 11g: Neue Funktionen für Administratoren
Prüfungsnummer:	1Z0-050
Verfügbare Sprachen:	Weitere regionale Sprachen (je nach Prüfungszentrum unterschiedlich), Englisch
Prüfungsgebühr:	Preise in US-Dollar variieren je nach Region — üblicherweise ca. 245 USD
Prüfungsdauer:	105 (ca.)
Anzahl der Fragen:	77 (ca.)
Verwandte Zertifizierungen:	Oracle Database 11g Administrator Certified Professional
Mindestpunktzahl:	61 % (ca.)
Prüfungsformat:	Multiple-Choice-Fragen
Gültigkeitsdauer des Zertifikats:	Keine festgelegte Gültigkeitsdauer (unterliegt der Zertifizierungsrichtlinie von Oracle)
Beispielfragen:
Prüfungsmethode:	Vor Ort in autorisierten Prüfungszentren oder online über die von Oracle zugelassenen Prüfungsanbieter
Voraussetzungen:	In der Regel werden vorhandene Kenntnisse als Oracle-Datenbankadministrator vorausgesetzt; die Prüfung dient hauptsächlich der Aktualisierung für Inhaber des Oracle 10g OCP-Zertifikats
Offizielle Syllabus-URL:	https://education.oracle.com/exam_test

Oracle 1Z0-050 Prüfungsthemen:

Oracle Database 11g: New Features for Administrators: Die wichtigsten Fragen im Überblick

Oracle Database 11g: New Features for Administrators 1Z0-050 Prüfungsfragen mit Lösungen

Frage #1

Evaluate the following statements:
CREATE TABLE purchase_orders
(pojd NUMBER(4),
po_date TIMESTAMP,
supplie_id NUMBER(6),
po_total NUMBER(8,2),
CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date)
(PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?),
PARTITION Q2 VALUES LESS THAN (TO_DATE(?1-jul-2007?d-mon-yyyy?),
PARTITION Q3 VALUES LESS THAN (TO_DATE(?1-oct-2007?d-mon-yyyy?),
PARTITION Q4 VALUES LESS THAN (TO_DATE(?1-jan-2008?d-mon-yyyy?));
CREATE TABLE purchase_order_items
(po_id NUMBER(4) NOT NULL, product_id NUMBER(6) NOT NULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_fk
FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
What are the two consequences of the above statements? (Choose two.)

A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
B. Partition maintenance operations performed on the PURCHASEJDRDERJTEMS table are automatically reflected in the PURCHASEjDRDERS table.
C. Both PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four partitions each.
D. The PURCHASEJDRDERJTEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
E. Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the partitions of the PURCHASEJDRDERS table.

Frage #2

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

A. You cannot create an incremental incident package when the physical files are purged from the ADR.
B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
C. You can add or remove the trace files to the package.
D. You can add SQL test cases to the incident package,

Frage #3

You executed the following PL/SQL block successfully:
VARIABLE tname VARCHAR2(20)
BEGIN
dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage1,
FINDING_NAME=>'CPU Usage1,
MIN_ACTIVE_SESSIONS=>0,MIN_PERC_IMPACT=>90);
:tname := 'database ADDM task4';
dbms_addm.analyze_db(:tname, 150,162);
END;
/
Then you executed the following command:
SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;
The above command produces Automatic Database Diagnostic Monitor (ADDM)
analysis____.

A. with the CPU Usage finding if it is less than 90
B. with the CPU Usage finding for snapshots not between 150 and 162
C. with the CPU Usage finding for snapshots below 90
D. without the CPU Usage finding if it is less than 90

Frage #4

Which statement is true regarding the VALIDATE DATABASE command?

A. It checks for block corruption in the valid backups of the database.
B. It checks the database for both intrablock and interblock corruptions.
C. It checks the database for intrablock corruptions only
D. It checks for only those corrupted blocks that are associated with data files.

Frage #5

Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)

A. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks that have read disk I/O errors
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

Fragen und Antworten: