Oracle 1Z0-147 Prüfungsthemen:
| Abschnitt | Ziele |
|---|---|
| Thema 1: Prozeduren und Funktionen | - Gespeicherte Programmeinheiten
|
| Thema 2: Programmsteuerungsstrukturen | - Bedingte und iterative Verarbeitung
|
| Thema 3: Datenbank-Trigger | - Implementierung von Triggern
|
| Thema 4: Große Objekte und erweiterte PL/SQL-Funktionen | - LOB-Datentypen und vordefinierte Pakete
|
| Thema 5: Cursor und Sammlungen | - Verwaltung von Cursorn
|
| Thema 6: SQL innerhalb von PL/SQL | - DML-Operationen
|
| Thema 7: Grundlagen von PL/SQL | - PL/SQL-Blöcke
|
| Thema 8: Ausnahmebehandlung | - Fehlerbehandlung
|
| Thema 9: Pakete | - Entwicklung von Paketen
|
Oracle9i program with pl/sql 1Z0-147 Prüfungsfragen mit Lösungen
1. Which two does the INSTEAD OF clause in a trigger identify? (Choose two)
A) The view associated with the trigger.
B) The event associated with the trigger.
C) The table associated with the trigger.
D) The statement level or for each row association to the trigger.
E) The package associated with the trigger.
2. Which three are true regarding error propagation? (Choose three)
A) An exception raised inside a declaration immediately propagates to the current block.
B) An exception raised inside an exception handler immediately propagates to the enclosing block.
C) An exception cannot propagate across remote procedure calls.
D) The use of the RAISE; statement in an exception handler reraises the current exception.
3. A CALL statement inside the trigger body enables you to call ______.
A) A stored function.
B) A stored procedure.
C) A package.
D) Another database trigger.
4. Examine this procedure:
CREATE OR REPLACE PROCEDURE INSERT_TEAM
(V_ID in NUMBER, V_CITY in VARCHAR2 DEFAULT 'AUSTIN', V_NAME in VARCHAR2)
IS
BEGIN
INSERT INTO TEAM (id, city, name)
VALUES (v_id, v_city, v_name);
COMMIT;
END
Which two statements will successfully invoke this procedure in SQL *Plus? (Choose two)
A) EXECUTE INSERT_TEAM(3, 'AUSTIN','LONGHORNS');
B) EXECUTE INSERT_TEAM;
C) EXECUTE INSERT_TEAM (3, 'LONGHORNS');
D) EXECUTE INSERT_TEAM (V_ID := V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');
E) EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN');
5. Examine this code CREATE OR REPLACE FUNCTION change_dept (p_old_id NUMBER, p_deptname VARCHAR2) RETURN NUMBER IS V_new_id NUMBER; BEGIN SELECT departments_seq.nextval INTO v_new_id FROM dual; UPDATE departments SET departmenet_id = v_new_id, Department_name = p_deptname WHERE department_id = p_old_id; Return v_new_id; END; /
There are no foreign key integrity constraints on the EMPLOYEES and DEPARTMENTS tables. Which statement performs a successful update to the EMPLOYEES table?
A) UPDATE departments
SET department_id = change_dept(10, 'Finance')
Where department_id = 10;
B) UPDATE employees
SET department_id = change_dept(10, 'Finance')
Where department_id = 10;
C) UPDATE departments
change_dept(270, 'Outsource')
Where department_name = 'payroll';
D) UPDATE employees
SET department_id = change_dept(10, 'Finance')
Where department_id = DEPARTMENTS:CURRVAL;
Fragen und Antworten:
| 1. Frage Antwort: A,B | 2. Frage Antwort: B,C,D | 3. Frage Antwort: B | 4. Frage Antwort: A,E | 5. Frage Antwort: B |
1242 Kundenbewertungen
