Prüfungsfragen
19. Oktober 2005 17:57
Hallo,
ich möchte einen neuen Thread öffnen mit Prüfungsfragen, welche kommen können bzw. um diese zu Diskutieren.
Selbstverständlich sind alle Fragen und deren Antworten ohne jegliche Gewähr!
Hinweis: Mein Kenntnisstand ist der, dass die Fragen in Englisch gestellt werden. Es werden 100 Fragen gestellt in Multiple Coice Format (Eine oder mehrere Antworten können richtig sein!), für diese hat man 150 Minuten (2 ½ Std.) Zeit zum beantworten. Bei der Prüfung dürfen keine Unterlagen mit hinein, noch mitgenommen werden!
Hier ein paar (mögliche) Fragen:
FRAGE: Wie wird ein Ultimodatum in ein normales Datum Umgewandelt?
FRAGE: Gibt es Tabellen ohne Primary Key?
…to be continued…
Mikka
ich möchte einen neuen Thread öffnen mit Prüfungsfragen, welche kommen können bzw. um diese zu Diskutieren.
Selbstverständlich sind alle Fragen und deren Antworten ohne jegliche Gewähr!
Hinweis: Mein Kenntnisstand ist der, dass die Fragen in Englisch gestellt werden. Es werden 100 Fragen gestellt in Multiple Coice Format (Eine oder mehrere Antworten können richtig sein!), für diese hat man 150 Minuten (2 ½ Std.) Zeit zum beantworten. Bei der Prüfung dürfen keine Unterlagen mit hinein, noch mitgenommen werden!
Hier ein paar (mögliche) Fragen:
FRAGE: Wie wird ein Ultimodatum in ein normales Datum Umgewandelt?
FRAGE: Gibt es Tabellen ohne Primary Key?
…to be continued…
Mikka
Zuletzt geändert von mikka am 20. Oktober 2005 08:28, insgesamt 2-mal geändert.
19. Oktober 2005 20:00
Ich weiß nicht, ob es so sinnvoll ist, die Antworten zu den (möglichen) Fragen hier in das Forum zu stellen, da manche sonst dazu tendieren, die Antworten auswendig zu lernen anstatt Navision zu lernen.
Ich schlage vor, dass wir hier lieber in derselben Art vorgehen sollten, wie es bei mibuso.com gehandhabt wird:
Sollte jemand eine konkrete Frage bei der Interpretation einer Frage haben, so darf er diese hier stellen und wir antworten / diskutieren darüber.
Wir wollen hier doch keinen "Schummel-Thread" erstellen, oder?
Ich schlage vor, dass wir hier lieber in derselben Art vorgehen sollten, wie es bei mibuso.com gehandhabt wird:
Sollte jemand eine konkrete Frage bei der Interpretation einer Frage haben, so darf er diese hier stellen und wir antworten / diskutieren darüber.
Wir wollen hier doch keinen "Schummel-Thread" erstellen, oder?
20. Oktober 2005 08:26
Hallo Timo,
da gebe ich dir Recht, man gut das ich nur zwei einfache Fragen veröffentlicht habe.
Ich hatte bisher mir bei mibuso.com die Fragen nur Oberflächlich angeschaut, daher dachte ich, das wir das ganze im Deutschen auch machen sollten!
Ich bin eh der Meinung, dass ohne ausreichende Vorbereitung die Prüfung nicht zu schaffen ist (Auch wenn ich die Prüfung noch nicht abgelegt habe!)
Ich schlage vor, das wir so verfahren, wie Timo es vorgeschlagen hat.
Falls einer von Euch sonst zu irgendeinen Befehl oder Syntax hat Fragen hat, können wir diesen evtl. ja auch hier Diskutieren!
Gruß Mikka
da gebe ich dir Recht, man gut das ich nur zwei einfache Fragen veröffentlicht habe.
Ich hatte bisher mir bei mibuso.com die Fragen nur Oberflächlich angeschaut, daher dachte ich, das wir das ganze im Deutschen auch machen sollten!
Ich bin eh der Meinung, dass ohne ausreichende Vorbereitung die Prüfung nicht zu schaffen ist (Auch wenn ich die Prüfung noch nicht abgelegt habe!)
Ich schlage vor, das wir so verfahren, wie Timo es vorgeschlagen hat.
Falls einer von Euch sonst zu irgendeinen Befehl oder Syntax hat Fragen hat, können wir diesen evtl. ja auch hier Diskutieren!
Gruß Mikka
23. Januar 2006 10:33
Hallo zusammen, hab mir mal die mühe gemacht ein paar Fragen zusammen zustellen.
PS: Anworten hab ich noch nicht alle angeschaut... angaben ohne gewähr ;)
Schummelthread solls keiner werden.. Quelle mibuso.com
1) Which of the following properties u can change during runtime ?
a) Visible <=
b) Vertglue
c) SourceExpr
2) You are make a data conversion from legacy system to new one using Dataport but something occur thier is description filed contain 80 char and the new description filed can take 50 char only. You told our customer about this he told u its fine with first 50 char know what is true way to do this data conversion?
a) Change the new description filed properties to take 80 char
b) Write code in the table trigger to reed the first 50 char
c) Dataport will handle this situations u don’t need to do any thing
d) You need to write code in data port to handle these situations
e) Put the data in variable and then write code to read the first 50 char <=
3. If you create file and write to it the number '1000' what is the size if u know that the textmode method is (textmode(true) )
a) 2 byte
b) 4 byte
c) 6 byte <=
d) 8 byte
4. If you create file and write to it the number '1000' what is the size if u know that the textmode method is (textmode(false) )
a) 2 byte
b) 4 byte <=
c) 6 byte
d) 8 byte
5. Your customer COMPLAIN about report u create he said "the report goes write and every thing is correct but the report very slow" what u have to change to fix this problem??
a) Dataitems
b) Filters
c) Keys <=
d) DataItemTableView
6. One question was about Process and Transaction in Navision
a) One or more transaction in one Process
b) Zero or more transaction in one Process <=
c) One or more Process in one transaction
d) Zero or more Process in one transaction
e) Transaction and Process doesn’t work together...
7. What is the three primary thing mentions in every report (chose three of six)
a) Company Name <=
b) Page number <=
c) Date and time
d) User name <=
e) Time of work
8. Xfile.EoF how can u represent it in another way
a) Xfile.pos
b) Xfile.read
c) Xfile.len
d) File.read(file.pos)= file.len <=
e) File.read= file.len
9. When displaying subordinate records in a subform what control do you use?
a) You must use a Tablebox <=
b) You usually use a Tablebox
c) A picture box
d) A text box
10. Form A calls on instance of a Codeunit and assigns 'RED' to a global text variable. Form B call an instance of the same Codeunit and assigns the same global variable 'BLUE'. Forma A then calls another function in the same Codeunit and retrieves the value of the global variable. What is the value?
a) Red <=
b) Blue <=
c) Null
d) You can't do this
11. What function should you call in a report onaftergetRecord trigger that will still print the record your currently on.
a) CurrReport.SKIP
b) CurrReport.BREAK
c) Exit <=
d) CurrReport.QUIT
12. User entering a general journal what are the dimension data flows. (2 Questions on this)
T Default Dimension
U Journal Dimension
V Dimension Ledger
X Production Order Dimension
Y Document Dimension
Z Posted Document Dimension
a) T to U <=
b) U to V <=
c) T to Z
d) X to Z
13. Report 2 dataitems “Cust. Ledger Entry” and “Customer”. “Cust. Ledger Entry” is linked and indented. What function do you use to break out of the current record?
a) CurrReport.CLOSE
b) CurrReport.QUIT
c) CurrReport.BREAK
d) CurrReport.SKIP <=
14. When displaying subordinate records in a subform what control do you use.
a) You must use a Tablebox
b) You usually use a Tablebox <=
c) A picture box
d) A text box
15. What function should you call in a report onaftergetRecord trigger that will still print the record your currently on.
a) CurrReport.SKIP
b) CurrReport.BREAK
c) Exit <=
d) CurrReport.QUIT
16. Which type of table has most buss rules?
a) Ledger Table
b) Journal Table <=
c)…
17. A KEY can have at most, how many SumIndexFields?
a) 20 <=
b)…
18. What is the fundamental business rule concerning posting for all functional areas?
a) Take Journal recordsand put them into Ledger Table <=
b)…
19. Two options to open a new card from a list form.
a) F11 & Navigate menu
b) Shift F5 & Navigate Menu <=
c) F11 &??
d) Shift F5 &??
20. Which is not valid code?
a) EXIT;
b) EXIT(Amount);
c) EXIT
d)… <=
21. Choose Repeat ... Until loop instance of a While... Do loop when you
a) Want to bypass test given a set of conditional
b) Want to time the loop
c) Want to see how many conditions are mentioned in your test
d) Want to loop to process at least one <=
22. Which of the following commands would be best to use C/AL return the user ID?
a) UID
b) System.UID
c) USERID <=
d)…
23. Which is not considered a document report?
a) Sales invoice
b) Customer Statement
c) Inventory Order details <=
d) Purchase Order
24. Which command would you place on PreSection trigger prevent the section from printing?
a) CurrReport.ShowOutpu(True)
b) CurrReport.ShowOutpu(False) <=
c)…
25. A list report is report that contains a single Dataitem that is the table being listed. which of the following would be a TRUE statement
a) Only PK (field and description and field can be included in ...
b) Each column on the report containing a field from the table on the data is printed from that
table, not brought in or calculated other table <=
c) the report limited to only 65500 lines
d) Each Field other then the PK, must be activated using the CALCFIELD equivalent to?
26. Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField <=
27. In the Dataport field designer the list of source expressions should be what order?
a) Same order as the information in the file <=
b) Same order as the fields in the table
c) Alphabetical order
d) Ordered by data type.
28) Which describes Codeunit?
a) container for all c/al code
b) Container for c/al code <=
c) Measurement of C/AL
d) The editor c/al
29. Witch of the followings is not characteristic of a menu suite?
a) It consist of a set of menu
b) A menu item is the highest level in the tree <=
c) A menu node can be either a menugroup or menusuite
d) A menu group contain a collection of menu nodes
30. Which of the following is not true regarding menus or menusuite?
a) A menu contains content for a specific departmental area <=
b) Menus consist of items, groups and objectives <=
c)…
31. Which is the sales & receivables master table?
a) Salesperson
b) Customer <=
c)…
32. If you want a variable that has been passed to be changed while in the function you can ...
a) Pass it by reference <=
b) Pass it by...
c)…
33. What type of data have whole number and max 100000?
a) Int
b) Decimal
c) Option <=
d) Code
34. Which is unary operator?
a) + <= (You can write VAR := +VALUE)
b) /
c)…
35. Which is not converted automatically?
a) Blob to binary <=
b) Int to dec
c)…
36. Form A calls on SINGLE instance of a Codeunit and assigns 'RED' to a global text variable. Form B call an instance of the same Codeunit and assigns the same global variable 'BLUE'. Forma A then calls another function in the same Codeunit and retrieves the value of the global variable. What is the value?
a) Red * (chose a) <=
b) Blue (or B) <=
c) Null
d) You can't do this
37. How many Indents can a report have?
a) 1
b) 10 <=
c) 100
d) Unlimited
38. What is the use of setting permission in the report?
a) Prevent user from using the report
b) Use this property to give a database object extra permission to perform some operations on
one or more tables <=
c)...
39. IF Name <> xRec.Name THEN
ERROR('Bat flies');
Substitute the error message:
a) Name is not present in record
b) Don't changed <=
c) Don't delete
d)...
40. 2 dataitem: one (dataitem2) is below of the other (dataitem1) and indented. if in AfterGetRecord of the dataitem2 I call CurrentReport.Skip, what is the next record?
a) Execute next record (dataitem2) <=
b) Execute next record (dataitem1)
c) Nothing, report stop
d)...
41. How many dataitem at the maximum can we indent in a report?
a) 10 <=
b) 20
c) 100
d) Unlimited
42. Something with NODBC and Multilanguage
a) N/ODBC support Multilanguage <=
b)…
43. 2 dataitem: one (dataitem2) is below of the other (dataitem1) and indented. If in AfterGetRecord of the dataitem2 I call CurrentReport.break, what is the next record?
a) Execute next record (dataitem2)
b) Execute next record (dataitem1) <=
c) Nothing, report stop
d)...
44.
Customer.FIND('+');
Customer.NEXT('-3');
Customer.FIND('=');
In table the following records are present: 1000, 2000, 3000, 4000, 5000, 6000.The result of previous instructions is:
a) 2000
b) 3000 <=
c) 4000
d) 5000
e) 6000
45.
Customer.FIND('+');
Customer.NEXT('3');
Customer.FIND('=');
In table the following records are present: 1000, 2000, 3000, 4000, 5000, 6000.The result of previous instructions is:
a) 2000
b) 3000
c) 4000
d) 5000
e) 6000 <=
46. What is the property used for Multilanguage support?
a) Caption
b) CaptionML <=
c)...
47. What of the following is it a File function?
a) WRITELINE
b) EXIST <=
c) BINARYMODE
48. What of the following is it a File method?
a) WRITELINE
b) BINARYMODE
c) CREATE <=
d)...
49. In a report what is trigger that fire before?
a) OnInitReport <=
b) OnPreReport
c) OnPreDataItem
d) OnPostDataItem
50. In a report with request form what is trigger that fire before?
a) OnPreReport
b) OnOpenForm <=
c)...
51. Your customer has bought your product, but your salesperson has talked with
him and has said that the latest version of navision has the improvements that
are present in add-ons that you will install.
What do you do?
a) Install latest version of navision;
b) Install latest version of navision, along with improvements present in your add-on <=
c)...
52. A subform
a) Have always a table box
b) Have usually a table box <=
c)...
53. If I have a code in the OnLookup table trigger that filters in a record set, how
can I delete this filter in a form?
a) You can't
b) Write code in OnLookup form trigger <=
c)...
54. For SumIndexFields what do you use?
a) CALCFIELD
b) CALCSUM <=
c)...
55. In legacy system we have a field of 80 characters. You must import from legacy
system to Navision but the new field is 50 characters. What do you do, if the
customer has said that it is ok if you import from 80 character fields to 50
character fields.
a) Write code in DataPort to convert
b) You must do nothing: Navision do it for you during assignment
c) Put the data in variable and then write code to read the first 50 char <=
d)…
56. There is a report. We want to add to this report the possibility for the user to
choose if show a description. To make this we add a check box. What must we
do in the report?
a) Write code in OnPreSection report trigger <=
b)…
57. What is the equivalent of CREATETOTALS function in a report (more or less)?
a) TotalFields <=
b)...
58. ---------------------------------------------
Customer.SETCURRENTKEY("No.");
Customer.SETRANGE("Sales",0);
IF Customer.FIND('-') THEN BEGIN
{code}
END -------------------------------------------
Customer.SETCURRENTKEY("Sales");
Customer.SETRANGE("Sales",0);
IF Customer.FIND('-') THEN BEGIN
{code}
END -------------------------------------------
Customer.SETCURRENTKEY("Sales");
Customer.SETFILTER("Sales",'0');
IF Customer.FIND('-') THEN BEGIN
{code}
END -------------------------------------------
Which is the code faster?
a) The first one
b) The second one <=
c) The third one
d) All three codes go at same way
(Customer.“Sales” is a Calculated Field: you cannot set the key on a calculated field, the instruction Customer.SETCURRENTKEY(“Sales”) is invalid. If SALES is a normal field the second one is the fastest)
59. What it the key to compile an object from object design?
a) F11 (choose) <=
b) There isn't any key
c)...
60. What is the property to select a subform in a form?
a) SubFormID <=
b) SubForm
c)...
61. When you modify a menusuite, what are the changes that remain?
a) It doesn't save them
b) At level of menu level
c) Maintain all changes
d) Only the last
e) Maintain the difference between the level below <=
62. When you create a development database for a customer that has already the
db, what do you do?
a) you make a backup and install them with check..
b) create a backup, create a new DB using client, restore from backup <=
c)...
63. Report with modifications. Which do you modify?
a) the new that is a copy of the original <=
b) the original
c)...
64. How do you launch a Codeunit?
a) CODEUNIT.RUNMODAL(..)
b) CODEUNIT.RUN(..) <=
c)...
65. Report only batch. How do you launch it?
a) Report.run
b) Report.run (record)
c) Report.run (tmpRecord) <=
d)...
66. Import Dataport. From the first record you can extract all data that you need,
following data too (for these you don't care about them). What do you do to skip
all records except the first one?
a) CurrentReport.skip (in onbeforeimportrecord)
b) CurrentReport.skip (in onafterimportrecord)
c) Init (in onbeforeimportrecord)
d) Init (in onafterimportrecord) <=
67. C/AL language programming. What is true?
a) It derives from Microsoft C#
b) All objects have c/al
c) All object except Menusuite <=
d)...
in 4.00 menu suite has not c/al / Depending on what version 3.70 b
68. I declare a variable with VAR.
a) You pass a variable by reference rather than by value <=
b) You pass a variable by value rather than by reference
c) You declare a variant variable
d)...
69. XMLPort. How do you calculate flowfield in automatic?
a) Calcfields
b) FieldCalc
c) AutoCalcField <=
d)...
70. In a report a user wants to set a filter. What do you do?
a) Populate DataItemTableView
b) Delete DataItemTableView <=
c) Populate dataitemlinkreference
d) Delete dataitemlinkreference
71. You have a report and you print for all users the same value. Why? (it talk about
DataItemTableView)
a) You haven't set table filter <=
b)...
72. Import txt file. When does worksheet appear?
a) Never <=
b) Always
c) If two objects (that present and that you imported) are modified
d) If the object has different modifications
73.
IF NextEntryNo = 0 THEN BEGIN
ResLedgEntry.LOCKTABLE;
IF ResLedgEntry.FIND('+') THEN
NextEntryNo := ResLedgEntry."Entry No.";
NextEntryNo := NextEntryNo + 1;
END;
What does this code do (in posting routines)?
a) It is used to have not record with null value
b) To calculate the next entryno <=
c)...
74. What is the following property false?
a) Autoincremental
b) You can modify the table
c)...
Refer to journal. All 2 options are correct
75. You must verify the empty row in the journal when you post. What do you do? the code must be reusable
a) You create a CodeUnit and pass it a record <=
b) You can't, because the table don't accept function
c) You put function in the form
d)...
76.
IF ISCLEAR(WORDAPP)
CREATE (WORDAPP)
WordApp is Automation. What does the code do?
a) Sure I instance a variable
b) If the variable doesn't exist I create it <=
c) Clear the variable
d)...
77. Max number of menu suite in a db?
a) 10
b) 15 <=
c) 20
d) Unlimited
78. In a subform, what can you insert in it?
a) Tab menu
b) Tablebox
c) Picturebox
d) Subform <=
79. What is not true for a blob?
a) You can export only as a bitmap <=
b) You can insert "memowrite"
c) It can contain pictures
d) At maximum 2GB
80. You have a label and you want to change its value at runtime. What do you do?
a) SourceExpr
b) SourceExpr only if exist a text box linked with it
c) Is not possible <=
81. You must import sales order data (they are already verified).
a) And b) two option directly into ledger table
c) Copy in journal table, save and post them
d) Copy in journal table and post them <=
82. Insert a record in sales order. What dimensions are used?
a) Default dimension
b) Journal dimension
c) Ledger
d) Document
e) Document posting
g) Default + journal
h) Journal+ document <=
i) Ledger + document posting
83. You are posting a journal. What are dimensions that are used?
a) Journal <=
b) Ledger
c) Default
84. In a function with a record as parameter, how can you know witch filters have been applied to it ?
a) GetFilters
b) Impossible
c)…
85. Witch kind of files are not present on the client computer
a) stx
b) etx
c) fob
d)…
86. If you set the SourceExpression of a textbox to a BigText variable, what will be the result?
a) Error
b) Text will be truncated
c)…
87. Almost like the #86, If you have varText := varBigText;
a) Error
b) VarText will be truncated
c)…
88. Outstream.Write. What's an invalid target?
a) Blob
b) Ocx
c) Report <=
d) Automation
89. What is the fundamental business rule concerning posting for all functional areas
in navision application?
a) All transactions are posted through the Ledger into the journal
b) All transactions are posted by the user directly into Ledger while the journal is used to track user.
c) All transactions are posted through the journal into the ledger <=
d)…
90. Which of the following characteristics not result of the table relationship?
a) Optimize table records <=
b) Validate entry
c) Perform lookup other tables
d) Automatically propagate changes from one table to other table.
91. Which of the following functional area has more than one Master Table?
a) General Ledger <= (G/L Account, Bank Account)
b) Fixed Assets
c) Inventory
d) Sales & receivables
92. Which data type would be used for a field that has a FieldClass property of
Flowfield and a Calc Formula method of sum?
a) Date
b) Boolean
c) Decimal <=
d) Integer
93. Which are the valid "parts" of a table in Navision?
a) Data and Ledgers
b) Data and Properties <=
c) Data and described
d) Source and description
94. Which is not a flowfield type?
a) Lookup
b) Sum
c) Validate <=
d) Count
95. Which is Cash Managements master table?
a) Customer
b) G/L Account
c) Cash Account
d) Bank Account <=
96. In customer table comment field and CalcFormula property is following
EXIST('CommentLine') WHERE (Table Name=CONST(Customer),No.=FIELD(No.)))
Select the item that represents the data type of a command field
a) Boolean <=
b) Binary
c) Integer
d) Decimal
97. Which is true?
a) A field in the master table is table related to the ledger table
b) A field in the Ledger table is table related to the master table <=
c) Master and ledger each have a field that is the table related to the other.
98. What is the main purpose of a subform?
a) Display information below a form
b) Filter a subset of information on a form
c) Make a form that is reduced in size
d) Display information from another table on a form <=
99. User make journal entries. What type of form used for that in Navision std.
a) List Form
b) Card Form
c) Worksheet form <=
d) Tabular Form
100. What can we do to access list form from a card form?
a) F5, Selecting lookup MenuItem or F11
b) F5, Selecting ListMenu item or selecting the lookup button on toolbar <=
c) F11, Selecting ListMenu item or selecting the lookup button on toolbar
d) F5, Selecting ListMenu item or selecting the find button
101. What is concatenation?
a) Extracting a string from within another string
b) Creating a new string by alternately taking characters from two other string
c) Combining string values by appending the characters of one to end of the other <=
d) Combining string values by adding the numeric value of one to the numeric value of the
other
102. Which is not a report type?
a) Transaction
b) Status <=
c) Document
d) Test
103. A list report that contains 1 dataitem is the table being listed. Which is true?
a) Only the PK field and descriptive field can be included in the report
b) Each column on the report contains a field from the table and the data is printed from that
table not brought in or calculated <=
104. Report with Customer and Cust.Ledger entry as dataitems and Cust.Ledger
entry indented under customer. Which of time following would be easiest way
to filter both tables to the same date range
a) Use SETRANGE OnPreReport <=
b) Add DateFilter to the ReqFilterFields property of the customer dataitem and link the posting
date field of the Cust.Ledger entry dataitem to the Date filter field of the customer table
using the DataItemLink property
c) Add DateFilter to the ReqFilterFields property of the customer dataitem and, use the set
SETFILTER cmd to Filter the posting date field Cust.Led.Entry
d) Use SETFILTER OnPreDataItem
105. The Auto save property on a dataitem in a Dataport tells the dataitem to automatically
a) Replace records that exist in the table during on import
b) Save the file periodically
c) Insert records during on import <=
106. Which is True?
a) Xml ports do not handle xml documents that find and delete data in the db <=
b) Xml ports do can be run from object designer
c) Xml ports will produce proper output
107. Which field in the XMLPort description would be used to identify which table a
TagName is equivalent to:
a) Table Name
b) TagType
c) TagName
d) Source type <=
108. In a function, when a parameter is specified as Var it means...
a) The parameter is passed as a variant
b) The parameter is passed by value rather than reference
c) The parameter is passed by reference rather than value <=
109. How can an element of object be addressed in Code?
a) Using Instance of class definition
b) Using normal syntax of structure language
c) Using dot operator <=
d) Using pointer reference
110. What file is not found (has relation with Multilanguage) in client folder?
a) *.ETX
b) *.STX
c) *.CHM <= (Help is only Multilanguage)
d) *.FDB
111. What Internal document if we add field in table?
a) Documentation trigger
b) Project Log <= (The question is about a document not a trigger)
c) Field Description
d) Code Command
112. You need to open form to get information from input of the user.What code?
a) FORM.RUN(FormID)
b) Create variable type form and code: VAR.RUN
c) Create variable type form and code: VAR.RUNMODAL
d) FORM.RUNMODAL(FormID) <=
113. What is the not valid target of WRITELINE?
a) BLOB
b) File
c) Report <=
d) Automation
114. Witch posting routine read the journal table?
a) Post Batch
b) Post Line
c) Check Line <=
115. Witch posting routine writes in to ledger table?
a) Post Batch
b) Post Line <=
c) Check Line
116. Look the following code:
Find(‘-‘)
Do
Delete();
While next <> 0
Find(‘-‘)
Do
Ok:=Delete();
While next <> 0
DeleteAll();
What’s the difference?
a) 1 is faster
b) 2 is faster
c) 3 is faster <=
d) All are the same
117. In a report with 1 DataItem. Witch trigger is not executed if the dataset is
empty?
a) OnAfterGetRecord <=
b) OnPostDataItem
c)…
118. In a function with a record as parameter. Can we know witch filters have been
applies?
a) NO
b) Yes, the records contain all the information about the filter applied <=
c) Yes, the filters applied to a record are stored in a system variable
119. What is a typical instruction in a check line routine?
a) Validate()
b) Modify()
c) TESTFIELD <=
d)…
120. Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
a) 1 <=
b) 20
c) 40
d) 100
121. In a DataPort you have to test the data before to import them. Where do you want to place your code?
a) OnBeforeImport
b) OnAfterGetRecord
c) OnAfterImportRecord
d) OnBeforeEvaluate <=
122. Look the following code:
VarRecord.field1 := ‘xyz’;
VarRecord.modify();
When the change is submitted ?
a) a submit is implicitly called after the modify
b) when leaving the trigger
c) modify submit the transaction <=
d)…
123. How to implement optimistic concurrency (I don’t remember the server type) ?
a) Set a maximum of filters. The server will lock the table (implicit) during the update <=
b) Set a maximum of filters and explicitly call the LOCKTABLE
c)…
124. If a customer wants to be able to change the sorting order of a report without
the intervention of a Navision developer, what do you do?
a) Fill the ReqFilterHeading
b) Leave the ReqFilterHeading blank
c) Fill the property
d) Leave the property blank?
e) ReqFilterFields
f) Leave DataItemTableView blank <=
125. In a form create with the form wizard. Witch code is automatically generated?
a) Validate(“No.”) in OnAfterGetRecord <=
b) SETRANGE(“No.”) in OnAfterGetRecord
c) FORM.Save() in OnDeleteRecord()
d) In OnNewRecord
126. In a report, witch instruction do the same task as putting a field name in the
totalField property ?
a) CreateTotal <=
b) FlowFiels
c) Sum
d)…
127.
Sec A:
Cust.Setcurrentkey('No.');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec B:
Cust.Setcurrentkey('SalesPerson');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec C:
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
a) Sec A is faster
b) Sec B is faster <=
c) Sec C is faster
d) All took same time
128. A client make a mailing with Microsoft word combinated with MBS, We use for
this.
a) ODBC
b) C/ODBC
c) C/Front
d) Automation Microsoft Word <=
129. How many Indents can a report have.
a) 1
b) 10 <=
c) 100
d) Unlimited
130. You are making a data conversion from legacy system to new one
Using DataPort but something occur thier is description filed contain 80 char
and the new description filed can take 50 char only.
You told our customer about this he told u its fine with first 50 char
Know what is true way to do this data conversion?
a) Change the new description filed properties to take 80 char
b) Write code in the table triggers to reed the first 50 char
c) DataPort will handle this situations u don’t need to do any thing
d) You need to write code in data port to handle this situation <=
e) Put the data in variable and then write code to read the first 50 char <=
131. Look the following code:
VarRecord.field1 := ‘xyz’;
VarRecord.modify();
When the change is submitted ?
a) A submit is implicitly called after the modify <=
b) When leaving the trigger
c) Modify submit the transaction
132. How to implement optimistic concurrency (I don’t remember the server type)?
a) Set a maximum of filters. The server will lock the table (implicit) during the update
b) Set a maximum of filters and explicitly call the LOCKTABLE <=
c) Lock table when you read and you are sure that after you will do an update
d)…
132)b i think so because we must lock EXPLICITLY the table with statement LOCKTABLE(TRUE,TRUE). so A is not correct, and also C is not correct because we don't lock a table when we read...but only just before we make an update.
133. Which of the following form control would you use to display subsidiary
information on the form?
a) Subform <=
b) Textbox
c) Tablebox
d) Matrixbox
134. How menusuite object changes are stored
a) Each change is stored as a complete list of menusuite menus and items and replaces the
previous level
b) Changes are stored as the difference between previous menusuite level and the
current one <=
c) Menusuite changes are not stored
135. Which of the following is not true regarding the methods and properties of an
Automation server controlled from C/SIDE?
a) When the Automation variable is properly declared, you can view the methods and
properties using the C/AL symbol menu <=
b) Certain methods and properties will not be able to utilized in navision if there is no
corresponding data type within navision
c) Knowledge of the relationship between COM data typesand navision data types is required
d) Com data type can be converted to Navision data types using alterdatatype in order for an
outside application.
136. The main limitation of DataPort as a tool to integrate Navision with an outside
application is that requires the outside application to:
a) Initiate all data transfers from itself to Navision by running the DataPort
b) Be certified as Navision compliant
c) Place its data into an ASCII file before the navision DataPort can read <=
d) Know internal data structure of the navision tables to be updated by the DataPort
137. Which of the following is Not true regarding XML TagName field
a) Attributes are entered prior to the elements they define <=
b) TagNames must be entered in order
c) Parent elements must precede their child elements
d) Child elements are indented
138. Which of the following XML port TagName properties selects the field to be
mapped to Xml data
a) Source field
b) ReqFilterField
c) Xml Field
d) Field name
139. Which field in the Xml port description would be used to identify which table a
tagname is equivalent to?
a) Table name
b) Tag Type
c) Tag Name
d) Source Type <=
140. You are importing data from outside source into Navision using DataPort the
data is in variable format and each field is separated by ampersand. Which of
the actions should you perform to be able to import data using DataPort?
a) Change field separator to ampersand
b) Change field delimiter to ampersand
c) …
141. Which of the following dataitem properties would be used to specify which field
or fields a Navision Report should Group By.
a) GroupTotalFields
b) Total fields <=
c) GroupByFields
d) Req. file
142. You have set the left margin = 1000 , before printing report the user specifies
15mm left margin in the page setup window. When print the report
LeftMargin=?
a) 15mm
b) 10mm
c) 25mm
d) 5mm
143. Which of the following is true regarding the Request Options from Designer?
a) Request options form does not exist
b) To design options tab of options
c) To design all of the tabs of the request form design
144. Which of the following is Not a Valid report component?
a) Control
b) Table form <=
c)…
145. You are designing a report that is going to be run while other users are
inserting records into the
same transaction tables, using version based Navision server what do you need
to do t the report to
make sure that the data reported will be a consistent snapshot of the data
those transactions
a) You don't need to anything <=
b) You will need to set the transaction type property to SnapShot
c) You will need to set the transaction type property to Browse
d) There is nothing you can do. User will just have to tell all the others
146. Which of the following is true regarding to Automation Sever?
a) C/Side can receive events from components with the Automation events=yes
b) C/Side cannot receive events from outside components
c) C/Side can only receive Com+ components
d) C/Side can receive events from components with the WithEvents=yes
147. Cust. Ledger entry indented under Customer, which of the following would be
easiest way to filter both tables to the same date.
a) Add DateFilter to the Req. Filter Fields property of the customer dataitem and link the
posting date field of the custLedgerEntry data item to the data filter field of the customer
table using the DataItemLink property
b) Add DateFilter to ReqFilterField property of the customer dataitem and use the SetFilter
command to filter the posting DateField of the Cust. Ledger Entry table.
c) Use SetFilter
d) Use SetRange
148. Which command would you place OnPreSection trigger prevent the section
from printing?
a) CurrReport.Showoutput(True)
b) CurrReport.Section(True)
c) OnReportPrint(true)
d) ShowReport
e) CurrReport.Showoutput(False) <=
149. Which is not true?
a) Local CodeUnits can only be run from other CodeUnits <=
b) CodeUnits can be run from other CodeUnits
c) CodeUnits can be run from other objects <=
d) Other object can be run from CodeUnits
150. Local variables are limited in scope to the function which they are defined
a) Local variables can only be defined in CodeUnits
b) Local variables are reinitialized other execution of a Codeunit has completed <=
c) Local variables can only be declared in local functions
151. In order for an outside application to access data within Navision Server using
C/ODBC what must it support?
a) Microsoft Query <=
b) ODBC
c) Sql Server
d) Navision Server
152. We have 2 dataitem one is master (I can't remember I think customer
and ship ...), and 10 customers have two ShipToAddress. When the report
printed how much footer for ship to addresses?
Ans:???
153. When can change the fieldname in the table?
Ans: I think it should be anytime.
154. How many level of menusuite?
Ans: 20
155. How to run a menusuite?
Ans: You can’t
156. What properties need not be defined for menu item?
Ans: Name
157. List the trigger process order of Dataport.
Ans: OnInit, OnPreDataPort, OnPreDataItem, OnBefore/AfterExportRecord,
OnPostDataPort
158. How to call a code unit in another object?
Ans: CODEUNIT.RUN
159. Which is NOT a Form Trigger?
Ans: OnDisposeForm
160. If a field in a table’s editable property set to “No”. Which of the following
statement is true?
a) User cannot change the value in the form but can change the value by C/AL code <=
b) User cannot change the value in the form or by C/AL code.
c)…
161. How to describe the relationship between Master table and Ledger table?
a) Ledger table is table-related to master table………. <=
b) Master table is table-related to ledger table……….
c)…
162. Complex data type. More functions in it does they slow down?
Ans: ???
163. A question about: KEYGROUPS of report if customer have report only run at end
of year
164. How to handle LockTable for small customer who uses Navision Database
Server
Ans: ???
//Answers
#26 The automatic calculation of SumIndexFields - acording to the courseware:
CalcFields: Automaticaly calculates the information for flowfields entered here
AutoCalcFields: Used to determine whether or not the value in the flowfield should be recalulated before the field is exported
#30 B)should say OBJECTS not OBJECTIVES - then the correct answer would be A) Departmental areas
#36 I beleive that the correct answer is C) Null as it is not a 'single instance' so the variable is initialized for each instance so it would be 'Null'
#50 I beleive the correct answer is OnInitReport - this is ALWAYS first - doesn't matter if a request form is uesed or not.
#80 Changing a label - this can be done with the 'Caption' property
#83 Posting a Journal - both Journal and Ledger are used
#85 & #110 - The *.FDB (which is the database) are generaly not on the client unless it is a single user installation
#86 & #87 are both A)Error - I tried it and both will not allow it to be done
#91 Fixed Asstes also has 2 Masters Asset and Insurance
#109 - I am not sure of this one but normally ELEMENT is part of an Array or an XML data - both of these would be used with the pointer or index but if they mean property or field of an object then it is the dot
#111 - I could find no information on the Project Log - where do I find this info?
#114 reading Journal records - again acording to the courseware:
CheckLine - Never reads or writes the Journal Table
Post Line - Never reads or writes Journal table - can read other tables for validation - writes Ledger entry
#119 - In my attempt - I had this but TESTFIELD was not an option, however EMPTYLINE() was an option - I thought that was the correct answer but since you didn't ahve it ... Maybe it is the Validate()
#121 You cannot test data before it is imported but it can betested before processed - I think the answer is OnAfterImport because the courseware states that "Most processing and validation is done in the OnAfterImport trigger"
**Optimistic Concurrency - I am not so optismistic!! The references to this in any of the training or reference material - even in the Installation and Configuration manuals is sketchy at best and does not answer these questions ***
#138 & 139 The property that shows the Field or Table is DataSource that is part of SourceType - in SourceType you choose Text,Field or Table
#148 - just remember that another way towrite this is SHOWOUTPUT(0=1)
#151 - I don't think you must have Ms Query as you can use NODBC in C# or VB as the interface without MSQuery - I don't know this one
200) Client wants to have a mailmerge with Navision and Word - they want to be able to add or change fields without help of Navision Developer. What is the best way?
a) Navision to word
b) Word to Navision
C) Navision to world
165. Which one is faster?
a) Find(‘-‘)
b) Do
c) Modify();
d) While next <> 0
166.
a)Find(‘-‘)
b) Do
c) Ok:=Modify();
d) While next <> 0
167. Which of the following is NOT true of updating data in Navision using NODBC ?
a) A Microsoft RAISEERROR will be generated
b) Data Entered through NODBC will not be validated <--choose
c) Data will be checked for conformance to Navision data types
d) Additional fields normally populated in the onValidate trigger
168. Exit(True)
a) Return Boolean value
b) Will not accept a parameter True
c) Only executes if it returns a vale <--choose
d) classes down the Navision client
169. Which case to run a report in modal fashion, while within a transaction?
a) If request form is show modal before the report
b) If report populate all need information on request form before display
c) If request form is not shown <=
d) Report already run once and request form was properly fill in
170. NA Server, customer want to sent customer welcome letter, mail merge. What
should be used?
a) Mail merge using CODBC
b) Automation from MS word to Navision
c) Automation from Navision to MS word <=?
d) Mail merge ODBC
171. Create a card form by form wizard, what code is added automatically?
a) onAfterGetRecord(), setRange("No");
b) onNextRecord()...
c) onDeleteRecord()...
d) onAfterGetRecord(), validate("No"); <=
172.Import AR balance, time is limited, so need to do it quick, how to do it
a) Import into Gen. Journal line, save it, open the journal form, post it
b) Import into Gen. Journal line, without saving, call Code Unit to post it <=
Note: I am not sure for (b). Is this possible for not saving a Gen. Journal line and post it?
173. About the speed of 3 sample code.
a) SetRange <=
b) SetFilter
174. User entering a general journal what are the dimension data flows.
T Default Dimension
U Journal Dimension
V Dimension Ledger
X Production Order Dimension
Y Document Dimension
Z Posted Document Dimension
a) T to U
b) U to V
c) T to Z
d) X to Z
175. Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields <=
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField
176. In a report with request form what is trigger that fire before?
is it oninitreport?
177. Report only batch. How do you launch it?
a) Report.run
b) Report.run (record)
c) Report.run (tmpRecord)
178. Import Dataport. From the first record you can extract all data that you need,
following data too (for these you don't care about them). What do you do to
skip all records except the first one?
a) CurrentReport.skip (in onbeforeimportrecord)
b) CurrentReport.skip (in onafterimportrecord)
c) Init (in onbeforeimportrecord)
d) Init (in onafterimportrecord)
179. Have a report and you print for all users the same value. Why?
180. Import txt file. When does worksheet appear?
a) Never
b) Always
c) If two objects (that present and that you imported) are modified
d) If the object has different modifications
181. You must verify the empty row in the journal when you post. What do you do?
the code must be reusable
a) You create a CodeUnit and pass it a record
b) You can't, because the table don't accept function
c) You put function in the form
182. You have a label and you want to change its value at runtime. What do you do?
183. Insert a record in sales order. What dimensions are used?
a) Default dimension
b) Journal dimension
c) Ledger
d) Document
e) Document posting
g) Default + journal
h) Journal+ document
i) Ledger + document posting
184. You are posting a journal. What are dimensions that are used?
a) Journal
b) Ledger
c) Default
185. Report with Customer and Cust.Ledger entry as dataitems and Cust.Ledger
entry indented under customer. Which of the following would be easiest way to
filter both tables to the same date range
a) Use SETRANGE OnPreReport
b) Add DateFilter to the ReqFilterFields property of the customer dataitem and link the posting
date field of the Cust.Ledger entry dataitem to the Date filter field of the customer table
using the DataItemLink property <=
c) Add DateFilter to the ReqFilterFields property of the customer dataitem and, use the set
SETFILTER cmd to Filter the posting date field Cust.Led.Entry
d) Use SETFILTER OnPreDataItem
186. What is a typical instruction in a check line routine?
187. Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
a) 1
b) 20 <=
c) 40
d) 100
189. In a DataPort you have to test the data before to import them. Where do you
want to place your code?
a) OnBeforeImport
b) OnAfterGetRecord
c) OnAfterImportRecord <=
d) OnBeforeEvaluate
190. Which of the following is not true regarding the methods and properties of an
Automation server controlled from C/SIDE?
a) When the Automation variable is properly declared, you can view the methods and
properties using the C/AL symbol menu
b) Certain methods and properties will not be able to utilized in navision if there is no
corresponding data type within navision
c) Knowledge of the relationship between COM data types and navision data types is required
d) Com data type can be converted to Navision data types using alterdatatype in order for an
outside application. <=
191. Which of the following XML port TagName properties selects the field to be mapped to Xml data
a) Source field <=
b) ReqFilterField
c) Xml Field
d) Field name
192. What is not true for a blob?
a) you can export only as a bitmap <=
b) you can insert "memowrite"
c) it can contain pictures
d) at maximum 2GB
193. Look the following code:
VarRecord.field1 := ‘xyz’;
VarRecord.modify();
When the change is submitted ?
a) a submit is implicitly called after the modify
b) when leaving the trigger
c) modify submit the transaction
194. How to implement optimistic concurrency
a) Set a maximum of filters. The server will lock the table (implicit) during the update
c) Set a maximum of filters and explicitly call the LOCKTABLE
195. In a function with a record as parameter. Can we know witch filters have been
applies?
a) NO
b) Yes, the records contain all the information about the filter applied
c) Yes, the filters applied to a record are stored in a system variable
196. Which is Not true?
a) Local Codeuınits can only be run from other codeunits <=
b) codeunits can be run from other codeunits
c) codeunits can be run from other objects
d) other object can be run from codeunits
197. local variables are limited in scope to the function which they are defined_
a) local variable can only be defined in codeunits
b) local variables are reinitialized other execution of a codeunit has completed
c) local variables can only be declared in local functions <=
198. Which of the following is NOT true of updating data in Navision using NODBC ?
a) A Microsoft RAISEERROR will be generated
b) Data Entered through NODBC will not be validated
c) Data will be checked for conformance to Navision data types
d) Additional fields normally populated in the onValidate trigger
199. You have set the left margin = 1000 , before printing report the user specifies
15mm left margin in the page setup window. when print
the report leftmargin=?
a) 15mm
b) 10mm
c) 25mm
d) 5mm
200. What cannot be in subform?
need option here too...but i think you can put a subform in a subform
201. A listreport is report that contains a single Dataitem that is the table being
listed. which of the following would be a TRUE statement
a) Only PK (field and description and field can be included in ...
b) Each column on the report containing a field from the table on the data is printed from that
table, not brought in or calculated other table.. <=
c) the report limited to only 65500 lines
d) Each Field other then the PK, must be activated using the CALCFIELD equvilent to?
202. IF Name <> xRec.Name THEN
ERROR('Bat flies');
substitute the error message:
a) Name is not present in record
b) Don't changed (choose) <=
c) Don't delete
d) ...
203. 2 dataitem: one(dataitem2) is below of the other(dataitem1) and indented. if in
AfterGetRecord of the dataitem2 I call CurrentReport.Skip, what is
the next record?
a) execute next record (dataitem2) (choose) <=
b) execute next record (dataitem1)
c) nothing, report stop
d)...
203. Something with NODBC and multilanguage that I don't remember..
it talks if NODBC supports the mulitilanguage answer is yes
204. 2 dataitem: one(dataitem2) is below of the other(dataitem1) and indented. if in
AfterGetRecord of the
dataitem2 I call CurrentReport.break, what is the next record?
a) execute next record (dataitem2)
b) execute next record (dataitem1) (choose) <=
c) nothing, report stop
d) ...
205. What is the following property false?
a) Autoincremental
b) you can modify the table
c) ..
d) ..
Refer to journal. All 2 options are correct
207. Rigth method to delete a large block of code :
{PRGLPD01 Start deletion
Code to delete…
…
PRGLPD01 End deletion}
208. Why using SETPERMISSIONFILTER ?
209. What is the fundemental bussines rule concerning posting for all functional
areas in navision
application?
a) All transactions are posted throught the Ledger into the journal
b) All transactions are posted by the user directlyinto Ledger while the journal is used to track
user.
c) All transactions are posted throught the journal into the ledger <=
d) ??
210. Xmlport, how to calc flowfiel automatically:
a) calcfield
b) do flow
c) flowcalc
d) calcflow
211. How you can run modally a only batch report while middle a transaction:
a) request form not exist <=
b) request form in run modally
c) report has already data
d) report has already been run once
212. You want to create a mail-merge with MS word. what do you do?
a) use automation from navision to word
b) use automation from word to navision
c) use odbc
d) use c/odbc
214. What you use for exit from ONAFTERGETRECORD in a report for NOT skipp
actually record and the other
a) skip
b) break
c) quit
d) exit <=
215. An a table containt values 1000,2000,3000,4000,5000,6000. Look the following
code. (2 Qs).
FIND('+');
NEXT(-3);
FIND('=');
Position of record?
a) 1000.
b) 2000.
c) 3000.
d) 5000.
e) 6000.
216. Report have 2 Items: Customer and Cust. Ledger Entry which is indented.
There Code On
OnAfterGetRecord of "Cust. Ledger Entry" : CurrReport.Skip. Which one
Is TRUE?:
a) Current Repot -> stop.
b) Customer -> skip.
c) Cust. Ledger Entry -> skip, Customer -> next record.
d) Customer -> skip, Cust. Ledger Entry -> next record.
217. Element (xml?), how to implement it to object.
a) instantiate.
b) language structure.
c) dot operator.
d) ???
218. If you want to run a report modally within process of a form, what have you
do?
a) variablereport.RUNMODAL.
b) variablereport.RUN.
c) Set ReqFilterFields value.
d) Create Request form.
219. If you want to run a form and the user information will be used to setup more
than one table, what will you do:
a) variableform.RUNMODAL.
b) variableform.RUN.
c) FORM.RUN(FORM::Form_Name,rec).
d) FORM.RUNMODAL(FORM::Form_Name,rec).
220. The master table for Financial Area is
a) Currency
b) Bank Account
c) Customer
d) General Journal
e) G/L Entry
221. Which of the Functional area has more then one master table?
222. On a report changing DUE date to Bold if within 3 days of due date.
Is this possible? How.
223. Report - Grouping with Posting Date & Customer No. Even if one Customer filtered..still prints header for posting date and then Customer header. How to stop if only 1 customer selected.
223. Proper procedure to update a Balance field on the Customer card (Balance field is new stored field - not a flowfield). Video rental made and they want customer card update (using standard methodology)
224. When should you remove a modify flag?
225. After a locktable, how can we unlock ?
commit, unlocktable,…..
226. In a function receiving a record as parameter, how is it possible to know witch filters was applied to it before?
impossible, or 3 other answers
227. How many dataitems can we have in a report?
5,10,500,unlimited ?
228. During an import, when does the import worksheet appear?
every time, only if there are some difference between the imported and existing object,…..
229. In a ‘process only’ report, what trigger doesn’t fire?
230 A customer has a report that needs a lot of complex key. The customer will use this report once a year. What the best way to manage the key (without consultant‘s intervention)
231. Which of the following C/AL looping statements always executes at least one time?
I. REPEAT ... UNTIL
II. FOR ... TO/DOWNTO ... DO
III. WHILE … DO
a) I only <=
b) II only
c) III only
d) I and II
e) I and III
f) II and III
232. Before executing any statements inside the loop, which of the following C/AL looping statements evaluates the looping condition first?
I. FOR ... TO/DOWNTO ... DO
II. REPEAT … UNTIL
III. WHILE … DO
a) I only
b) II only
c) III only
d) I and II
e) I and III <=
f) II and III
233. Which C/AL code is a valid comment ?
a) /* comment */
b) { comment
c) // comment <=
d) \\\ comment
e) None of the above
234. What is the result of the C/AL expression: 21 MOD 3
a) 7
b) 21
c) 1
d) None of the above <=
235. What is the result of the C/AL expression: 4 + 6 * 3 / 2
a) 10
b) 13 <=
c) 15
d) 11
1. On a report changing DUE date to Bold if within 3 days of due date.
Is this possible? How.
2. Report - Grouping with Posting Date & Customer No. Even if one Customer filtered..still prints header for posting date and then Customer header. How to stop if only 1 customer selected.
3. Proper procedure to update a Balance field on the Customer card (Balance field is new stored field - not a flowfield). Video rental made and they want customer card update (using standard methodology)
4. When should you remove a modify flag?
Exam Topics
C/AL Programming – 17%
Defining tables
Table and field properties
Creating tables
Defining keys
Setting relationships between tables
Special table fields
Table types and characteristics
Defining C/AL
Accessing C/AL
Simple datatypes
Identifiers and variables
Assignment statements
Expressions
Numeric expressions
Logical and related expressions
IF and EXIT statements
Compound statements and comments
Arrays
Repetitive statements
Other statements
Calling built-in functions
Using intrinsic C/AL functions
Creating C/AL functions
Solution Design – 24%
Defining master tables
Defining secondary tables
Main and subforms
Matrix forms
Complex datatypes
Multilanguage functionality
Microsoft SQL Server
C/AL Triggers
Solution Implementation – 24%
Posting
Integration
Reporting
Statistics
Dimensions
Interfaces
Deployment
Specific Programming Topics – 21%
DataItems
Triggers
Reports
Dataports
XMLports
Codeunits
Lookups
Advanced report features
Development Scenarios – 14%
Master table creation
Secondary table creation
Posting
Journals
Reports
Data import/export
PS: Anworten hab ich noch nicht alle angeschaut... angaben ohne gewähr ;)
Schummelthread solls keiner werden.. Quelle mibuso.com
1) Which of the following properties u can change during runtime ?
a) Visible <=
b) Vertglue
c) SourceExpr
2) You are make a data conversion from legacy system to new one using Dataport but something occur thier is description filed contain 80 char and the new description filed can take 50 char only. You told our customer about this he told u its fine with first 50 char know what is true way to do this data conversion?
a) Change the new description filed properties to take 80 char
b) Write code in the table trigger to reed the first 50 char
c) Dataport will handle this situations u don’t need to do any thing
d) You need to write code in data port to handle these situations
e) Put the data in variable and then write code to read the first 50 char <=
3. If you create file and write to it the number '1000' what is the size if u know that the textmode method is (textmode(true) )
a) 2 byte
b) 4 byte
c) 6 byte <=
d) 8 byte
4. If you create file and write to it the number '1000' what is the size if u know that the textmode method is (textmode(false) )
a) 2 byte
b) 4 byte <=
c) 6 byte
d) 8 byte
5. Your customer COMPLAIN about report u create he said "the report goes write and every thing is correct but the report very slow" what u have to change to fix this problem??
a) Dataitems
b) Filters
c) Keys <=
d) DataItemTableView
6. One question was about Process and Transaction in Navision
a) One or more transaction in one Process
b) Zero or more transaction in one Process <=
c) One or more Process in one transaction
d) Zero or more Process in one transaction
e) Transaction and Process doesn’t work together...
7. What is the three primary thing mentions in every report (chose three of six)
a) Company Name <=
b) Page number <=
c) Date and time
d) User name <=
e) Time of work
8. Xfile.EoF how can u represent it in another way
a) Xfile.pos
b) Xfile.read
c) Xfile.len
d) File.read(file.pos)= file.len <=
e) File.read= file.len
9. When displaying subordinate records in a subform what control do you use?
a) You must use a Tablebox <=
b) You usually use a Tablebox
c) A picture box
d) A text box
10. Form A calls on instance of a Codeunit and assigns 'RED' to a global text variable. Form B call an instance of the same Codeunit and assigns the same global variable 'BLUE'. Forma A then calls another function in the same Codeunit and retrieves the value of the global variable. What is the value?
a) Red <=
b) Blue <=
c) Null
d) You can't do this
11. What function should you call in a report onaftergetRecord trigger that will still print the record your currently on.
a) CurrReport.SKIP
b) CurrReport.BREAK
c) Exit <=
d) CurrReport.QUIT
12. User entering a general journal what are the dimension data flows. (2 Questions on this)
T Default Dimension
U Journal Dimension
V Dimension Ledger
X Production Order Dimension
Y Document Dimension
Z Posted Document Dimension
a) T to U <=
b) U to V <=
c) T to Z
d) X to Z
13. Report 2 dataitems “Cust. Ledger Entry” and “Customer”. “Cust. Ledger Entry” is linked and indented. What function do you use to break out of the current record?
a) CurrReport.CLOSE
b) CurrReport.QUIT
c) CurrReport.BREAK
d) CurrReport.SKIP <=
14. When displaying subordinate records in a subform what control do you use.
a) You must use a Tablebox
b) You usually use a Tablebox <=
c) A picture box
d) A text box
15. What function should you call in a report onaftergetRecord trigger that will still print the record your currently on.
a) CurrReport.SKIP
b) CurrReport.BREAK
c) Exit <=
d) CurrReport.QUIT
16. Which type of table has most buss rules?
a) Ledger Table
b) Journal Table <=
c)…
17. A KEY can have at most, how many SumIndexFields?
a) 20 <=
b)…
18. What is the fundamental business rule concerning posting for all functional areas?
a) Take Journal recordsand put them into Ledger Table <=
b)…
19. Two options to open a new card from a list form.
a) F11 & Navigate menu
b) Shift F5 & Navigate Menu <=
c) F11 &??
d) Shift F5 &??
20. Which is not valid code?
a) EXIT;
b) EXIT(Amount);
c) EXIT
d)… <=
21. Choose Repeat ... Until loop instance of a While... Do loop when you
a) Want to bypass test given a set of conditional
b) Want to time the loop
c) Want to see how many conditions are mentioned in your test
d) Want to loop to process at least one <=
22. Which of the following commands would be best to use C/AL return the user ID?
a) UID
b) System.UID
c) USERID <=
d)…
23. Which is not considered a document report?
a) Sales invoice
b) Customer Statement
c) Inventory Order details <=
d) Purchase Order
24. Which command would you place on PreSection trigger prevent the section from printing?
a) CurrReport.ShowOutpu(True)
b) CurrReport.ShowOutpu(False) <=
c)…
25. A list report is report that contains a single Dataitem that is the table being listed. which of the following would be a TRUE statement
a) Only PK (field and description and field can be included in ...
b) Each column on the report containing a field from the table on the data is printed from that
table, not brought in or calculated other table <=
c) the report limited to only 65500 lines
d) Each Field other then the PK, must be activated using the CALCFIELD equivalent to?
26. Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField <=
27. In the Dataport field designer the list of source expressions should be what order?
a) Same order as the information in the file <=
b) Same order as the fields in the table
c) Alphabetical order
d) Ordered by data type.
28) Which describes Codeunit?
a) container for all c/al code
b) Container for c/al code <=
c) Measurement of C/AL
d) The editor c/al
29. Witch of the followings is not characteristic of a menu suite?
a) It consist of a set of menu
b) A menu item is the highest level in the tree <=
c) A menu node can be either a menugroup or menusuite
d) A menu group contain a collection of menu nodes
30. Which of the following is not true regarding menus or menusuite?
a) A menu contains content for a specific departmental area <=
b) Menus consist of items, groups and objectives <=
c)…
31. Which is the sales & receivables master table?
a) Salesperson
b) Customer <=
c)…
32. If you want a variable that has been passed to be changed while in the function you can ...
a) Pass it by reference <=
b) Pass it by...
c)…
33. What type of data have whole number and max 100000?
a) Int
b) Decimal
c) Option <=
d) Code
34. Which is unary operator?
a) + <= (You can write VAR := +VALUE)
b) /
c)…
35. Which is not converted automatically?
a) Blob to binary <=
b) Int to dec
c)…
36. Form A calls on SINGLE instance of a Codeunit and assigns 'RED' to a global text variable. Form B call an instance of the same Codeunit and assigns the same global variable 'BLUE'. Forma A then calls another function in the same Codeunit and retrieves the value of the global variable. What is the value?
a) Red * (chose a) <=
b) Blue (or B) <=
c) Null
d) You can't do this
37. How many Indents can a report have?
a) 1
b) 10 <=
c) 100
d) Unlimited
38. What is the use of setting permission in the report?
a) Prevent user from using the report
b) Use this property to give a database object extra permission to perform some operations on
one or more tables <=
c)...
39. IF Name <> xRec.Name THEN
ERROR('Bat flies');
Substitute the error message:
a) Name is not present in record
b) Don't changed <=
c) Don't delete
d)...
40. 2 dataitem: one (dataitem2) is below of the other (dataitem1) and indented. if in AfterGetRecord of the dataitem2 I call CurrentReport.Skip, what is the next record?
a) Execute next record (dataitem2) <=
b) Execute next record (dataitem1)
c) Nothing, report stop
d)...
41. How many dataitem at the maximum can we indent in a report?
a) 10 <=
b) 20
c) 100
d) Unlimited
42. Something with NODBC and Multilanguage
a) N/ODBC support Multilanguage <=
b)…
43. 2 dataitem: one (dataitem2) is below of the other (dataitem1) and indented. If in AfterGetRecord of the dataitem2 I call CurrentReport.break, what is the next record?
a) Execute next record (dataitem2)
b) Execute next record (dataitem1) <=
c) Nothing, report stop
d)...
44.
Customer.FIND('+');
Customer.NEXT('-3');
Customer.FIND('=');
In table the following records are present: 1000, 2000, 3000, 4000, 5000, 6000.The result of previous instructions is:
a) 2000
b) 3000 <=
c) 4000
d) 5000
e) 6000
45.
Customer.FIND('+');
Customer.NEXT('3');
Customer.FIND('=');
In table the following records are present: 1000, 2000, 3000, 4000, 5000, 6000.The result of previous instructions is:
a) 2000
b) 3000
c) 4000
d) 5000
e) 6000 <=
46. What is the property used for Multilanguage support?
a) Caption
b) CaptionML <=
c)...
47. What of the following is it a File function?
a) WRITELINE
b) EXIST <=
c) BINARYMODE
48. What of the following is it a File method?
a) WRITELINE
b) BINARYMODE
c) CREATE <=
d)...
49. In a report what is trigger that fire before?
a) OnInitReport <=
b) OnPreReport
c) OnPreDataItem
d) OnPostDataItem
50. In a report with request form what is trigger that fire before?
a) OnPreReport
b) OnOpenForm <=
c)...
51. Your customer has bought your product, but your salesperson has talked with
him and has said that the latest version of navision has the improvements that
are present in add-ons that you will install.
What do you do?
a) Install latest version of navision;
b) Install latest version of navision, along with improvements present in your add-on <=
c)...
52. A subform
a) Have always a table box
b) Have usually a table box <=
c)...
53. If I have a code in the OnLookup table trigger that filters in a record set, how
can I delete this filter in a form?
a) You can't
b) Write code in OnLookup form trigger <=
c)...
54. For SumIndexFields what do you use?
a) CALCFIELD
b) CALCSUM <=
c)...
55. In legacy system we have a field of 80 characters. You must import from legacy
system to Navision but the new field is 50 characters. What do you do, if the
customer has said that it is ok if you import from 80 character fields to 50
character fields.
a) Write code in DataPort to convert
b) You must do nothing: Navision do it for you during assignment
c) Put the data in variable and then write code to read the first 50 char <=
d)…
56. There is a report. We want to add to this report the possibility for the user to
choose if show a description. To make this we add a check box. What must we
do in the report?
a) Write code in OnPreSection report trigger <=
b)…
57. What is the equivalent of CREATETOTALS function in a report (more or less)?
a) TotalFields <=
b)...
58. ---------------------------------------------
Customer.SETCURRENTKEY("No.");
Customer.SETRANGE("Sales",0);
IF Customer.FIND('-') THEN BEGIN
{code}
END -------------------------------------------
Customer.SETCURRENTKEY("Sales");
Customer.SETRANGE("Sales",0);
IF Customer.FIND('-') THEN BEGIN
{code}
END -------------------------------------------
Customer.SETCURRENTKEY("Sales");
Customer.SETFILTER("Sales",'0');
IF Customer.FIND('-') THEN BEGIN
{code}
END -------------------------------------------
Which is the code faster?
a) The first one
b) The second one <=
c) The third one
d) All three codes go at same way
(Customer.“Sales” is a Calculated Field: you cannot set the key on a calculated field, the instruction Customer.SETCURRENTKEY(“Sales”) is invalid. If SALES is a normal field the second one is the fastest)
59. What it the key to compile an object from object design?
a) F11 (choose) <=
b) There isn't any key
c)...
60. What is the property to select a subform in a form?
a) SubFormID <=
b) SubForm
c)...
61. When you modify a menusuite, what are the changes that remain?
a) It doesn't save them
b) At level of menu level
c) Maintain all changes
d) Only the last
e) Maintain the difference between the level below <=
62. When you create a development database for a customer that has already the
db, what do you do?
a) you make a backup and install them with check..
b) create a backup, create a new DB using client, restore from backup <=
c)...
63. Report with modifications. Which do you modify?
a) the new that is a copy of the original <=
b) the original
c)...
64. How do you launch a Codeunit?
a) CODEUNIT.RUNMODAL(..)
b) CODEUNIT.RUN(..) <=
c)...
65. Report only batch. How do you launch it?
a) Report.run
b) Report.run (record)
c) Report.run (tmpRecord) <=
d)...
66. Import Dataport. From the first record you can extract all data that you need,
following data too (for these you don't care about them). What do you do to skip
all records except the first one?
a) CurrentReport.skip (in onbeforeimportrecord)
b) CurrentReport.skip (in onafterimportrecord)
c) Init (in onbeforeimportrecord)
d) Init (in onafterimportrecord) <=
67. C/AL language programming. What is true?
a) It derives from Microsoft C#
b) All objects have c/al
c) All object except Menusuite <=
d)...
in 4.00 menu suite has not c/al / Depending on what version 3.70 b
68. I declare a variable with VAR.
a) You pass a variable by reference rather than by value <=
b) You pass a variable by value rather than by reference
c) You declare a variant variable
d)...
69. XMLPort. How do you calculate flowfield in automatic?
a) Calcfields
b) FieldCalc
c) AutoCalcField <=
d)...
70. In a report a user wants to set a filter. What do you do?
a) Populate DataItemTableView
b) Delete DataItemTableView <=
c) Populate dataitemlinkreference
d) Delete dataitemlinkreference
71. You have a report and you print for all users the same value. Why? (it talk about
DataItemTableView)
a) You haven't set table filter <=
b)...
72. Import txt file. When does worksheet appear?
a) Never <=
b) Always
c) If two objects (that present and that you imported) are modified
d) If the object has different modifications
73.
IF NextEntryNo = 0 THEN BEGIN
ResLedgEntry.LOCKTABLE;
IF ResLedgEntry.FIND('+') THEN
NextEntryNo := ResLedgEntry."Entry No.";
NextEntryNo := NextEntryNo + 1;
END;
What does this code do (in posting routines)?
a) It is used to have not record with null value
b) To calculate the next entryno <=
c)...
74. What is the following property false?
a) Autoincremental
b) You can modify the table
c)...
Refer to journal. All 2 options are correct
75. You must verify the empty row in the journal when you post. What do you do? the code must be reusable
a) You create a CodeUnit and pass it a record <=
b) You can't, because the table don't accept function
c) You put function in the form
d)...
76.
IF ISCLEAR(WORDAPP)
CREATE (WORDAPP)
WordApp is Automation. What does the code do?
a) Sure I instance a variable
b) If the variable doesn't exist I create it <=
c) Clear the variable
d)...
77. Max number of menu suite in a db?
a) 10
b) 15 <=
c) 20
d) Unlimited
78. In a subform, what can you insert in it?
a) Tab menu
b) Tablebox
c) Picturebox
d) Subform <=
79. What is not true for a blob?
a) You can export only as a bitmap <=
b) You can insert "memowrite"
c) It can contain pictures
d) At maximum 2GB
80. You have a label and you want to change its value at runtime. What do you do?
a) SourceExpr
b) SourceExpr only if exist a text box linked with it
c) Is not possible <=
81. You must import sales order data (they are already verified).
a) And b) two option directly into ledger table
c) Copy in journal table, save and post them
d) Copy in journal table and post them <=
82. Insert a record in sales order. What dimensions are used?
a) Default dimension
b) Journal dimension
c) Ledger
d) Document
e) Document posting
g) Default + journal
h) Journal+ document <=
i) Ledger + document posting
83. You are posting a journal. What are dimensions that are used?
a) Journal <=
b) Ledger
c) Default
84. In a function with a record as parameter, how can you know witch filters have been applied to it ?
a) GetFilters
b) Impossible
c)…
85. Witch kind of files are not present on the client computer
a) stx
b) etx
c) fob
d)…
86. If you set the SourceExpression of a textbox to a BigText variable, what will be the result?
a) Error
b) Text will be truncated
c)…
87. Almost like the #86, If you have varText := varBigText;
a) Error
b) VarText will be truncated
c)…
88. Outstream.Write. What's an invalid target?
a) Blob
b) Ocx
c) Report <=
d) Automation
89. What is the fundamental business rule concerning posting for all functional areas
in navision application?
a) All transactions are posted through the Ledger into the journal
b) All transactions are posted by the user directly into Ledger while the journal is used to track user.
c) All transactions are posted through the journal into the ledger <=
d)…
90. Which of the following characteristics not result of the table relationship?
a) Optimize table records <=
b) Validate entry
c) Perform lookup other tables
d) Automatically propagate changes from one table to other table.
91. Which of the following functional area has more than one Master Table?
a) General Ledger <= (G/L Account, Bank Account)
b) Fixed Assets
c) Inventory
d) Sales & receivables
92. Which data type would be used for a field that has a FieldClass property of
Flowfield and a Calc Formula method of sum?
a) Date
b) Boolean
c) Decimal <=
d) Integer
93. Which are the valid "parts" of a table in Navision?
a) Data and Ledgers
b) Data and Properties <=
c) Data and described
d) Source and description
94. Which is not a flowfield type?
a) Lookup
b) Sum
c) Validate <=
d) Count
95. Which is Cash Managements master table?
a) Customer
b) G/L Account
c) Cash Account
d) Bank Account <=
96. In customer table comment field and CalcFormula property is following
EXIST('CommentLine') WHERE (Table Name=CONST(Customer),No.=FIELD(No.)))
Select the item that represents the data type of a command field
a) Boolean <=
b) Binary
c) Integer
d) Decimal
97. Which is true?
a) A field in the master table is table related to the ledger table
b) A field in the Ledger table is table related to the master table <=
c) Master and ledger each have a field that is the table related to the other.
98. What is the main purpose of a subform?
a) Display information below a form
b) Filter a subset of information on a form
c) Make a form that is reduced in size
d) Display information from another table on a form <=
99. User make journal entries. What type of form used for that in Navision std.
a) List Form
b) Card Form
c) Worksheet form <=
d) Tabular Form
100. What can we do to access list form from a card form?
a) F5, Selecting lookup MenuItem or F11
b) F5, Selecting ListMenu item or selecting the lookup button on toolbar <=
c) F11, Selecting ListMenu item or selecting the lookup button on toolbar
d) F5, Selecting ListMenu item or selecting the find button
101. What is concatenation?
a) Extracting a string from within another string
b) Creating a new string by alternately taking characters from two other string
c) Combining string values by appending the characters of one to end of the other <=
d) Combining string values by adding the numeric value of one to the numeric value of the
other
102. Which is not a report type?
a) Transaction
b) Status <=
c) Document
d) Test
103. A list report that contains 1 dataitem is the table being listed. Which is true?
a) Only the PK field and descriptive field can be included in the report
b) Each column on the report contains a field from the table and the data is printed from that
table not brought in or calculated <=
104. Report with Customer and Cust.Ledger entry as dataitems and Cust.Ledger
entry indented under customer. Which of time following would be easiest way
to filter both tables to the same date range
a) Use SETRANGE OnPreReport <=
b) Add DateFilter to the ReqFilterFields property of the customer dataitem and link the posting
date field of the Cust.Ledger entry dataitem to the Date filter field of the customer table
using the DataItemLink property
c) Add DateFilter to the ReqFilterFields property of the customer dataitem and, use the set
SETFILTER cmd to Filter the posting date field Cust.Led.Entry
d) Use SETFILTER OnPreDataItem
105. The Auto save property on a dataitem in a Dataport tells the dataitem to automatically
a) Replace records that exist in the table during on import
b) Save the file periodically
c) Insert records during on import <=
106. Which is True?
a) Xml ports do not handle xml documents that find and delete data in the db <=
b) Xml ports do can be run from object designer
c) Xml ports will produce proper output
107. Which field in the XMLPort description would be used to identify which table a
TagName is equivalent to:
a) Table Name
b) TagType
c) TagName
d) Source type <=
108. In a function, when a parameter is specified as Var it means...
a) The parameter is passed as a variant
b) The parameter is passed by value rather than reference
c) The parameter is passed by reference rather than value <=
109. How can an element of object be addressed in Code?
a) Using Instance of class definition
b) Using normal syntax of structure language
c) Using dot operator <=
d) Using pointer reference
110. What file is not found (has relation with Multilanguage) in client folder?
a) *.ETX
b) *.STX
c) *.CHM <= (Help is only Multilanguage)
d) *.FDB
111. What Internal document if we add field in table?
a) Documentation trigger
b) Project Log <= (The question is about a document not a trigger)
c) Field Description
d) Code Command
112. You need to open form to get information from input of the user.What code?
a) FORM.RUN(FormID)
b) Create variable type form and code: VAR.RUN
c) Create variable type form and code: VAR.RUNMODAL
d) FORM.RUNMODAL(FormID) <=
113. What is the not valid target of WRITELINE?
a) BLOB
b) File
c) Report <=
d) Automation
114. Witch posting routine read the journal table?
a) Post Batch
b) Post Line
c) Check Line <=
115. Witch posting routine writes in to ledger table?
a) Post Batch
b) Post Line <=
c) Check Line
116. Look the following code:
Find(‘-‘)
Do
Delete();
While next <> 0
Find(‘-‘)
Do
Ok:=Delete();
While next <> 0
DeleteAll();
What’s the difference?
a) 1 is faster
b) 2 is faster
c) 3 is faster <=
d) All are the same
117. In a report with 1 DataItem. Witch trigger is not executed if the dataset is
empty?
a) OnAfterGetRecord <=
b) OnPostDataItem
c)…
118. In a function with a record as parameter. Can we know witch filters have been
applies?
a) NO
b) Yes, the records contain all the information about the filter applied <=
c) Yes, the filters applied to a record are stored in a system variable
119. What is a typical instruction in a check line routine?
a) Validate()
b) Modify()
c) TESTFIELD <=
d)…
120. Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
a) 1 <=
b) 20
c) 40
d) 100
121. In a DataPort you have to test the data before to import them. Where do you want to place your code?
a) OnBeforeImport
b) OnAfterGetRecord
c) OnAfterImportRecord
d) OnBeforeEvaluate <=
122. Look the following code:
VarRecord.field1 := ‘xyz’;
VarRecord.modify();
When the change is submitted ?
a) a submit is implicitly called after the modify
b) when leaving the trigger
c) modify submit the transaction <=
d)…
123. How to implement optimistic concurrency (I don’t remember the server type) ?
a) Set a maximum of filters. The server will lock the table (implicit) during the update <=
b) Set a maximum of filters and explicitly call the LOCKTABLE
c)…
124. If a customer wants to be able to change the sorting order of a report without
the intervention of a Navision developer, what do you do?
a) Fill the ReqFilterHeading
b) Leave the ReqFilterHeading blank
c) Fill the property
d) Leave the property blank?
e) ReqFilterFields
f) Leave DataItemTableView blank <=
125. In a form create with the form wizard. Witch code is automatically generated?
a) Validate(“No.”) in OnAfterGetRecord <=
b) SETRANGE(“No.”) in OnAfterGetRecord
c) FORM.Save() in OnDeleteRecord()
d) In OnNewRecord
126. In a report, witch instruction do the same task as putting a field name in the
totalField property ?
a) CreateTotal <=
b) FlowFiels
c) Sum
d)…
127.
Sec A:
Cust.Setcurrentkey('No.');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec B:
Cust.Setcurrentkey('SalesPerson');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec C:
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
a) Sec A is faster
b) Sec B is faster <=
c) Sec C is faster
d) All took same time
128. A client make a mailing with Microsoft word combinated with MBS, We use for
this.
a) ODBC
b) C/ODBC
c) C/Front
d) Automation Microsoft Word <=
129. How many Indents can a report have.
a) 1
b) 10 <=
c) 100
d) Unlimited
130. You are making a data conversion from legacy system to new one
Using DataPort but something occur thier is description filed contain 80 char
and the new description filed can take 50 char only.
You told our customer about this he told u its fine with first 50 char
Know what is true way to do this data conversion?
a) Change the new description filed properties to take 80 char
b) Write code in the table triggers to reed the first 50 char
c) DataPort will handle this situations u don’t need to do any thing
d) You need to write code in data port to handle this situation <=
e) Put the data in variable and then write code to read the first 50 char <=
131. Look the following code:
VarRecord.field1 := ‘xyz’;
VarRecord.modify();
When the change is submitted ?
a) A submit is implicitly called after the modify <=
b) When leaving the trigger
c) Modify submit the transaction
132. How to implement optimistic concurrency (I don’t remember the server type)?
a) Set a maximum of filters. The server will lock the table (implicit) during the update
b) Set a maximum of filters and explicitly call the LOCKTABLE <=
c) Lock table when you read and you are sure that after you will do an update
d)…
132)b i think so because we must lock EXPLICITLY the table with statement LOCKTABLE(TRUE,TRUE). so A is not correct, and also C is not correct because we don't lock a table when we read...but only just before we make an update.
133. Which of the following form control would you use to display subsidiary
information on the form?
a) Subform <=
b) Textbox
c) Tablebox
d) Matrixbox
134. How menusuite object changes are stored
a) Each change is stored as a complete list of menusuite menus and items and replaces the
previous level
b) Changes are stored as the difference between previous menusuite level and the
current one <=
c) Menusuite changes are not stored
135. Which of the following is not true regarding the methods and properties of an
Automation server controlled from C/SIDE?
a) When the Automation variable is properly declared, you can view the methods and
properties using the C/AL symbol menu <=
b) Certain methods and properties will not be able to utilized in navision if there is no
corresponding data type within navision
c) Knowledge of the relationship between COM data typesand navision data types is required
d) Com data type can be converted to Navision data types using alterdatatype in order for an
outside application.
136. The main limitation of DataPort as a tool to integrate Navision with an outside
application is that requires the outside application to:
a) Initiate all data transfers from itself to Navision by running the DataPort
b) Be certified as Navision compliant
c) Place its data into an ASCII file before the navision DataPort can read <=
d) Know internal data structure of the navision tables to be updated by the DataPort
137. Which of the following is Not true regarding XML TagName field
a) Attributes are entered prior to the elements they define <=
b) TagNames must be entered in order
c) Parent elements must precede their child elements
d) Child elements are indented
138. Which of the following XML port TagName properties selects the field to be
mapped to Xml data
a) Source field
b) ReqFilterField
c) Xml Field
d) Field name
139. Which field in the Xml port description would be used to identify which table a
tagname is equivalent to?
a) Table name
b) Tag Type
c) Tag Name
d) Source Type <=
140. You are importing data from outside source into Navision using DataPort the
data is in variable format and each field is separated by ampersand. Which of
the actions should you perform to be able to import data using DataPort?
a) Change field separator to ampersand
b) Change field delimiter to ampersand
c) …
141. Which of the following dataitem properties would be used to specify which field
or fields a Navision Report should Group By.
a) GroupTotalFields
b) Total fields <=
c) GroupByFields
d) Req. file
142. You have set the left margin = 1000 , before printing report the user specifies
15mm left margin in the page setup window. When print the report
LeftMargin=?
a) 15mm
b) 10mm
c) 25mm
d) 5mm
143. Which of the following is true regarding the Request Options from Designer?
a) Request options form does not exist
b) To design options tab of options
c) To design all of the tabs of the request form design
144. Which of the following is Not a Valid report component?
a) Control
b) Table form <=
c)…
145. You are designing a report that is going to be run while other users are
inserting records into the
same transaction tables, using version based Navision server what do you need
to do t the report to
make sure that the data reported will be a consistent snapshot of the data
those transactions
a) You don't need to anything <=
b) You will need to set the transaction type property to SnapShot
c) You will need to set the transaction type property to Browse
d) There is nothing you can do. User will just have to tell all the others
146. Which of the following is true regarding to Automation Sever?
a) C/Side can receive events from components with the Automation events=yes
b) C/Side cannot receive events from outside components
c) C/Side can only receive Com+ components
d) C/Side can receive events from components with the WithEvents=yes
147. Cust. Ledger entry indented under Customer, which of the following would be
easiest way to filter both tables to the same date.
a) Add DateFilter to the Req. Filter Fields property of the customer dataitem and link the
posting date field of the custLedgerEntry data item to the data filter field of the customer
table using the DataItemLink property
b) Add DateFilter to ReqFilterField property of the customer dataitem and use the SetFilter
command to filter the posting DateField of the Cust. Ledger Entry table.
c) Use SetFilter
d) Use SetRange
148. Which command would you place OnPreSection trigger prevent the section
from printing?
a) CurrReport.Showoutput(True)
b) CurrReport.Section(True)
c) OnReportPrint(true)
d) ShowReport
e) CurrReport.Showoutput(False) <=
149. Which is not true?
a) Local CodeUnits can only be run from other CodeUnits <=
b) CodeUnits can be run from other CodeUnits
c) CodeUnits can be run from other objects <=
d) Other object can be run from CodeUnits
150. Local variables are limited in scope to the function which they are defined
a) Local variables can only be defined in CodeUnits
b) Local variables are reinitialized other execution of a Codeunit has completed <=
c) Local variables can only be declared in local functions
151. In order for an outside application to access data within Navision Server using
C/ODBC what must it support?
a) Microsoft Query <=
b) ODBC
c) Sql Server
d) Navision Server
152. We have 2 dataitem one is master (I can't remember I think customer
and ship ...), and 10 customers have two ShipToAddress. When the report
printed how much footer for ship to addresses?
Ans:???
153. When can change the fieldname in the table?
Ans: I think it should be anytime.
154. How many level of menusuite?
Ans: 20
155. How to run a menusuite?
Ans: You can’t
156. What properties need not be defined for menu item?
Ans: Name
157. List the trigger process order of Dataport.
Ans: OnInit, OnPreDataPort, OnPreDataItem, OnBefore/AfterExportRecord,
OnPostDataPort
158. How to call a code unit in another object?
Ans: CODEUNIT.RUN
159. Which is NOT a Form Trigger?
Ans: OnDisposeForm
160. If a field in a table’s editable property set to “No”. Which of the following
statement is true?
a) User cannot change the value in the form but can change the value by C/AL code <=
b) User cannot change the value in the form or by C/AL code.
c)…
161. How to describe the relationship between Master table and Ledger table?
a) Ledger table is table-related to master table………. <=
b) Master table is table-related to ledger table……….
c)…
162. Complex data type. More functions in it does they slow down?
Ans: ???
163. A question about: KEYGROUPS of report if customer have report only run at end
of year
164. How to handle LockTable for small customer who uses Navision Database
Server
Ans: ???
//Answers
#26 The automatic calculation of SumIndexFields - acording to the courseware:
CalcFields: Automaticaly calculates the information for flowfields entered here
AutoCalcFields: Used to determine whether or not the value in the flowfield should be recalulated before the field is exported
#30 B)should say OBJECTS not OBJECTIVES - then the correct answer would be A) Departmental areas
#36 I beleive that the correct answer is C) Null as it is not a 'single instance' so the variable is initialized for each instance so it would be 'Null'
#50 I beleive the correct answer is OnInitReport - this is ALWAYS first - doesn't matter if a request form is uesed or not.
#80 Changing a label - this can be done with the 'Caption' property
#83 Posting a Journal - both Journal and Ledger are used
#85 & #110 - The *.FDB (which is the database) are generaly not on the client unless it is a single user installation
#86 & #87 are both A)Error - I tried it and both will not allow it to be done
#91 Fixed Asstes also has 2 Masters Asset and Insurance
#109 - I am not sure of this one but normally ELEMENT is part of an Array or an XML data - both of these would be used with the pointer or index but if they mean property or field of an object then it is the dot
#111 - I could find no information on the Project Log - where do I find this info?
#114 reading Journal records - again acording to the courseware:
CheckLine - Never reads or writes the Journal Table
Post Line - Never reads or writes Journal table - can read other tables for validation - writes Ledger entry
#119 - In my attempt - I had this but TESTFIELD was not an option, however EMPTYLINE() was an option - I thought that was the correct answer but since you didn't ahve it ... Maybe it is the Validate()
#121 You cannot test data before it is imported but it can betested before processed - I think the answer is OnAfterImport because the courseware states that "Most processing and validation is done in the OnAfterImport trigger"
**Optimistic Concurrency - I am not so optismistic!! The references to this in any of the training or reference material - even in the Installation and Configuration manuals is sketchy at best and does not answer these questions ***
#138 & 139 The property that shows the Field or Table is DataSource that is part of SourceType - in SourceType you choose Text,Field or Table
#148 - just remember that another way towrite this is SHOWOUTPUT(0=1)
#151 - I don't think you must have Ms Query as you can use NODBC in C# or VB as the interface without MSQuery - I don't know this one
200) Client wants to have a mailmerge with Navision and Word - they want to be able to add or change fields without help of Navision Developer. What is the best way?
a) Navision to word
b) Word to Navision
C) Navision to world
165. Which one is faster?
a) Find(‘-‘)
b) Do
c) Modify();
d) While next <> 0
166.
a)Find(‘-‘)
b) Do
c) Ok:=Modify();
d) While next <> 0
167. Which of the following is NOT true of updating data in Navision using NODBC ?
a) A Microsoft RAISEERROR will be generated
b) Data Entered through NODBC will not be validated <--choose
c) Data will be checked for conformance to Navision data types
d) Additional fields normally populated in the onValidate trigger
168. Exit(True)
a) Return Boolean value
b) Will not accept a parameter True
c) Only executes if it returns a vale <--choose
d) classes down the Navision client
169. Which case to run a report in modal fashion, while within a transaction?
a) If request form is show modal before the report
b) If report populate all need information on request form before display
c) If request form is not shown <=
d) Report already run once and request form was properly fill in
170. NA Server, customer want to sent customer welcome letter, mail merge. What
should be used?
a) Mail merge using CODBC
b) Automation from MS word to Navision
c) Automation from Navision to MS word <=?
d) Mail merge ODBC
171. Create a card form by form wizard, what code is added automatically?
a) onAfterGetRecord(), setRange("No");
b) onNextRecord()...
c) onDeleteRecord()...
d) onAfterGetRecord(), validate("No"); <=
172.Import AR balance, time is limited, so need to do it quick, how to do it
a) Import into Gen. Journal line, save it, open the journal form, post it
b) Import into Gen. Journal line, without saving, call Code Unit to post it <=
Note: I am not sure for (b). Is this possible for not saving a Gen. Journal line and post it?
173. About the speed of 3 sample code.
a) SetRange <=
b) SetFilter
174. User entering a general journal what are the dimension data flows.
T Default Dimension
U Journal Dimension
V Dimension Ledger
X Production Order Dimension
Y Document Dimension
Z Posted Document Dimension
a) T to U
b) U to V
c) T to Z
d) X to Z
175. Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields <=
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField
176. In a report with request form what is trigger that fire before?
is it oninitreport?
177. Report only batch. How do you launch it?
a) Report.run
b) Report.run (record)
c) Report.run (tmpRecord)
178. Import Dataport. From the first record you can extract all data that you need,
following data too (for these you don't care about them). What do you do to
skip all records except the first one?
a) CurrentReport.skip (in onbeforeimportrecord)
b) CurrentReport.skip (in onafterimportrecord)
c) Init (in onbeforeimportrecord)
d) Init (in onafterimportrecord)
179. Have a report and you print for all users the same value. Why?
180. Import txt file. When does worksheet appear?
a) Never
b) Always
c) If two objects (that present and that you imported) are modified
d) If the object has different modifications
181. You must verify the empty row in the journal when you post. What do you do?
the code must be reusable
a) You create a CodeUnit and pass it a record
b) You can't, because the table don't accept function
c) You put function in the form
182. You have a label and you want to change its value at runtime. What do you do?
183. Insert a record in sales order. What dimensions are used?
a) Default dimension
b) Journal dimension
c) Ledger
d) Document
e) Document posting
g) Default + journal
h) Journal+ document
i) Ledger + document posting
184. You are posting a journal. What are dimensions that are used?
a) Journal
b) Ledger
c) Default
185. Report with Customer and Cust.Ledger entry as dataitems and Cust.Ledger
entry indented under customer. Which of the following would be easiest way to
filter both tables to the same date range
a) Use SETRANGE OnPreReport
b) Add DateFilter to the ReqFilterFields property of the customer dataitem and link the posting
date field of the Cust.Ledger entry dataitem to the Date filter field of the customer table
using the DataItemLink property <=
c) Add DateFilter to the ReqFilterFields property of the customer dataitem and, use the set
SETFILTER cmd to Filter the posting date field Cust.Led.Entry
d) Use SETFILTER OnPreDataItem
186. What is a typical instruction in a check line routine?
187. Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
a) 1
b) 20 <=
c) 40
d) 100
189. In a DataPort you have to test the data before to import them. Where do you
want to place your code?
a) OnBeforeImport
b) OnAfterGetRecord
c) OnAfterImportRecord <=
d) OnBeforeEvaluate
190. Which of the following is not true regarding the methods and properties of an
Automation server controlled from C/SIDE?
a) When the Automation variable is properly declared, you can view the methods and
properties using the C/AL symbol menu
b) Certain methods and properties will not be able to utilized in navision if there is no
corresponding data type within navision
c) Knowledge of the relationship between COM data types and navision data types is required
d) Com data type can be converted to Navision data types using alterdatatype in order for an
outside application. <=
191. Which of the following XML port TagName properties selects the field to be mapped to Xml data
a) Source field <=
b) ReqFilterField
c) Xml Field
d) Field name
192. What is not true for a blob?
a) you can export only as a bitmap <=
b) you can insert "memowrite"
c) it can contain pictures
d) at maximum 2GB
193. Look the following code:
VarRecord.field1 := ‘xyz’;
VarRecord.modify();
When the change is submitted ?
a) a submit is implicitly called after the modify
b) when leaving the trigger
c) modify submit the transaction
194. How to implement optimistic concurrency
a) Set a maximum of filters. The server will lock the table (implicit) during the update
c) Set a maximum of filters and explicitly call the LOCKTABLE
195. In a function with a record as parameter. Can we know witch filters have been
applies?
a) NO
b) Yes, the records contain all the information about the filter applied
c) Yes, the filters applied to a record are stored in a system variable
196. Which is Not true?
a) Local Codeuınits can only be run from other codeunits <=
b) codeunits can be run from other codeunits
c) codeunits can be run from other objects
d) other object can be run from codeunits
197. local variables are limited in scope to the function which they are defined_
a) local variable can only be defined in codeunits
b) local variables are reinitialized other execution of a codeunit has completed
c) local variables can only be declared in local functions <=
198. Which of the following is NOT true of updating data in Navision using NODBC ?
a) A Microsoft RAISEERROR will be generated
b) Data Entered through NODBC will not be validated
c) Data will be checked for conformance to Navision data types
d) Additional fields normally populated in the onValidate trigger
199. You have set the left margin = 1000 , before printing report the user specifies
15mm left margin in the page setup window. when print
the report leftmargin=?
a) 15mm
b) 10mm
c) 25mm
d) 5mm
200. What cannot be in subform?
need option here too...but i think you can put a subform in a subform
201. A listreport is report that contains a single Dataitem that is the table being
listed. which of the following would be a TRUE statement
a) Only PK (field and description and field can be included in ...
b) Each column on the report containing a field from the table on the data is printed from that
table, not brought in or calculated other table.. <=
c) the report limited to only 65500 lines
d) Each Field other then the PK, must be activated using the CALCFIELD equvilent to?
202. IF Name <> xRec.Name THEN
ERROR('Bat flies');
substitute the error message:
a) Name is not present in record
b) Don't changed (choose) <=
c) Don't delete
d) ...
203. 2 dataitem: one(dataitem2) is below of the other(dataitem1) and indented. if in
AfterGetRecord of the dataitem2 I call CurrentReport.Skip, what is
the next record?
a) execute next record (dataitem2) (choose) <=
b) execute next record (dataitem1)
c) nothing, report stop
d)...
203. Something with NODBC and multilanguage that I don't remember..
it talks if NODBC supports the mulitilanguage answer is yes
204. 2 dataitem: one(dataitem2) is below of the other(dataitem1) and indented. if in
AfterGetRecord of the
dataitem2 I call CurrentReport.break, what is the next record?
a) execute next record (dataitem2)
b) execute next record (dataitem1) (choose) <=
c) nothing, report stop
d) ...
205. What is the following property false?
a) Autoincremental
b) you can modify the table
c) ..
d) ..
Refer to journal. All 2 options are correct
207. Rigth method to delete a large block of code :
{PRGLPD01 Start deletion
Code to delete…
…
PRGLPD01 End deletion}
208. Why using SETPERMISSIONFILTER ?
209. What is the fundemental bussines rule concerning posting for all functional
areas in navision
application?
a) All transactions are posted throught the Ledger into the journal
b) All transactions are posted by the user directlyinto Ledger while the journal is used to track
user.
c) All transactions are posted throught the journal into the ledger <=
d) ??
210. Xmlport, how to calc flowfiel automatically:
a) calcfield
b) do flow
c) flowcalc
d) calcflow
211. How you can run modally a only batch report while middle a transaction:
a) request form not exist <=
b) request form in run modally
c) report has already data
d) report has already been run once
212. You want to create a mail-merge with MS word. what do you do?
a) use automation from navision to word
b) use automation from word to navision
c) use odbc
d) use c/odbc
214. What you use for exit from ONAFTERGETRECORD in a report for NOT skipp
actually record and the other
a) skip
b) break
c) quit
d) exit <=
215. An a table containt values 1000,2000,3000,4000,5000,6000. Look the following
code. (2 Qs).
FIND('+');
NEXT(-3);
FIND('=');
Position of record?
a) 1000.
b) 2000.
c) 3000.
d) 5000.
e) 6000.
216. Report have 2 Items: Customer and Cust. Ledger Entry which is indented.
There Code On
OnAfterGetRecord of "Cust. Ledger Entry" : CurrReport.Skip. Which one
Is TRUE?:
a) Current Repot -> stop.
b) Customer -> skip.
c) Cust. Ledger Entry -> skip, Customer -> next record.
d) Customer -> skip, Cust. Ledger Entry -> next record.
217. Element (xml?), how to implement it to object.
a) instantiate.
b) language structure.
c) dot operator.
d) ???
218. If you want to run a report modally within process of a form, what have you
do?
a) variablereport.RUNMODAL.
b) variablereport.RUN.
c) Set ReqFilterFields value.
d) Create Request form.
219. If you want to run a form and the user information will be used to setup more
than one table, what will you do:
a) variableform.RUNMODAL.
b) variableform.RUN.
c) FORM.RUN(FORM::Form_Name,rec).
d) FORM.RUNMODAL(FORM::Form_Name,rec).
220. The master table for Financial Area is
a) Currency
b) Bank Account
c) Customer
d) General Journal
e) G/L Entry
221. Which of the Functional area has more then one master table?
222. On a report changing DUE date to Bold if within 3 days of due date.
Is this possible? How.
223. Report - Grouping with Posting Date & Customer No. Even if one Customer filtered..still prints header for posting date and then Customer header. How to stop if only 1 customer selected.
223. Proper procedure to update a Balance field on the Customer card (Balance field is new stored field - not a flowfield). Video rental made and they want customer card update (using standard methodology)
224. When should you remove a modify flag?
225. After a locktable, how can we unlock ?
commit, unlocktable,…..
226. In a function receiving a record as parameter, how is it possible to know witch filters was applied to it before?
impossible, or 3 other answers
227. How many dataitems can we have in a report?
5,10,500,unlimited ?
228. During an import, when does the import worksheet appear?
every time, only if there are some difference between the imported and existing object,…..
229. In a ‘process only’ report, what trigger doesn’t fire?
230 A customer has a report that needs a lot of complex key. The customer will use this report once a year. What the best way to manage the key (without consultant‘s intervention)
231. Which of the following C/AL looping statements always executes at least one time?
I. REPEAT ... UNTIL
II. FOR ... TO/DOWNTO ... DO
III. WHILE … DO
a) I only <=
b) II only
c) III only
d) I and II
e) I and III
f) II and III
232. Before executing any statements inside the loop, which of the following C/AL looping statements evaluates the looping condition first?
I. FOR ... TO/DOWNTO ... DO
II. REPEAT … UNTIL
III. WHILE … DO
a) I only
b) II only
c) III only
d) I and II
e) I and III <=
f) II and III
233. Which C/AL code is a valid comment ?
a) /* comment */
b) { comment
c) // comment <=
d) \\\ comment
e) None of the above
234. What is the result of the C/AL expression: 21 MOD 3
a) 7
b) 21
c) 1
d) None of the above <=
235. What is the result of the C/AL expression: 4 + 6 * 3 / 2
a) 10
b) 13 <=
c) 15
d) 11
1. On a report changing DUE date to Bold if within 3 days of due date.
Is this possible? How.
2. Report - Grouping with Posting Date & Customer No. Even if one Customer filtered..still prints header for posting date and then Customer header. How to stop if only 1 customer selected.
3. Proper procedure to update a Balance field on the Customer card (Balance field is new stored field - not a flowfield). Video rental made and they want customer card update (using standard methodology)
4. When should you remove a modify flag?
Exam Topics
C/AL Programming – 17%
Defining tables
Table and field properties
Creating tables
Defining keys
Setting relationships between tables
Special table fields
Table types and characteristics
Defining C/AL
Accessing C/AL
Simple datatypes
Identifiers and variables
Assignment statements
Expressions
Numeric expressions
Logical and related expressions
IF and EXIT statements
Compound statements and comments
Arrays
Repetitive statements
Other statements
Calling built-in functions
Using intrinsic C/AL functions
Creating C/AL functions
Solution Design – 24%
Defining master tables
Defining secondary tables
Main and subforms
Matrix forms
Complex datatypes
Multilanguage functionality
Microsoft SQL Server
C/AL Triggers
Solution Implementation – 24%
Posting
Integration
Reporting
Statistics
Dimensions
Interfaces
Deployment
Specific Programming Topics – 21%
DataItems
Triggers
Reports
Dataports
XMLports
Codeunits
Lookups
Advanced report features
Development Scenarios – 14%
Master table creation
Secondary table creation
Posting
Journals
Reports
Data import/export
24. November 2006 08:14
Dante hat geschrieben:10. Form A calls on instance of a Codeunit and assigns 'RED' to a global text variable. Form B call an instance of the same Codeunit and assigns the same global variable 'BLUE'. Forma A then calls another function in the same Codeunit and retrieves the value of the global variable. What is the value?
a) Red <=
b) Blue <=
c) Null
d) You can't do this
Meiner Meinung nach müsste a) Korrekt sein!
Frage:
Wenn die Variable von Typ "SingleInstance" wäre, dann wäre b) richtig?
Gruß Mikka
24. November 2006 09:57
ganz klar, a) ist richtig, wenn auf Form A in der Zwischenzeit kein Clear(codeunit) gemacht wurde, und es keine single instance codeunit ist.
Ja Mikka, wenn es eine single instance ist, dann wäre b) richtig.
wenn es aber keine ist und auf Form A in der Zwischenzeit ein clear gemacht wurde, dann ist keine der Antworten richtig, die würde dann nämlich '' lauten und nicht etwa NULL.
Ja Mikka, wenn es eine single instance ist, dann wäre b) richtig.
wenn es aber keine ist und auf Form A in der Zwischenzeit ein clear gemacht wurde, dann ist keine der Antworten richtig, die würde dann nämlich '' lauten und nicht etwa NULL.
5. Dezember 2006 16:05
Prüfungsfrage hat geschrieben:112. You need to open form to get information from input of the user.What code?
a) FORM.RUN(FormID)
b) Create variable type form and code: VAR.RUN
c) Create variable type form and code: VAR.RUNMODAL
d) FORM.RUNMODAL(FormID) <=
Ich würde auch d) nehmen (Da ich keine weiteren Filter oder Variablen verarbeiten will!), aber mit c) währe es auch möglich!
Weiß einer von Euch, welches die Korrekte Antwort ist, und warum?
Gruß Mikka
5. Dezember 2006 16:14
c ist richtig, weil "to get input from the user"
nur so kannst du werte aus der Form abfragen, weil die Form noch im Speicher ist, bis sie geCLEARed wird. mit d kannst du nur auf Action::xxx
prüfen
nur so kannst du werte aus der Form abfragen, weil die Form noch im Speicher ist, bis sie geCLEARed wird. mit d kannst du nur auf Action::xxx
prüfen
6. Dezember 2006 00:14
Michael Schumacher hat geschrieben:[...] mit d kannst du nur auf Action::xxx
prüfen
... und hast den gewählten Datensatz in dem übergebenen Record vollständig im Zugriff.
Somit könnte d) auch richtig sein.
Fakt ist: a) und b) sind falsch.
9. Dezember 2006 03:58
Timo, in der Aufgabe wird in d aber kein Record übergeben, sondern nur eine Formnummer!
13. Dezember 2006 08:43
Hallo,
danke für Eure Antworten.
Ich habe auch schon wieder eine neue Frage:
Wenn ich einen neuen Report erstelle, ist die TransactionType auf <UpdateNoLocks> gesetzt.
Da wir einen Navision Server einsetzten, wird die "TransactionType" auf Snapshot gesetzt (wie in der Navision Hilfe beschrieben).
Somit währe Antwort a) korrekt?!
Gruß Mikka
danke für Eure Antworten.
Ich habe auch schon wieder eine neue Frage:
Prüfungsfrage hat geschrieben:145.
You are designing a report that is going to be run while other users are inserting records into the
same transaction tables, using version based Navision server what do you need to do
the report to make sure that the data reported will be a consistent snapshot of the data those transactions.
a) You don't need to anything <=
b) You will need to set the transaction type property to SnapShot
c) You will need to set the transaction type property to Browse
d) There is nothing you can do. User will just have to tell all the others
Navision Hilfe hat geschrieben:Additionally, there is a Report option that maps to one of the basic options. This enables a report to use the most concurrent read-only form of data access for the connected server. When you use Navision Database Server, it maps to Snapshot and when you use SQL Server, it maps to Browse.
Wenn ich einen neuen Report erstelle, ist die TransactionType auf <UpdateNoLocks> gesetzt.
Da wir einen Navision Server einsetzten, wird die "TransactionType" auf Snapshot gesetzt (wie in der Navision Hilfe beschrieben).
Somit währe Antwort a) korrekt?!
Gruß Mikka
19. April 2007 18:02
Wer hat zu meinen letzten Posting eine Idee?
Gruß Mikka
Gruß Mikka
19. April 2007 19:21
Noch eine Idee? normalerweise hättest du schon längst gelöst da hinschreiben können!
20. April 2007 07:26
[GELÖST] 
Naja, ich wollte / will doch nur wissen, ob die Antwort a) tatsächlich zutrifft.
(Auf die vorgegebenen Antworten verlasse ich mich nicht und ich will ja auch Wissen warum es so ist!)
Ausserdem finde ich es unterhaltsam (und lehrreich) über die Fragen zu schreiben.
Leider sind bisher von anderen Mitgliedern keine weiteren Fragen gekommen...
... Ihr geht doch auch zu Prüfungen bzw. habt bei der Prüfungsvorbereitung oder danach offene Fragen?!
Gruß Mikka
Naja, ich wollte / will doch nur wissen, ob die Antwort a) tatsächlich zutrifft.
(Auf die vorgegebenen Antworten verlasse ich mich nicht und ich will ja auch Wissen warum es so ist!)
Ausserdem finde ich es unterhaltsam (und lehrreich) über die Fragen zu schreiben.
Leider sind bisher von anderen Mitgliedern keine weiteren Fragen gekommen...
... Ihr geht doch auch zu Prüfungen bzw. habt bei der Prüfungsvorbereitung oder danach offene Fragen?!
Gruß Mikka
20. April 2007 22:34
ICh habe alle Fragen schon wieder vergessen....
Developer mit 86% Programming mit 90%...
Developer mit 86% Programming mit 90%...
25. August 2007 12:35
Hi,
ich muss mal wieder meinen Senf dazu geben. Ich habe ja die beiden C/SIDE Prüfungen gemacht und bestanden und hab eigentlich nur zwei interessante Fragen gehabt. Wenn man die Prüfung macht, muss man ja ausdrücklich die Bedingungen von MS akzeptieren, in denen steht, dass man keine Fragen veröffentlichen darf. Deswegen auch nur ganz abstrakt von mir beschrieben.
Die erste Frage hieß in etwa: wann entfernt man den Modified-Haken im Object Designer. Was mich wunderte war: die Antwort "gar nicht" stand nicht zur Auswahl. Durch Ausschlußverfahren konnte ich aber die richtige Antwort identifizieren.
Die zweite Frage zielte auf das Vorgehen ab, wenn man Änderungen, die man in seiner Entwicklungsdatenbank gemacht hat, jetzt in die Echt-DB des Kunden einspielen möchte. Ich weiß nicht, wie ihr das macht, aber MS schlägt vor: Serverdienst stoppen, DB kopieren, Objekte in Original-DB einspielen, Serverdienst starten.
Ich kann mir kaum vorstellen, dass das jemand so macht. Macht ihr das so?
Gruß
Tim
ich muss mal wieder meinen Senf dazu geben. Ich habe ja die beiden C/SIDE Prüfungen gemacht und bestanden und hab eigentlich nur zwei interessante Fragen gehabt. Wenn man die Prüfung macht, muss man ja ausdrücklich die Bedingungen von MS akzeptieren, in denen steht, dass man keine Fragen veröffentlichen darf. Deswegen auch nur ganz abstrakt von mir beschrieben.
Die erste Frage hieß in etwa: wann entfernt man den Modified-Haken im Object Designer. Was mich wunderte war: die Antwort "gar nicht" stand nicht zur Auswahl. Durch Ausschlußverfahren konnte ich aber die richtige Antwort identifizieren.
Die zweite Frage zielte auf das Vorgehen ab, wenn man Änderungen, die man in seiner Entwicklungsdatenbank gemacht hat, jetzt in die Echt-DB des Kunden einspielen möchte. Ich weiß nicht, wie ihr das macht, aber MS schlägt vor: Serverdienst stoppen, DB kopieren, Objekte in Original-DB einspielen, Serverdienst starten.
Ich kann mir kaum vorstellen, dass das jemand so macht. Macht ihr das so?
Gruß
Tim
25. August 2007 12:46
bei einer nativen Datenbank ist das in Ordnung.
Dienst stoppen, damit kein anderer mehr an die DB kommt
kopieren um eine Sicherheitskopie zu haben
Dann mit dem Client direkt das DB-File öffnen (nicht erwähnt)
Objekte einspielen, wie sollen die Änderungen sonst auch darein kommen....
CLient wieder schließen (auch nicht erwähnt)
Serverdienst wieder starten, damit man wieder arbeiten kann.
was machst du denn anders?
Bei SQL einfacher:
Dafür sorgen, dass keiner mehr in der DB ist (z.B. Einzelbenutzermodus),
ist aber nur bei größeren Änderungen nötig, ein neuer Report geht auch so.
Backup machen, Objekte rein und ggf Einzelbenutzermodus wieder beenden.
Dienst stoppen, damit kein anderer mehr an die DB kommt
kopieren um eine Sicherheitskopie zu haben
Dann mit dem Client direkt das DB-File öffnen (nicht erwähnt)
Objekte einspielen, wie sollen die Änderungen sonst auch darein kommen....
CLient wieder schließen (auch nicht erwähnt)
Serverdienst wieder starten, damit man wieder arbeiten kann.
was machst du denn anders?
Bei SQL einfacher:
Dafür sorgen, dass keiner mehr in der DB ist (z.B. Einzelbenutzermodus),
ist aber nur bei größeren Änderungen nötig, ein neuer Report geht auch so.
Backup machen, Objekte rein und ggf Einzelbenutzermodus wieder beenden.
Zu Frage 26.
5. Juni 2008 08:54
Zu Frage 26.
Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField <=
In der Doku NA50_ENUS_DEVI_21.doc steht folgendes über die Propertys:
-CalcFields: Calculates automatically the information for FlowFields entered here.
-AutoCalcField: Determines whether or not the value in the FlowField
needs to be recalculated before the field is exported.
Nun hab eich ein Dilemma zwischen a und e. Hat jemand eine Idee?
Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField <=
In der Doku NA50_ENUS_DEVI_21.doc steht folgendes über die Propertys:
-CalcFields: Calculates automatically the information for FlowFields entered here.
-AutoCalcField: Determines whether or not the value in the FlowField
needs to be recalculated before the field is exported.
Nun hab eich ein Dilemma zwischen a und e. Hat jemand eine Idee?
1. Juli 2008 09:27
definitiv CALCFIELDS
Re: Prüfungsfragen
21. Mai 2010 15:32
Hallo,
ich bin gerade dabei mich auf die Prüfung MB7-516 vorzubereiten. In diesem Thread wurde schon einmal die Frage nach "optimistic concurrency" gestellt. Für alle die es interessiert habe ich hier die Anwort gefunden:
http://msdn.microsoft.com/en-us/library ... 80%29.aspx
Desweiteren hoffe ich das dieser Thread noch gelesen wird da ich bestimmt auch noch ein paar Fragen haben werde.
Gruß
Harald
ich bin gerade dabei mich auf die Prüfung MB7-516 vorzubereiten. In diesem Thread wurde schon einmal die Frage nach "optimistic concurrency" gestellt. Für alle die es interessiert habe ich hier die Anwort gefunden:
http://msdn.microsoft.com/en-us/library ... 80%29.aspx
Desweiteren hoffe ich das dieser Thread noch gelesen wird da ich bestimmt auch noch ein paar Fragen haben werde.
Gruß
Harald
Re: Prüfungsfragen
22. Mai 2010 17:37
bezugnehmend auf meinen letzten Eintrag stelle ich mal die ersten 2 Fragen ein.
1. What is meant by optimistic concurrency?
A. It means that the application locks the table as soon as possible to ensure that they will be
able to make the change.
B. It means that the application locks the record as soon as possible to ensure that they will be
able to make the change.
C. It means that the application does not lock the record before reading it for an update.
D. It means that the application does not lock the records at all hoping that no changes will be
made at the same time because of the efficient use of filters.
Hier müsste demnach Anwort D richtig sein.
2. You are required to create a report that will loop through all the customers and modify a small
percentage of the customer records and the sales order records for that customer.
Your senior developer has mentioned that you need to utilize the principals of optimistic
concurrency.
Your customer is a rather small client that will only be using the Microsoft Dynamics NAV Server
because they do not desire to use the Microsoft?SQL option. What does your senior developer
want you to do?
A. Filter as much as possible and do not lock the table since Microsoft Dynamics NAV will
automatically lock the table as needed for you.
B. Filter as much as possible and then wait until as late as possible to lock the table.
C. Lock all the tables as early as possible to ensure that you will be able to make your
modification.
D. Lock only the table that you need to as early as possible and then only lock the other tables as
you need them.
Hier würde ich die Antwort A nehmen.
Bin ich mit den Antworten auf dem richtigen Weg?
1. What is meant by optimistic concurrency?
A. It means that the application locks the table as soon as possible to ensure that they will be
able to make the change.
B. It means that the application locks the record as soon as possible to ensure that they will be
able to make the change.
C. It means that the application does not lock the record before reading it for an update.
D. It means that the application does not lock the records at all hoping that no changes will be
made at the same time because of the efficient use of filters.
Hier müsste demnach Anwort D richtig sein.
2. You are required to create a report that will loop through all the customers and modify a small
percentage of the customer records and the sales order records for that customer.
Your senior developer has mentioned that you need to utilize the principals of optimistic
concurrency.
Your customer is a rather small client that will only be using the Microsoft Dynamics NAV Server
because they do not desire to use the Microsoft?SQL option. What does your senior developer
want you to do?
A. Filter as much as possible and do not lock the table since Microsoft Dynamics NAV will
automatically lock the table as needed for you.
B. Filter as much as possible and then wait until as late as possible to lock the table.
C. Lock all the tables as early as possible to ensure that you will be able to make your
modification.
D. Lock only the table that you need to as early as possible and then only lock the other tables as
you need them.
Hier würde ich die Antwort A nehmen.
Bin ich mit den Antworten auf dem richtigen Weg?
Re: Prüfungsfragen
24. Mai 2010 20:05
hdannewitz hat geschrieben:Bin ich mit den Antworten auf dem richtigen Weg?
Ich sage es mal so: Ich hätte dieselben Antworten angekreuzt
Re: Prüfungsfragen
25. Mai 2010 10:35
Vielen Dank für die Antwort Timo.
Ich habe noch ca 40 Fragen in einem Tabellen Dokument ( Open Office ) von denen ich nicht weiß ob es orginal Fragen sind und ob ich diese hier einstellen soll / darf. Deshalb die Frage kann ich diese Tabelle jemanden zukommen lassen der meine Antworten überprüfen kann? Leider kann ich aktuell nur auf die Schulungsunterlagen, die Online Hilfe und die MSDN Seite zurückgreifen. Um diese Fragen sicher zu beantworten fehlt mir leider ( noch ) die Praxis.
Gruß Harald
Ich habe noch ca 40 Fragen in einem Tabellen Dokument ( Open Office ) von denen ich nicht weiß ob es orginal Fragen sind und ob ich diese hier einstellen soll / darf. Deshalb die Frage kann ich diese Tabelle jemanden zukommen lassen der meine Antworten überprüfen kann? Leider kann ich aktuell nur auf die Schulungsunterlagen, die Online Hilfe und die MSDN Seite zurückgreifen. Um diese Fragen sicher zu beantworten fehlt mir leider ( noch ) die Praxis.
Gruß Harald
Re: Prüfungsfragen
25. Mai 2010 10:42
Die Veröffentlichung von originalen Prüfungsfragen dürfte mit Sicherheit verboten sein, somit sollte man davon besser Abstand nehmen 
Re: Prüfungsfragen
25. Mai 2010 11:44
Deshalb die Frage: hat jemand Lust und Zeit meine Antworten zu prüfen. Wenn Ja bitte Nachricht an PN