Oracle
1Z0-146 · Question #102
1Z0-146 Question #102: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #102. The question stem and answer options stay visible for context.
Question
Examine the following command to create the table EMPLOYEES_TEMP and the PL/SQL block. CREATE TABLE employees_temp (empid NUMBER(6) NOT NULL, deptid NUMBER(6) CONSTRAINT c_emp_deptid CHECK (deptid BETWEEN 100 AND 200), salary Number(8), deptname VARCHAR2(30) DEFAULT 'Sales') / DECLARE SUBTYPE v_emprec_subtype IS employees_temp%ROWTYPE; v_emprec v_emprec_subtype; BEGIN v_emprec.empid := NULL; v_emprec.salary := 10000.002; v_emprec.deptid := 50; DBMS_OUTPUT.PUT_LINE('v_emprec.deptname: ' || v_emprec.deptname); END; / Which statements are true about the above PL/SQL block? (Choose two.)
Options
- AV_EMPREC.DEPTNAME would display a null value because the default value is not inherited.
- BAssigning null to V_EMPREC.EMPID would generate an error because the null constraint is inherited.
- CAssigning the value 1000.002 to V_EMPREC.SALARY would generate an error because of the decimal.
- DAssigning the value 50 to V_EMPREC.DEPTID would work because the check constraint is not inherited.
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.