Multiple choice technology

What is the value of cust_id in the following expression: record string(8) cust_dept;    int cust_id = NULL(-1);    string(10) cust_name = NULL("    "); end

  1. Cust_id is space if its value is -1

  2. Cust_id is null if its value is -1

  3. ust_id is null if cust_name is space

  4. Cust_id is -1 if its value is space
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In this code (likely Informatica or similar ETL scripting), the syntax 'NULL(-1)' assigns a null value with a default fallback of -1. When cust_id's value is -1, it indicates the field is null (null representation). Option A is incorrect - it's not a space. Option C has a typo ('ust_id') and incorrect logic. Option D reverses the logic. The correct interpretation is that -1 represents null, so cust_id is null when its value equals -1.

Keep practicing — related questions