Oracle
1Z0-144 · Question #51
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…
The correct answer is D. The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME. See the full explanation below for the reasoning.
Question
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?
Options
- AThe SAME_NAME variable inherits only the data type from the CUST_NAME variable.
- BThe SAME_NAME variable inherits only the data type and default value from the CUST_NAME
- CThe SAME_NAME variable inherits the data type, constraint, and default value from the
- DThe SAME_NAME variable inherits only the data type and constraint from the CUST_NAME
How the community answered
(21 responses)- A14% (3)
- B5% (1)
- C5% (1)
- D76% (16)
Community Discussion
No community discussion yet for this question.