1Z0-147無料問題集「Oracle9i program with pl/sql」

質問 1

Which four triggering events can cause a trigger to fire? (Choose four)

（A）A user executes a JOIN statement that uses four or more tables.

（B）A specific user or any user logs on or off.

（C）A user executes a SELECT statement with an ORDER BY clause.

（D）A database is shut down or started up.

（E）A specific error or any errors occurs.

（F）A user executes a CREATE or an ALTER table statement.

正解：B、D、E、F 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

Examine this code:
CREATE OR REPLACE PRODECURE add_dept (p_dept_name VARCHAR2 DEFAULT 'placeholder', p_location VARCHAR2 DEFAULT 'Boston')
IS BEGIN INSERT INTO departments VALUES (dept_id_seq.NEXTVAL, p_dept_name, p_location); END add_dept; /
Which three are valid calls to the add_dep procedure? (Choose three)

（A）add_dept(p_location=>'New York');

（B）add_dept;

（C）add_dept(, 'New York');

（D）add_dept('Accounting');

正解：A、B、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

Which two describe a stored procedure? (Choose two)

（A）A stored procedure has three parts: the specification, the body, and the exception handler part.

（B）A stored procedure is typically written in SQL.

（C）A stored procedure is a type of PL/SQL subprogram that performs an action.

（D）The executable section of a stored procedure contains statements that assigns values, control execution, and return values to the calling environment.

（E）A stored procedure is a named PL/SQL block that can accept parameters.

正解：C、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

Which three are valid ways to minimize dependency failure? (Choose three)

（A）Querying with the SELECT * notification.

（B）Specifying package.procedure notation while executing procedures.

（C）Declaring records by using the %ROWTYPE attribute.

（D）Specifying schema names when referencing objects.

（E）Declaring variables with the %TYPE attribute.

正解：A、C、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

Examine this package:
CREATE OR REPLACE PACKAGE BB_PACK IS V_MAX_TEAM_SALARY NUMBER(12,2); PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBER); END BB_PACK; / CREATE OR REPLACE PACKAGE BODY BB_PACK IS V_PLAYER_AVG NUMBER(4,3); PROCEDURE UPD_PLAYER_STAT V_ID IN NUMBER, V_AB IN NUMBER DEFAULT 4, V_HITS IN NUMBER) IS BEGIN UPDATE PLAYER_BAT_STAT SET AT_BATS = AT_BATS + V_AB, HITS = HITS + V_HITS WHERE PLAYER_ID = V_ID; COMMIT; VALIDATE_PLAYER_STAT(V_ID);
END UPD_PLAYER_STAT;
PROCEDURE ADD_PLAYER
(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBER)
IS
BEGIN
INSERT INTO PLAYER(ID,LAST_NAME,SALARY)
VALUES (V_ID, V_LAST_NAME, V_SALARY);
UPD_PLAYER_STAT(V_ID,0,0);
END ADD_PLAYER;
END BB_PACK
/
Which statement will successfully assign .333 to the V_PLAYER_AVG variable from a procedure
outside the package?

（A）BB_PACK.V_PLAYER_AVG := .333;

（B）This variable cannot be assigned a value from outside of the package.

（C）BB_PACK.UPD_PLAYER_STAT.V_PLAYER_AVG := .333;

（D）V_PLAYER_AVG := .333;

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

Examine this package:
CREATE OR REPLACE PACKAGE pack_cur
IS
CURSOR c1 IS
SELECT prodid
FROM product
ORDER BY prodid DESC;
PROCEDURE proc1;
PROCEDURE proc2;
END pack_cur;
/
CREATE OR REPLACE PACKAGE BODY pack_cur
IS
v_prodif 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;
You then execute the procedure PROC2 from SQL *Plus with the command:
EXECUTE pack_cur.PROC2;
What is the output in your session from the PROC2 procedure?

（A）Row is: Row is: Rows is:

（B）ERROR at line 1:

（C）Row is: 1 Row is: 2 Row is: 3

（D）Row is: 4 Row is: 5 Row is: 6

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

How can you migrate from a LONG to a LOB data type for a column?

（A）You cannot migrate from a LONG to a LOB date type for a column.

（B）Use the DBMS_LOB.MIGRATE procedure.

（C）Use the UTL_MANAGE_LOMIGRATE procedure.

（D）Use the DBMS_MANAGE_LOB.MIGRATE procedure.

（E）Use the ALTER TABLE command.

正解：E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

All users currently have the INSERT privilege on the PLAYER table. You only want your users to insert into this table using the ADD_PLAYTER procedure. Which two actions must you take? (Choose two)

（A）GRANT SELECT ON ADD_PLAYER TO PUBLIC;

（B）REVOKE INSERT ON PLAYER FROM PUBLIC;

（C）GRANT INSERT ON PLAYER TO PUBLIC;

（D）GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;

（E）GRANT EXECUTE,INSERT ON ADD_PLAYER TO PUBLIC;

正解：B、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

Examine this code
CREATE OR REPLACE PROCEDURE load bfile (p_flle_loc IN VARCHAR2)
IS
V_file BFILE;
V_filename VARCHAR2 (16);
CURSOR emp_cursor IS
SELECT employee_id
FROM employees
WHERE Job_id = 'IT_PROG'
FOR UPDATE;
BEGIN
FOR emp_record IN emp_cursor LOOP
V_filename:= emp_record.employee_id || '.GIF';
V_file := BFILENAME(p_flle_loc, v_filename);
END LOOP;
END;
/
What does the BFILENAME function do?

（A）It returns a BFILE locator that is associated with a physical LOB binary file on the server's file system

（B）It reads data from an external BFILE

（C）It checks for the existence of an external BFILE

（D）It creates a directory object for use with the external BFILEs

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

Which statements are true? (Choose all that apply)

（A）If errors occur during the compilation of a trigger you can use the SHOW ERRORS command within iSQL *Plus to see the compilation errors.

（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, the trigger is still created.

正解：A、C、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

1Z0-147 無料問題集「Oracle9i program with pl/sql」

弊社を連絡する

関連リンク

トップ試験