Exam : Microsoft MB4-213

[test4actual]

1.There are important differences between a normal level and a detail level. What statements are true about a detail level?
A.The detail level must always be implemented using a spreadsheet control.
B.The detail level is not always implemented using a spreadsheet control.
C.More than one record can be retrieved from the database and displayed at one time.
D.Only one copy of a record is displayed from the database. The user must commit or abandon changes
before moving to another record.
Correct:A C

2.When adding new tables to the Solomon database, which restrictions must you follow?
A.Table names must not contain spaces.
B.Table names must not begin with a number.
C.Table names can not be longer than 8 characters
D.Table names must contain a special character.
Correct:A B

3.Which property of a control is used to tell the Kernel that it is a key field?
A.default
B.level
C.tag
D.DBNav
Correct:B

4.The Solomon kernel is designed to automatically manage the unique identity of records in a detail level by which of the following methods?
A.By the tab sequence of the fields in the spreadsheet.
B.By locating the definition of the primary index on the table in the database and then automatically
enforcing that rule in the user interface.
C.By the ordinal position in which the user entered the records into the spreadsheet.
D.By one or more ey?fields which are visible in the spreadsheet.
Correct:C D

5.Which statement is true about Record Maintenance?
A.This utility program actually creates new tables in the Solomon database.
B.This utility is used to define the following properties of a table: Name, Fields and Indexes.
C.This utility allows a developer to define the names of new tables. It does not actually create tables in the
Solomon database.
D.This utility reads the actual database schema from the Solomon database and displays all actual tables in that database except for MS SQL system tables.
Correct:C

6.What utility can be used to create text files which contain VB Code and SQL statements that will create a table? The extensions of the two files created will be "DH" and "CRT".
A.Generate Schema
B.Record Maintenance
C.Parent.exe
D.Field Maintenance
Correct:A

7.Occasionally, data displayed in a field on a window will appear in a different format than what is shown when viewed directly from the database. What property can be checked and/or changed so the data is converted and displayed with the correct format?
A.Fieldclass
B.Fieldname
C.Default
D.Mask
Correct:A D

8.When the Solomon application is launched, which main programs are started
A.Visual Basic
B.Parent.exe
C.Kernel
D.Customization Manager
Correct:B C

9.In order for the Kernel to be able to manage records in the database, data must be broken into logically related groups. What term is used to refer to these groups?
A.data groups
B.related records
C.levels
D.groupies
Correct:C

10.What conditions would require a SetAddr call?
A.If the Solomon Kernel will be responsible for managing the buffer as the primary table for a level.
B.If controls for displaying and updating fields of the buffer are needed.
C.If you wish to expose the variable for access through Customization Manager.
D.If you wish to expose the variable for access through Record Maintenance.
Correct:A B C

11.What type of container object must be used to contain the data controls and grid controls for a detail level?
A.Standard Visual Basic Frame control
B.Standard Visual Basic Tab control
C.SAF Container control
D.Any container type control can be used
Correct:B

12.Once the user chooses a company from the Login screen they will be connected to two databases, an application and system database. What type of information is contained in the System Database?
A.Product Registration
B.Accounting Information
C.Customizations
D.Users and Groups
Correct:A C D

13.When a user moves to a line in a grid, the kernel triggers a LineGotFocus event in the Solomon Tools for Visual Basic program. What best describes the purpose of the information that the kernel passes to this event via the MaintFlg parameter?
A.The value indicates the status of the line the user just moved to.
B.The value indicates the status of the line the user just left.
C.The value indicates the status of the logical level the grid is associated with.
D.The value indicates whether the user interface is currently in "gird view" or "form view".
Correct:A

14.What is true when working with a spreadsheet control?
A.It must be placed into a container.
B.It must be the same size as the container.
C.The Kernel will format the control at run time.
D.The name property of the spreadsheet control must match the name used in the DetailSetup call.
Correct:A C D

15.Solomon uses a standard naming convention for many files used during development. Which file extension is used for SQL script files that contain CREATE INDEX statements?
A.CRT
B.CRX
C.CRP
D.CSV
Correct:B

16.Although these are not requirements, what are common programming practices when starting a new Tools for Visual Basic project?
A.Name the VBP file and the FRM file the same as the seven character screen number for the program being created.
B.Do not overwrite the template files.
C.Save the VBP file and the FRM file in the newly created development directory.
D.Contact Microsoft Business Solutions to request ID numbers and table names for any new tables you will be adding to the database.
Correct:A B C

17.By default, setting this property will tell the Kernel to validate any data entered into a field and force the user to only enter valid values.
A.DBNav
B.FieldName
C.PV
D.Default
Correct:C

18.How many table joins is the DetailSetup call designed to handle?
A.1
B.2
C.3
D.4
Correct: D

19.When working with unbound controls, which statements are true?
A.Unbound controls should never have a value in their level property to associate them with a level.
B.Standard VB controls do not support standard Solomon functionality, such as F3 lookups.
C.Unbound controls are bound to a field in the database.
D.Unbound controls must be attached or associated with a buffer variable.
Correct:B D

20.When the user hits the F3 function key on a field that has a PV property, where does the kernel get the information needed to determine what should be included in the Possible Values window?
A.The Kernel executes an sp_columns SQL stored procedure to get the list of fields of the tables used in the stored procedure named in the PV property of the control
B.The Kernel reads the PVREC.csv file in the DB\CVS fold of the Solomon install directory which contains the definition of the possible values window.
C.The Kernel retrieves a record of the PVREC table in the Solomon system database which contains the definition of the possible values window.
D.The Kernel does not automatically create the possible values window. It's the VB programmer's responsibility to create the window and display that window when the F3 event fires
Correct:C