Exam 1z0-144 topic 1 question 47 discussion

Actual exam question from Oracle's 1z0-144

Question #: 47
Topic #: 1

Examine the following snippet of code from the DECLARE section of PL/SQL

DECLARE -
Cust_name VERCHAR2 (20) NOT NULL : = Tom Jones:
Same_name cust_name%TYPE:
Which statement is correct about the above snippets of code?

A. The SAME_NAME variable inherits only the data type from the CUST_NAME variable.
B. The SAME_NAME variable inherits only the data type and default value from the CUST_NAME variable.
C. The SAME_NAME variable inherits the data type, constraint, and default value from the CUST_NAME variable.
D. The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error

Show Suggested Answer

Suggested Answer: D 🗳️

by CosminCof at March 12, 2020, 10:28 a.m.

Comments

Submit Cancel

chaoyuim

Highly Voted 5 years, 1 month ago

D is right. read here. https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/type_attribute.htm#LNPLS01352

upvoted 5 times

...

Paps23

Most Recent 2 years, 7 months ago

D is right if the referenced items is not a column from db it inherits only the data type and constraint (Value with NOT NULL must be declared)

upvoted 1 times

...

CosminCof

5 years, 2 months ago

it should be B

upvoted 1 times

CosminCof

5 years, 2 months ago

sry I was wrong, the answer is C, because %type attribute inherits datatype (always), constraint (if the referenced items is not a column from db) and default value (if the referenced items is not a column from db)

upvoted 2 times

Aditya

3 years, 1 month ago

pls explain why C is correct

upvoted 1 times

...