AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-001





Question ID 8069

Examine this block of code: SET OUTPUT ON Declare X NUMBER; V_SAL NUMBER; V_found VARCHAR2(10):='TRUE'; Begin X:=1; V_sal := 1000; Declare V_found VARCHAR2(10); Y NUMBER Begin IF (V_Sal>500) THEN V_found := 'YES'; END IF; DBMS_OUTPUT.PUT_LINE('Value of V_found is '|| V_Sal); DBMS_OUTPUT.PUT_LINE('Value of V_Sal is '|| TO_CHAR (V_Sal)); Y:=20; END; DBMS_OUTPUT.PUT_LINE('Value of V_found is' || V_found); DBMS_OUTPUT.PUT_LINE('Value of Y is' || TO_CHAR(Y)); END; SET server OUTPUT if What is the result of executing this block of code?

Option A

PLS-00201: identifier 'Y' must be declared.

Option B

Value of V_found is YES Value of V_sal is 1000 Value of V_found is TRUE

Option C

Value of V_found is YES Value of V_found is 1000 Value of V_found is TRUE Value of Y is 20

Option D

PLS-00201: identifier 'V_sal' must be declared PLS-00201: identifier 'Y' must be declared

Option E

Value of V_found is YES Value of V_sal is 1000 Value of V_found is TRUE Value of Y is 20

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A is correct because PL/SQL variable 'Y' is not declared in DECLARE section of PL/SQL block, but only inside BEGIN ... END block and executing of this block will return error. Incorrect Answers: B: This code does work because of V_found and V_sal are identified. C: This code does work because of V_found and V_sal are identified. D: Identifier V_sal is declared, so code will fail because of identifier 'Y', not V_sal, must be declared. E: This code does work because of all variables are declared and populated with values. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 209 Chapter 5: Introducing PL/SQL


Question ID 8070

You need to store currency data and you know that data will always have two digits to the right of the decimal points. However the number of digits to the left of the decimal place will vary greatly. Which data type would be most appropriate to store the data?

Option A

NUMBER

Option B

NUMBER(T)

Option C

LANG

Option D

LANGRA

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A is correct because by default NUMBER is NUMBER(L, P) type, which is always stored as variable-length data, where 1 byte is used to store the exponent, 1 byte is used to store for every two significant digits of the number's mantissa, and 1 byte is used for negative numbers if the number of significant digits is less than 38 bytes. Incorrect Answers: B: NUMBER(T) type will not allow to keep more than T numbers of digits to the left of the decimal place, but question says that it will vary greatly. C: There is no type LANG in Oracle 8i. D: Type LANGRA does not exists too. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 390 Chapter 8: Managing Database objects I

Send email to admin@getfreedumps for new dumps request!!!