Review questions

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

1. A NAV table is the definition of data structure
2. A NAV table includes a built-in data entry page
3. A NAV table can contain C/AL code, but that should be avoided
4. A NAV table should implement many of the business rules of a system

Q.2. All primary keys should contain only one data field. True or False?

Q.3. With which property is it possible to link a NAV table to a table outside of the NAV database? Choose one.

1. DatabaseLink
2. ObjectPointer
3. LinkedObject
4. C# Codelet

Q.4. System Tables cannot be modified. True or False?

Q.5. Which of the following are Table triggers? Choose two.

1. OnInsert
2. OnChange
3. OnNewKey
4. OnRename

Q.6. Keys can be enabled or disabled in executable code. True or False?

Q.7. Because Setup Tables only contain one record, they do not need to have a Primary Key. True or False?

Q.8. Table numbers intended to be used for customized table objects should only range between 5000 and 9999. True or False?

Q.9. Which of the following tables can be modified by Partner developers? Choose three.

1. Customer
2. Date
3. User
4. Item Ledger Entry

Q.10. The DropDown display on a field lookup in the RTC can be changed by modifying the table's Field Groups. True or False?

Q.11. Temporary table data can be saved in a special database storage area. True or False?

Q.12. Which of the following Virtual Tables are commonly used in NAV development projects? Choose two.

1. Date
2. GPS Location
3. Integer
4. Object Metadata

Q.13. SumIndexFields can be used to calculate totals. True or False?

Q.14. Table Permissions (for access to another table's data) include which of the following permissions. Choose three.

1. read
2. sort
3. delete
4. modify

Q.15. The TableRelation property allows a field in one table to reference data in another table. True or False?

Q.16. Tables can be created or deleted dynamically. True or False?

Q.17. Only Tables have Triggers, and only Fields have Properties. True or False?

Q.18. Ledger data in NAV can be freely updated through either posting routines or direct data entry. True or False?

Q.19. SQL Server for NAV supports SIFT by which mechanism? Choose one.

1. SQL SIFT indexes
2. SQL Dynamic Indexes
3. SQL Indexed Views
4. SIFT not supported in SQL

Q.20. Reference Tables and Virtual Tables are simply two different names for the same type of table. True or False?