Oracle 1Z0-147 問題集

質問 1：
Which statements are true? (Choose all that apply)
A. If errors occur during the compilation of a trigger, the trigger is still created.
B. If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_TRIGGERS data dictionary view to see the compilation errors.
C. If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_ERRORS data dictionary view to see compilation errors.
D. If errors occur during the compilation of a trigger you can use the SHOW ERRORS command within iSQL *Plus to see the compilation errors.
正解：A,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Examine this procedure:
CREATE OR REPLACE PROCEDURE DELETE_PLAYER (V_ID IN NUMBER) IS BEGIN
DELETE FROM PLAYER
WHERE ID = V_ID;
EXCEPTION
WHEN STATS_EXITS_EXCEPTION
THEN DBMS_OUTPUT.PUT_LINE
('Cannot delete this player, child records exist in PLAYER_BAT_STAT table');
END;
What prevents this procedure from being created successfully?
A. A comma has been left after the STATS_EXIST_EXCEPTION exception.
B. The STATS_EXIST_EXCEPTION has not been declared as an exception.
C. Only predefined exceptions are allowed in the EXCEPTION section.
D. The STATS_EXIST_EXCEPTION has not been declared as a number.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
A. An area of memory is established to process the SQL statement.
B. The validity of the SQL statement is established.
C. The area of memory established to process the SQL statement is released.
D. The SQL statement is run and the number of rows processed is returned.
E. The rows are selected and ordered.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Examine this code:
CREATE OR REPLACE FUNCTION calc_sal(p_salary NUMBER)
RETURN NUMBER
IS
v_raise NUMBER(4,2) DEFAULT 1.08;
BEGIN
RETURN v_raise * p_salary;
END calc_sal;
/
Which statement accurately call the stored function CALC_SAL? (Choose two)
A. SELECT salary, calc_sal(salary)
FROM employees
WHERE department_id = 60;
B. DELETE FROM employees(calc_sal(salary))
WHERE calc_sal(salary) > 1000;
C. SELECT last_name, salary, calc_sal(salary)
FROM employees ORDER BY
calc_sal(salary);
D. UPDATE employees (calc_sal(salary))
SET salary = salary * calc_sal(salary);
E. INSERT calc_sal(salary) INTO employees
WHERE department_id = 60;
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine this package:
CREATE OR REPLACE PACKAGE pack_cur IS CURSOR c1 IS SELECT prodid FROM poduct ORDER BY prodid DESC; PROCEDURE proc1; PROCEDURE proc2; END pack_cur; /
CREATE OR REPLACE PACKAGE BODY pack_cur IS v_prodid NUMBER; PROCEDURE proc1 IS BEGIN OPEN c1;
LOOP
FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE('Row is: ' || c1%ROWCOUNT);
EXIT WHEN c1%ROWCOUNT >= 3;
END LOOP;
END proc1;
PROCEDURE proc2 IS
BEGIN
LOOP
FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE('Row is: ' ||c1%ROWCOUNT);
EXIT WHEN c1%ROWCOUNT >= 6;
END LOOP;
CLOSE c1;
END proc2;
END pack_cur;
/
The product table has more than 1000 rows. The SQL *Plus SERVEROUTPUT setting is turned
on in your session.
You execute the procedure PROC1 from SQL *Plus with the command:
EXECUTE pack_cur.proc1
What is the output in your session?
A. Row is: Row is: Row is:
B. Row is: 4 Row is: 5 Row is: 6
C. Row is: 1 Row is: 2 Row is: 3
D. ERROR at line 1:
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three are true statements about dependent objects? (Choose three)
A. The Oracle server automatically records dependencies among objects.
B. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.
C. An object with status of invalid cannot be a referenced object.
D. All schema objects have a status that is recorded in the data dictionary.
E. Invalid objects cannot be described.
F. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.
正解：A,E,F
解説: (Topexam メンバーにのみ表示されます)