Questions in development exam

guidorobben

Another quetion:

How many Indents can a report have.

A: 1
B: 10
C: 100
Unlimited

I choose B: 10. Don't know if it is correct

xrivo

Yes It's correct

jemmy

I remembered there was one question make me thinking hard while in the programming exam...

What is the use of setting permission in the report?
a)
b)
c)
d)

I forgot the choices.. but somehow I answered to protect user so that can't modify the protected tables?
:roll:

Let me know yours....

Jemmy

xrivo

FROM HELP
"
Use this property to give a database object extra permission to perform
some operations on one or more tables.

Sometimes the license file only gives you indirect permission to perform operations on some tables. Security permissions can also be used to give users only indirect permission to some tables. If you only have indirect permission to, for example, insert data into a particular table, you cannot insert data into this table from the standard user interface. You must use a database object that has been given extra permission to insert data into the table in question.

"

ngayee

I have failed the test. ](*,)
Anyone know that are the questions (when I retake) be the same as those I take at the first time??
Please help~~~

ngayee

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 (I think it is the answer)
some operations on one or more tables
c) .... (forgot)

When can change the fieldname in the table?
I think it should be anytime.

How many level of menusuite?

How to run a menusuite?

What properties need not be defined for menu item?
Ans: Name

List the trigger process order of Dataport.

How to call a code unit in another object?

Which is NOT a Form Trigger?
Ans: OnDisposeForm

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) ??

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……….

jemmy

My answer:

1) b.
2) you know
3) always
4) 12
5) can't
6) you know
7) OnInit,OnPreDataPort,OnPreDataItem,OnBefore/AfterExportRecord,OnPostDataPort
8) CODEUNIT.RUN
9) you know
10) a
11) a
12) c

anymore?


Jemmy

kenl

Hello Jemmy,

For question 4, how come there are 12 menu suite levels ?

MBS, Region, Country, 10 add on, Partner, Company.

It should be 15, right ?

ngayee

for the question 4, I remeber that the choice are:
a) 3
b) 13
c) (forgot)
d) unlimited

seems no 12 and 15.........

kenl

Hello,

If this is the case, then I think 13 would be the answer.

10 add on + Partner + Company + MBS(Default Level)= 13

Region, Country are special levels, I think

jemmy

Folks,

Yay! Today I just passed my Navision 4 C/Side Solution Development Exam \:D/

Ngayee, I just warn you that your questions are not related to Development Exam but related to Programming Exam.

Today I took the exam, phew, my brain was boiled!
I didn't even see your question there. [-X
Anyway, I have passed it haha.. so happy..

Hey Kenl, what kind of exam will you take?

Thanks to all of you and this forum... 8)

Cheers,

Jemmy

xrivo

Can you tell us mosre about this exam? I have to take this exam very soon ...thx

Lorenjans-free

Hello guys... Last friday I did the exam.. but I failed...
The following questions are that I found in Development Exam (4.0)... could someone ask them?

1)
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)...

2)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)...

3)How many dataitem at the maximum can we indent in a report?
a)10 (choose)
b)20
c)100
d)unlimited

4)Something with NODBC and multilanguage that I don't remember..

5)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)...

6)
Customer.FIND('+');
Customer.NEXT('-3');
Customer.FIND('=');

In table the following records are prensent: 1000,2000,3000,4000,5000,6000.The result of previous instructions is:
a)2000
b)3000 (choose)
c)4000
d)5000
e)6000

7)
Customer.FIND('+');
Customer.NEXT('3');
Customer.FIND('=');

In table the following records are prensent: 1000,2000,3000,4000,5000,6000.The result of previous instructions is:
a)2000
b)3000
c)4000
d)5000
e)6000 (choose)

8)What is the property used for multilanguage support?
a)Caption
b)CaptionML (choose)
c)...
d)...

9)
What of the following is it a File function?
a)WRITELINE
b)EXIST (choose)
c)BINARYMODE
d)...

10)
What of the following is it a File method?
a)WRITELINE
b)BINARYMODE
c)CREATE (choose)
d)...

11)
in a report What is trigger that fire before?
a)OnInitReport (choose)
b)OnPreReport
c)OnPreDataItem
d)OnPostDataItem

12)
in a report with request form what is trigger that fire before?
a)OnPreReport
b)OnOpenForm (choose)
c)...
d)...

13)
your customer have bought your product, but your salesperson have talk with him and have 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 (choose)
c)...
d)...

14) A subform
a) have always a table box
b) have usually a table box (choose)
c) ...
d) ...

15) 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 (choose)
c)...
d)...

16) for sumindexfield what do you use?
a) CALCFIELD
b) CALCSUM (choose)
c)...
d)...

17) In legacy system we have a field of 80 character. You must import from legacy system to Navision but the new field is of 50 character.What do you do, if the customer has said that it is ok if you import from 80 character field to 50 character field.
a) write code in dataport to convert (choose)
b) you must do nothing:navision do it for you during assignment
c)..
d)..

18) 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 (choose)
b)..
c)..
d)..

19) What is the equivalent of CREATETOTALS function in a report (more or less)?
a) TotalFields (choose)
b)..
c)..
d)..

20)
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 (choose)
c) the third one
d) all three codes go at same way

21) What it the key to compile an object from object design?
a) F11 (choose)
b) there isn't any key
c) ..
d) ..

And these are questions that my colleague have found in Exam. Also here, is there someone that can answer? Thanks..

22) What is the property to select a subform in a form?
a) SubFormID (choose)
b) SubForm
c) ..

23) When you modify a menusuite, what are the changes that remains?
a) it doesn't save them
b) at level of menu level
c) maintain all changes
d) only the last

24) 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) ..
c) ..
d) ..

25) Report with modifications. Which do you modify?
a) the new that is a copy of the original
b) the original
c) ..
d) ..

26) How do you launch a codeunit?
a) CODEUNIT.RUNMODAL(..)
b) CODEUNIT.RUN(..)
c) ..
d) ..

27) Report only batch. How do you launch it?
a) report.run
b) report.run(record)
c) report.run(tmpRecord)
d) ...

28) 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 onafterimportecord)

29) C/AL language programming. What is true?
a) it derives from microsoft c#
b) all objects have c/al
c) ..
d) ..

30) 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) ..

31) XMLPort. How do you calculate flowfield in automatic?
a) Calcfield
b) FieldCalc
c) AutoCalcField
d) ..

32) 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

33) You have a report and you print for all users the same value. Why? (it talk about dataitemtableview)
a) you haven't setted table filter
b) ..
c) ..
d) ..

34) 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

35)
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) ..
d) ..

36) What is the following property false?
a) Autoincremental
b) you can modify the table
c) ..
d) ..

37) 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) ..
c) You can't, because the table don't acccept function
d) you put function in the form

38)
IF ISCLEAR(WORDAPP)
CREATE (WORDAPP)

WordApp is an 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) ..

39) Complex data type. more functions in it does they slow down?

40) Max number of menu suite in a db?
a)1
b)10
c)15
d)20
e)unlimited

41) In a subform, what can you insert in it?
a) Tab menu
b) tablebox
c) picturebox
d) subform

42) 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

43) 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) ..
d) ..

44) 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

45) 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
….any idea? What is the solution, guys?

46) you are posting a journal. What are dimensions that are used?
a) journal
b) ledger
c) default

However excuse me for my english...
Bye
LorenjansFree

ngayee

Hi, all

Yes, the questions I posted is for Development I Exam.
Sorry if it made misunderstanding here.

Lorenjans-free, are the questions you posted for Development II Exam?

Lorenjans-free

Hi guys,

these are the question for Navision Development Exam code NA 40-222.. I think it is Development I.
SeeYa
LorenjansFree

voodoo

40-222 is Development II

kenl

Hello everyone,

First of all, I would like to clarify the Navision Exam. In MBS, Navision 4.0, there are only two exams for develpment.

1) Microsoft Navision C/SIDE Introduction Exam - Formerly known as Navision Programming (VUE Exam # NA 40-221)

2) Microsoft Navision C/SIDE Solution Development Exam - Formerly known as Navision Development (VUE Exam # NA 40-222)

Second, I would like to know, what is the difference between these two exams? What kinds of question will be asked in Introduction exam? What kind of questions will be asked in solution develpment exam? Those questions written in this forum are from Introduction or Solution development?

I will probably take both exams, but I will take Introduction first.

Thanks

jemmy

Folks,

Let me explain this to you...

NA 40-221 is equal to C/Side Introduction Exam / Navision Programming / Development I

NA 40-222 is equal to C/Side Solution Development / Navision Solution Development / Development II.

Hope this can clear your confusion...


Jemmy
____________________________

laurent

Hi Guys,

some question that I remmember for my 2 tentatives. I hope that will help

1: In a function with a record as parameter, how can you know witch filters have been applied to it ?
a: getfilters
b:impossible
c & d ???

2:Witch kind of files are not present on the client computer
a: stx
b:etx
c:fob (choose)
d:???


3: 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
d


4:Almost like the #3, If you have varText := varBigText;
a: error
b: varText will be truncated
c
d


5: outstream.write. What's an invalid target:
a: blob
b: ocx
c: report (choose)
d: automation


6: Rigth method to delete a large block of code :
{PRGLPD01 Start deletion
Code to delete…
…
PRGLPD01 End deletion}

7: why using SETPERMISSIONFILTER ?

kenl

Hello everyone,

I am confused with this two exams. What is the different between these two exams? What kind of question will be asked for each of the exam? :-k

1) Microsoft Navision C/SIDE Introduction Exam - Formerly known as Navision Programming (VUE Exam # NA 40-221)

2) Microsoft Navision C/SIDE Solution Development Exam - Formerly known as Navision Development (VUE Exam # NA 40-222)


Thanks.

laurent

1) Microsoft Navision C/SIDE Introduction Exam - Formerly known as Navision Programming (VUE Exam # NA 40-221)

I never try it but should be more focused on C# syntax and Navision 'base' objects.


2) Microsoft Navision C/SIDE Solution Development Exam - Formerly known as Navision Development (VUE Exam # NA 40-222)

C# syntax and 'advanced' Navision objects (journal, ledger, posting routine) and development methodology (project documentation, small case studies, installation on the client site,...)

I hope that clarify a little bit.

Laurent

tuman

Hi guys,
I'm having trouble on ODBC-Automation questions

For Example,
--Which is true for choosing between NODBC and C/FRONT
*NODBC faster than C/FRONT
*NODBC instructions are easier than C/FRONT
*NODBC can calculate FlowField but C/FRONTcan't


which should we use that allows users to access Navisin data trought ODBC
*Navision Server Option
*Navision Server and SQL server option
*SQL sever
*Visual Basic

xrivo

The correct answers are:

1.NODBC instructions are easier than C/FRONT
2.Navision Server and SQL server option (the question is here : On which platform we can use NODBC driver ?)

tuman

Thanks xrivo.

I want to share some questions: if it is possible, can you answer the questions?


1-)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-)??

2-)Which of the following characteristics Not result of the table relationship.
a-)Optimiz table records
b-)Validate entry
c-)Perform lookup other tables
d-)Automatically propagate changes from one table to other table.

3-)Which of the following functional area has more than one Master Table?
a-)General Ledger
b-)Fixed Assets
c-)Inventory
d-)Sales & receivables

4-)Which data type would be used for a field that has a Fildclass property of Flowfield and a Calc Formula method of sum?
a-)Date
b-)Boolean
c-)Decimal
d-)integer

5-)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

6-)which is not a flowfield type?
a-)Lookup
b-)Sum
c-)Validate
d-)count

7-)which is Cash Managments master table?
a-)Customer
b-)G/L Account
c-)Cash Account
d-)Bank Account

8-)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

9-)Wh,ch 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.

10-)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

11-)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

12-)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 tollbar
c-)F11,selecting Listmenu item or selecting the lookup button on tollbar
d-)F5,selecting Listmenu item or selecting the find button

13-)What is concatention?????
a-)Extracting a string from within another string
b-)creating a new str by alternately taking charecters 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

14-)Which is not a report type?
a-)Transaction
b-)Status
c-)Document
d-)Test

15-)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.

xrivo

Let's see:
1.c
2.a
3.b
4.c
5.b (I am not sure)
6.c
7.d
8.a
9.b
10.a
11.c
12.b
13.c
14.b
15.b

tuman

Thanks again xrivo, and I have more questions. can you answer these if is it possible?

16-)Report with cusomer 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 on prereport
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 on predataitem
DATAPORT
17-)the Autosave 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 periodiccally
c)insert records during on import

18-)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 frıom obj designer
c)xml ports will produce proper output

19-)which field in the xmlport description would be used to identify which table a tagname is equvalent to
a)Table Name
b)TagType
c)Tagname
d)source type

20)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 referance
c)the parameter is passed by referance rather than value

Angelo

Two days ago I have passed Navision Solution Development Exam. I want to share a little questions.Maybe it can prepare you more advance who have not taken exam yet.

1.How can an element of object can 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

2.What file is not found (has relation with multilanguage) in client folder?
a)*.ETX
b)*.STX
c)*.CHM
d)*.FDB

3.What Internal document if we add field in table?
a)Documentation trigger
b)Project Log
c)Field Description
d)Code Command

4.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)

5.What is the not Valid target of WRITELINE?
a)BLOB
b)File
c)Report
d)Automation

6.A question about : KEYGROUPS of report if customer have report only run at end of year

7.How to handle locktable for small customer who use Navision Database Server

xrivo

I hope that it's correct

16.a
17.c
18.a
19.d
20.c

1.c
2.d(language folder (ENU))
3.a
4.d (and c)
5.c
6.

thancom

(*,) ](*,) ](*,)

voodoo

Folks,

Yesterday I had an exam and unfortunately my grade was Fail
I must go back to some specific question:

3) if u creat 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 u creat 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

... and finally conclusion was

thank u Urmas i think we have the final answers now

(6and 4)

but, I think that those answers are wrong....
In Navision C/AL script, on page 25 (2.3 String data types) for Text data type is:

A text is a string of 0 to 250 characters. The length of a text is the number of characters in it. To find the amount of storage a text takes up, add one to the length and round up to the nearest four. Thus an 8-character text takes up 12 bytes (1 + 8 rounded up to the nearest 4).

... and the correct answer for textmode(true) is:
1000 = 4 bytes(every char is 1 byte) + 1 = 5
and the rounded up to the nearest 4 = 8 bytes!?
and off course, for texmode(false) is 4 bytes.

cheers