1Y0-456 Citrix Other Certification exam

1Z0-001  (9i Internet Application Developer Introduction to Oracle: SQL and PL/SQL) 덤프 소개합니다.무료 덤프 도 볼수 있으니까 먼저 와서 보시고 구매여부를 정해도 좋습니다.다른 자격증 덤프도 있으니 아무튼 와서 한번 보십시요.완벽한 덤프라고 말할정도로 96%점유률입니다.홈페이지:www.killtest.kr

시험번호: 1Z0-001

1.The EMPLOYEE table contains these columns: BONUSNUMBER(7,2) DEPT_ID NUMBER(9)
There are 10 departments and each department has at least 1 employee. Bonus values are greater
than 500; not all employees receive a bonus. Evaluate this PL/SQL block: DECLARE
v_bonusemployee.bonus%TYPE := 300; BEGIN UPDATE employee SET bonus = bonus + v_bonus
WHERE dept_id IN (10, 20, 30); COMMIT; END; What will be the result?
A.All employees will be given a 300 bonus.
B.A subset of employees will be given a 300 bonus.
C.All employees will be given a 300 increase in bonus.
D.A subset of employees will be given a 300 increase in bonus.
Correct:D
2.Evaluate this IF statement: IF v_value > 100 THEN v_new_value := 2 * v_value; ELSIF v_value >
200 THEN v_new_value := 3 * v_value; ELSIF v_value < 300 THEN v_new_value := 4 * v_value;
ELSE v_new_value := 5 * v_value; END IF; What would be assigned to V_NEW_VALUE if V_VALUE
is 250?
A.250
B.500
C.750
D.1000
E.1250
Correct:B
3.Which ALTER command would you use to reinstate a disabled primary key constraint?
A.ALTER TABLE cars ENABLE PRIMARY KEY (id);
B.ALTER TABLE cars ENABLE CONSTRAINT cars_id_pk;
C.ALTER TABLE cars ENABLE PRIMARY KEY (id) CASCADE;
D.ALTER TABLE cars ADD CONSTRAINT cars_id_pk PRIMARY KEY (id);
Correct:B
4.You need to perform a major update on the EMPLOYEE table. You have decided to disable the
PRIMARY KEY constraint on the empid column and the CHECK constraint on the job column.
What happens when you try to enable the constraints after the update is completed?
A.You need to recreate the constraints once they are disabled.
B.Any existing rows that do not confirm with the constraints are automatically deleted.
C.Only the future values are verified to confirm with the constraints, leaving the existing values unchecked.
D.The indexes on both the columns with the PRIMARY KEY constraint and the CHECK constraint are
automatically re-created.
E.All the existing column values are verified to confirm with the constraints and an error message is
generated if any existing values do not confirm.
Correct:E
5.Which statement is valid within the executable section of a PL/SQL block?
A.BEGIN emp_rec emp%ROWTYPE; END;
B.WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE ('No records found');
C.SELECT ename, sal INTO v_ename, v_sal FROM emp WHERE empno = 101;
D.PROCEDURE calc_max (n1 NUMBER,n2 NUMBER,p_max OUT NUMBER) IS BEGIN IF n1 > n2
THEN p_max := n1; ELSE p_max := n2; END;
Correct:C