Review questions

Q.1. The maximum length for a C/AL field or variable name is 250 characters. True or False?

Q.2. The Table Relation property defines the reference of a data field to a table. The related table data field must be: (choose one)

1. In any key in the related table
2. Defined in the related table but not in a key
3. In the Primary Key in the related table
4. The first field in the primary key in the related table

Q.3. How many of the following Field Data Types support storing application data such as names and amounts 1, 2, 3 or 4?

1. FlowFilter
2. Editable
3. Normal
4. FlowField

Q.4. The ExtendedDataType property supports designation of all but one of the following data types, displaying an appropriate action icon. (Choose the one that is not supported.)

1. Email address
2. Website URL
3. GPS location
4. Telephone number
5. Masked entry

Q.5. Choose one of the following that is not a FlowField Method.

1. Median
2. Count
3. Max
4. Exist
5. Average

Q.6. It is important to have a consistent, well-planned approach to field numbers, especially if the application will use the TransferFields function. True or False?

Q.7. Field Filters and Limit totals cannot be used at the same time. True or False?

Q.8. Which property is used to support the multi-language feature of NAV? (choose one)

1. Name
2. CaptionML
3. Caption
4. LanguageRef

Q.9. Which of the following are Field Triggers? (Choose two)

1. OnEntry
2. OnValidate
3. OnDeletion
4. OnLookup

Q.10. Which of the following are complex data types? (Choose three)

1. Records
2. Strings of text
3. DateFormula
4. DateTime data
5. Objects

Q.11. Every table must have a Primary Key. A Primary Key entry can be defined as unique or duplicates allowed, based on a table property. True or False?

Q.12. Text and Code variables can be of any length.

1. In a memory variable (working storage)? True or False?
2. In a table field? True or False?

Q.13. FlowField results are not stored in the NAV table data. True or False?

Q.14. The following two filters are equivalent. True or False?

1. (*W50?|I?5|D*)
2. (I?5) OR (D*) OR (*W50?)

Q.15. Limit totals apply to FlowFilters. True or False?

Q.16. All Data Types can be used to define data in tables and working storage. True or False?

Q.17. DateFormula alpha time units include which of the following? (Choose two.)

1. C for century
2. W for week
3. H for holiday
4. CM for current month

Q.18. FlowFilter data is stored in the database. True or False?

Q.19. Option data is stored as alpha data strings. True or False?

Q.20. Which of the following are numeric data types in NAV 2015? (Choose two.)

1. Decimal
2. Option
3. Hexadecimal
4. BLOB

Q.21. Which of the following acts as wildcards in NAV 2015? (Choose two.)

1. Decimal Point ( . )
2. Question Mark ( ? )
3. Asterisk ( * )
4. Hash Mark ( # )