Review questions

  1. Which of the following is a correct description of a table in NAV 2017? Choose two:

a) A NAV table is the definition of data structure

b) A NAV table includes a built-in data entry page

c) A NAV table can contain C/AL code but that should be avoided

d) A NAV table should implement many of the business rules of a system

  1. All primary keys should contain only one data field. True or false?
  2. It is possible to link a NAV table to a table outside of the NAV database using what property? Choose one:

a) DatabaseLink

b) ObjectPointer

c) LinkedObject

d) C# Codelet

  1. System tables cannot be modified. True or false?
  2. Which of the following are table triggers? Choose two:

a) OnInsert

b) OnChange

c) OnNewKey

d) OnRename

  1. Keys can be enabled or disabled in executable code. True or false?
  2. Because Setup tables on contain one record, they do not need to have a primary key. True or false?
  3. Table numbers intended to be used for customized table objects should only range between 5000 to 9999. True or false?
  4. Which of the following tables can be modified by partner developers? Choose three:

a) Customer

b) Date

c) User

d) Item Ledger Entry

  1. The DropDown display on a field lookup in the RTC can be changed by modifying the table's Field Groups. True or false?
  2. Temporary table data can be saved in a special database storage area. True or false?
  1. The following Virtual tables are commonly used in NAV development projects. Choose two:

a) Date

b) GPS Location

c) Integer

d) Object Metadata

  1. SumIndexFields can be used to calculate totals. True or false?
  2. Table permissions (for access to another table's data) include which of the following permissions. Choose three:

a) read

b) sort

c) delete

d) modify

  1. The TableRelation property allows a field in one table to reference data in another table. True or false?
  2. Tables can be created or deleted dynamically. True or false?
  3. Only tables have triggers and only fields have properties. True or false?
  4. Ledger Entry data in NAV can be freely updated through either posting routines or direct data entry. True or false?
  5. SQL Server for NAV supports SIFT by which mechanism? Choose one:

a) SQL SIFT indexes

b) SQL dynamic indexes

c) SQL indexed views

d) SIFT not supported in SQL

  1. Reference tables and Virtual tables are simply two different names for the same type of tables. True or false?
上一章目录下一章