Review questions

1. The maximum length for a C/AL field name or variable name is 250 characters long. True or false?
2. The Table Relation property defines the reference of a data field to a table. The related table data field must be... choose one:

a) In any key in the related table

b) Defined in the related table, but not in a key

c) In the primary key in the related table

d) The first field in the primary key in the related table

1. How many of the following field data types support the storing of application data such as names and amounts - 1, 2, 3 or 4?

a) FlowFilter

b) Editable

c) Normal

d) FlowField

1. The ExtendedDataType property supports the designation of all but one of the following data types, displaying an appropriate action icon. Choose the one not supported:

a) E-mail address

b) Website URL

c) GPS location

d) Telephone number

e) Masked entry

1. One of the following is not a FlowField Method. choose one:

a) Median

b) Count

c) Max

d) Exist

e) Average

1. 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?
2. Field filters and limit totals cannot both be used at the same time. True or false?

1. Which property is used to support the multi-language feature of NAV ? Choose one:

a) Name

b) CaptionML

c) Caption

d) LanguageRef

1. Which of the following are field triggers? Choose two:

a) OnEntry

b) OnValidate

c) OnDeletion

d) OnLookup

1. Which of the following are complex data types? Choose three:

a) Records

b) Strings of text

c) DateFormula

d) DateTime data

e) Objects

1. 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?
2. Text and code variables can be any length:

a) In a memory variable (working storage)? True or false?

b) In a table field? True or false?

1. FlowField results are not stored in the NAV table data. True or false?

1. The following two filters are equpalent. True or false?

a) (*W50?|I?5|D*)

b) (I?5) OR (D*) OR (*W50?)

1. Limit totals apply to FlowFilters. True or false?
2. All data types can be used to define data both in tables and in working storage. True or false?
3. DateFormula alpha time units include which of the following? Choose two:

a) C for century

b) W for week

c) H for holiday

d) CM for current month

1. FlowFilter data is stored in the database. True or false?
2. Option data is stored as alpha data strings. True or false?
3. Which of the following are numeric data types in NAV 2017? Choose two:

a) Decimal

b) Option

c) Hexadecimal

d) BLOB

1. Which of the following act as wildcards in NAV 2017? choose two:

a) Decimal point ( . )

b) Question mark ( ? )

c) Asterisk ( * )

d) Hash mark ( # )