显示标签为“FM0-305”的博文。显示所有博文
显示标签为“FM0-305”的博文。显示所有博文

2013年9月25日星期三

FM0-305 dernières questions d'examen certification FileMaker et réponses publiés

Participer au test FileMaker FM0-305 est un bon choix, parce que dans l'Industire IT, beaucoup de gens tirent un point de vue que le Certificat FileMaker FM0-305 symbole bien la professionnalité d'un travailleur dans cette industrie.

Ajoutez le produit de Pass4Test au panier, vous pouvez participer le test avec une 100% confiance. Bénéficiez du succès de test FileMaker FM0-305 par une seule fois, vous n'aurez pas aucune raison à refuser.

Est-ce que vous vous souciez encore pour passer le test FileMaker FM0-305? Pourquoi pas choisir la formation en Internet dans une société de l'informatique. Un bon choix de l'outil formation peut résoudre le problème de prendre grande quantité de connaissances demandées par le test FileMaker FM0-305, et vous permet de préparer mieux avant le test. Les experts de Pass4Test travaillent avec tous efforts à produire une bonne Q&A ciblée au test FileMaker FM0-305. La Q&A est un bon choix pour vous. Vous pouvez télécharger le démo grantuit tout d'abord en Internet.

Code d'Examen: FM0-305
Nom d'Examen: FileMaker (Developer Essentials for FileMaker 11)
Questions et réponses: 115 Q&As

Le Pass4Past possède une équipe d'élite qui peut vous offrir à temps les matériaux de test Certification FileMaker FM0-305. En même temps, nos experts font l'accent à mettre rapidement à jour les Questions de test Certification IT. L'important est que Pass4Test a une très bonne réputation dans l'industrie IT. Bien que l'on n'ait pas beaucoup de chances à réussir le test de FM0-305, Pass4Test vous assure à passer ce test par une fois grâce à nos documentations avec une bonne précision et une grande couverture.

FM0-305 Démo gratuit à télécharger: http://www.pass4test.fr/FM0-305.html

NO.1 Which two features require indexing in order to work? (Choose two.)
A. List function
B. Dynamic subsummary reports
C. Auto-complete using existing values
D. Dynamic value lists based on FileMaker tables
E. Add Leading Group by <field name> in Table View
Answer: CD

FileMaker   FM0-305   FM0-305 examen   FM0-305 examen

NO.2 Given the following relationship graph:
Without inspecting the data, what is known about this database?
A. There are no records in the Event table at this time.
B. The Event table occurrence references a table from an external ODBC data source.
C. There can be zero or one, but no more than one, Event record related to any Task record.
D. The corner arrows indicate all three table occurrences reference tables from external data sources.
E. From a layout based on the Event table occurrence, a portal could be drawn showing both related Task
and Volunteer data.
Answer: E

FileMaker   certification FM0-305   certification FM0-305   FM0-305   FM0-305

NO.3 Given a text field myText that contains "<color>blue</color>", which formula extracts the word "blue"
from the field?
A. Filter (myText ; "color")
B. MiddleWords (myText ; 2)
C. PatternMatch (myText ; "blue")
D. Middle ( myText ; Position ( myText ; "blue" ; 1 ; 1 ) ;4)
Answer: D

certification FileMaker   certification FM0-305   certification FM0-305   FM0-305

NO.4 Given a text field Full Name, Auto-Enter by Calculated value has been selected in field options, using
the following formula:
name First & " " & Name Last
The developer then disables (unchecks) the option Do not replace existing value of field (if any).
for which two cases will the results of the specified formula be inserted into the field Full Name? (Choose
two.)
A. when the record is first created
B. when the field Full Name itself is modified
C. only when the field Full Name was previously empty
D. when either of the fields Name First or Name Last are modified
E. when the field Full Name itself is modified and the record is committed
Answer: AD

FileMaker   FM0-305   certification FM0-305   FM0-305

NO.5 Which three FileMaker Pro 11 objects will display data contents even when unrelated to the current
layout's table occurrence? (Choose three.)
A. Merge variable
B. Indexed Timestamp field
C. A Text field from a shadow table
D. Globally stored Calculation field
E. Globally stored Number field placed in a portal
F. A Container field defined with the Store as reference only option enabled
Answer: ADE

FileMaker examen   FM0-305   FM0-305 examen   certification FM0-305

NO.6 Which three are directly selectable options in the Validation tab of the field options dialog in FileMaker
Pro 11? (Choose three.)
A. Existing value
B. Member of value list
C. Strict data type: Integer
D. Strict data type: Time of Day
E. Strict data type: Alphanumeric
F. Minimum number of characters
Answer: ABD

certification FileMaker   FM0-305 examen   FM0-305   FM0-305 examen   FM0-305

NO.7 What is the maximum number of recursive calls that can be made utilizing a custom function in
FileMaker Pro 11 Advanced?
A. 10,000
B. 32,000
C. 50,000
D. 64,000
Answer: C

FileMaker examen   certification FM0-305   FM0-305   FM0-305   FM0-305 examen

NO.8 Consider two FileMaker files, Collection and Item, where tables from Item are included in the
Relationships Graph of Collection.
Which method will preserve all functionality in the Relationships Graph of Collection after renaming the
Item file to Artifact?
A. delete referenced Item table occurrences in the Relationships Graph for Collection and recreate them
for Artifact
B. click the Repair Reference button in the Relationships Graph for Collection and reset the file path
C. choose File > Manage > External Data Sources... for Collection and reset the file path
D. select referenced Item table occurrences in the Relationships Graph for Collection and right-click to
choose Rename File Source...
E. choose the File > Recover... menu in FileMaker Pro 11 Advanced, select the Collection file, then
choose Repair References under Advanced Recover Options
Answer: C

certification FileMaker   FM0-305   FM0-305 examen   FM0-305 examen

NO.9 What is the theoretical maximum record count in a FileMaker Pro 11 file?
A. 100 million records
B. 4 billion records
C. 8 trillion records
D. 64 quadrillion records
E. 128 quadrillion records
Answer: D

FileMaker examen   certification FM0-305   certification FM0-305   FM0-305 examen

NO.10 Which two statements are true about field indexing in FileMaker Pro 11? (Choose two.)
A. Calculation fields cannot be indexed.
B. Indexing improves the speed at which sorts are performed.
C. To establish a relationship between two fields, both fields are required to be indexed.
D. A field must be indexed in order for Auto-complete using previously entered values to function.
E. Minimal indexing indicates that either the value index or the word index has been created, but not both.
Answer: DE

FileMaker examen   FM0-305   certification FM0-305

NO.11 A new database is created with two tables, Client and Contracts. The only modification made on the
Relationships Graph is to establish a relationship between them which is set to delete related records in
Contracts when a record in Client is deleted.
What happens when the Client table occurrence is deleted from the Relationships Graph?
A. Since it is the only occurrence of the Client table on the graph, it can not be deleted.
B. Any records in the Contracts table that were related to matching Client records are deleted.
C. The formula in the calculation field Name Full (defined as Name First & " " & Name Last) will be broken.
D. Any records in the Contracts table that were related to matching Client records will have values in the
Client ID field deleted.
Answer: C

FileMaker examen   FM0-305   certification FM0-305

NO.12 Which two statements are true about FileMaker Pro 11 relationships? (Choose two.)
A. A relationship defined with an X (cross product) will only include records with non-matching match field
values.
B. Valid relationships can include unindexed match fields.
C. The % (contains) operator can be used for join criteria that include one unindexed match field.
D. When editing match fields for a relationship, no more than 16 pairs of join criteria can be used.
E. A relationship defined with an X (cross product) match will allow the Delete related records in this table
when a record is deleted in the other table option.
Answer: BE

FileMaker   certification FM0-305   FM0-305   certification FM0-305

NO.13 Which script trigger could provide the functionality to prevent invalid data from being committed while
allowing the ability to revert the record?
A. OnObjectSave
B. OnObjectExit
C. OnObjectModify
D. OnObjectValidate
Answer: D

FileMaker examen   FM0-305   FM0-305   certification FM0-305   FM0-305 examen

NO.14 Given the following Relationships Graph for a FileMaker 11 database, where Employee, Manager, and
Trainer are all table occurrences sharing the same source table:
Assuming the relevant fields also exist in these tables, which two sets of data can be shown in portals
without modifying the graph? (Choose two.)
A. a portal of trainers that have taught their own manager
B. a portal of students that have not enrolled in a class
C. a portal showing a non-repeating list of courseware titles taught by a trainer
D. a portal of the classes that have been attended by a trainer's direct reports
E. a portal of classes in which a manager enrolled with one or more of the manager's direct reports
Answer: CD

FileMaker   FM0-305   certification FM0-305   certification FM0-305   FM0-305 examen

NO.15 Consider a FileMaker Pro 11 database with the following tables and fields:
Assuming only the above relationships between table occurrences, using sorting if necessary, which two
actions can be performed? (Choose two.)
A. create a value list that shows all Invoices for a chosen Customer
B. create a value list on a Product layout which displays all Customers
C. find all of the Customers who have ever ordered a specific Product
D. create a portal to display each Product that has been ordered by a Customer
E. display all records from the Customer table in a portal on a layout for an Invoice Item record
Answer: BE

FileMaker   FM0-305   certification FM0-305

NO.16 A Text field called FirstLast in FileMaker Pro 11 is set to auto-enter the following formula:
FirstName & LastName.
FirstName and LastName are Text fields in the same table. The option Do not evaluate if all referenced
fields are empty is unchecked. The option Do not replace existing value of field (if any) is checked.
Under which two circumstances will the value of the calculation be inserted into the FirstLast field?
(Choose two.)
A. a record is first created
B. a user selects the menu item Records > Relookup Field Contents
C. each time the value of the FirstName or LastName field is modified
D. any field value on the record is modified and the FirstLast field is empty
E. the FirstName or LastName field is modified and the FirstLast field is empty
Answer: AE

FileMaker   FM0-305 examen   FM0-305   FM0-305 examen

NO.17 What is the maximum number of files that can be hosted on FileMaker Server 11 Advanced?
A. 100
B. 125
C. 250
D. 999
Answer: B

FileMaker examen   FM0-305   FM0-305 examen   FM0-305 examen   FM0-305   FM0-305 examen

NO.18 Which statement is true about supplemental fields added to a table occurrence based on an External
ODBC Data Source that uses MySQL?
A. These fields may be indexed.
B. All non-text data types are converted to text.
C. These fields may only be of type Summary or Calculation.
D. These fields will be added to the table definitions within MySQL.
E. These fields will be lost if the schema of the MySQL table is changed and then the Sync button in the
FileMaker Pro Manage Database dialog is used.
Answer: C

FileMaker   FM0-305 examen   certification FM0-305

NO.19 Given the following relationship graph:
Without inspecting the data, what can be assumed about this database?
A. In the Event table, the Event ID has no index.
B. For each Task record there will be exactly one related Volunteer record.
C. Each record in the Task table will represent a unique combination of Volunteer ID and Event ID.
D. The relationship between Task and Event will not allow the Allow creation of records... nor the Delete
related records... settings to be enabled for the Event table.
Answer: A

FileMaker   FM0-305   certification FM0-305   certification FM0-305

NO.20 A table in a FileMaker Pro 11 database has a field CompanyName of type Text. The following field
validation options are set for this field:
Validate data in this field only during data entry
Allow user to override during data entry
Require not empty
Display custom message if validation fails
A user imports a set of records into this table. Some records have no value in the CompanyName field.
What will occur?
A. All of the records will be imported. No error message will be displayed.
B. The user will see the custom error message, but the import will continue if the user overrides the error.
C. All records with a value for CompanyName will be imported. The user will also see the specified
custom error message.
D. The user will see the custom error message, but in the case of an import, overriding the error is not
allowed and no records are imported.
E. All records with a value for CompanyName will be imported. The user will see an error dialog from the
FileMaker Pro application stating that some records could not be imported due to errors, along with a
count of those records.
Answer: A

FileMaker   FM0-305   certification FM0-305   FM0-305   FM0-305 examen

Le temps est tellement précieux dans cette société que une bonn façon de se former avant le test FileMaker FM0-305 est très important. Pass4Test fait tous efforts à assurer tous les candidats à réussir le test. Aussi, un an de mise à jour est gratuite pour vous. Si vous ne passez pas le test, votre argent sera tout rendu.

2013年7月28日星期日

Les meilleures FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301 examen pratique questions et réponses

Beaucoup de travailleurs dans l'Industrie IT peut obenir un meilleur travail et améliorer son niveau de vie à travers le Certificat FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301. Mais la majorité des candidats dépensent beaucoup de temps et d'argent pour préparer le test, ça ne coûte pas dans cette société que le temps est tellement précieux. Pass4Test peut vous aider à économiser le temps et l'effort pendant le cours de la préparation du test FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301. Choisir le produit de Pass4Test particulier pour le test Certification FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301 vous permet à réussir 100% le test. Votre argent sera tout rendu si malheureusement vous ne passez pas le test.


Pass4Test peut vous fournir un raccourci à passer le test FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301: moins de temps et efforts dépensés. Vous trouverez les bonnes documentations de se former dans le site Pass4Test qui peut vous aider efficacement à réussir le test FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301. Si vous voyez les documentations dans les autres sites, c'est pas difficile à trouver qu''elles sont venues de Pass4Test, parce que lesquelles dans Pass4Test sont le plus complété et la mise à jour plus vite.


Code d'Examen: FM1-306

Nom d'Examen: FileMaker (Developer Essentials for FileMaker 12 Beta Exam)

Questions et réponses: 198 Q&As

Code d'Examen: FM0-307

Nom d'Examen: FileMaker (Developer Essentials for FileMaker 12 Exam)

Questions et réponses: 198 Q&As

Code d'Examen: FM0-306

Nom d'Examen: FileMaker (Developer Essentials for FileMaker 12)

Questions et réponses: 198 Q&As

Code d'Examen: FM0-305

Nom d'Examen: FileMaker (Developer Essentials for FileMaker 11)

Questions et réponses: 115 Q&As

Code d'Examen: FM0-304

Nom d'Examen: FileMaker (Developer Essentials for FileMaker 10)

Questions et réponses: 191 Q&As

Code d'Examen: FM0-301

Nom d'Examen: FileMaker (Filemaker7 Developer essentials exam)

Questions et réponses: 120 Q&As

Est-ce que vous vous souciez encore pour passer le test FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301? Pourquoi pas choisir la formation en Internet dans une société de l'informatique. Un bon choix de l'outil formation peut résoudre le problème de prendre grande quantité de connaissances demandées par le test FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301, et vous permet de préparer mieux avant le test. Les experts de Pass4Test travaillent avec tous efforts à produire une bonne Q&A ciblée au test FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301. La Q&A est un bon choix pour vous. Vous pouvez télécharger le démo grantuit tout d'abord en Internet.


Pass4Test vous promet de vous aider à passer le test FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301, vous pouvez télécharger maintenant les Q&As partielles de test FileMaker FM1-306 FM0-307 FM0-306 FM0-305 FM0-304 FM0-301 en ligne. Il y a encore la mise à jour gratuite pendant un an pour vous. Si vous malheureusement rater le test, votre argent sera 100% rendu.


FM0-301 Démo gratuit à télécharger: http://www.pass4test.fr/FM0-301.html


NO.1 You want to sort related records within a portal in a FileMaker Pro 7 database. What two methods
allow you to do this? (Choose two.)
A. select Sort by in the Edit Value List dialog
B. select Sort records in the Edit Relationship dialog
C. select Sort portal records in the Portal Setup dialog
D. select Sort records for the portal's table occurrence in the Specify Table dialog
E. select the Records>Sort Records... menu item, then select the portal's table occurrence in the Sort
Records dialog
Answer: BC

FileMaker   FM0-301 examen   FM0-301 examen   certification FM0-301   certification FM0-301   FM0-301

NO.2 Consider a FileMaker Pro 7 database with the following tables and fields:
Using only Cartesian (cross or x ) relationships between occurrences of these tables, sorting if necessary,
which two actions can be performed? (Choose two.)
A. determine the mode of the order amount
B. determine the date of the most recent order
C. display all records from the Customer table in a portal
D. create a value list that shows all orders for a chosen customer
E. create a portal to show one record for each product that has ever been ordered
Answer: BC

FileMaker   FM0-301   certification FM0-301

NO.3 Which three statements are true about field indexing in FileMaker Pro 7? (Choose three.)
A. Indexing improves the speed at which finds are performed.
B. Value lists require at least one of any field they reference to be indexed.
C. To establish a relationship between two fields, both fields are required to be indexed.
D. A value index, used in establishing relationships, stores up to 60 primary characters or digits per
return-delimited line.
E. Using Unicode or ASCII as the default language by which a field is indexed causes sorts on that field to
be case sensitive.
Answer: ABE

FileMaker   FM0-301   FM0-301   certification FM0-301   FM0-301 examen

NO.4 Which three are affected by changing the behavior of a field to navigate to the next field using Tab,
Enter and Return in FileMaker Pro 7? (Choose three.)
A. exiting a record
B. executing a find
C. scripted navigation
D. navigating tab order
E. continuing a paused script
Answer: ABE

FileMaker   FM0-301   FM0-301   certification FM0-301

NO.5 If a field in FileMaker Pro 7 has been set to validate Always, which three actions will trigger validation
on that field? (Choose three.)
A. importing data into that field
B. exporting data from that field
C. editing data in the field using Instant Web Publishing
D. clicking into the field, then immediately exiting the field
E. attempting to change the value of the field using a Set Field[ ] script step
Answer: ACE

FileMaker   certification FM0-301   FM0-301   FM0-301 examen   FM0-301 examen

NO.6 Click the Exhibit button.
On a FileMaker Pro 7 layout based on the table occurrence Teachers, a portal is designed to show all the
students based on the table occurrence Students. Which two statements are true about adding a new
student in the portal? (Choose two.)
A. The table occurrence Students must be directly connected to Teachers.
B. All the relationships from Teachers to Students must be set to be able to create records.
C. Only the relationship between Enrollment and Students must allow creation of related records.
D. All the relationships between the table occurrence Teachers and the table occurrence Students must
use the = operator.
Answer: CD

FileMaker   FM0-301 examen   FM0-301   FM0-301

NO.7 Click the Exhibit button.
Given the FileMaker Pro 7 Relationships Graph shown in the exhibit, which table occurrence should be
assigned to a layout that contains a portal that shows all students for all of a teacher's classes?
A. Classes
B. Advisors
C. Teachers
D. Enrollment
Answer: C

certification FileMaker   FM0-301 examen   FM0-301 examen   certification FM0-301

NO.8 What is the maximum number of characters that can be entered or imported into a text field in
FileMaker Pro 7?
A. 64 thousand
B. 1 million
C. 1 billion
D. 1 trillion
E. Number of characters is limited only by disk space.
Answer: C

FileMaker examen   certification FM0-301   FM0-301   FM0-301   FM0-301

NO.9 What is the maximum number of files that can be hosted on FileMaker Server 7?
A. 125
B. 250
C. 350
D. 500
E. The number is limited only by server hardware.
Answer: A

FileMaker   FM0-301   certification FM0-301   FM0-301 examen   certification FM0-301   certification FM0-301

NO.10 Which three statements about field validation are true in FileMaker Pro 7? (Choose three.)
A. Fields can only be validated by a single criterion.
B. Field validation warnings may be triggered by scripts.
C. Users can be prevented from overriding the validation warning.
D. Users can be presented with a specific message that will see when a field fails validation.
E. A script can be specified to run when manually entered field data fails validation.
Answer: BCD

FileMaker examen   FM0-301 examen   FM0-301   FM0-301   FM0-301

NO.11 Consider two FileMaker Pro 7 files, Alpha and Beta, where a table from Beta appears as an externally
referenced table occurrence on Alpha's Relationships Graph. Which three statements are true? (Choose
three.)
A. Layouts in Alpha can display data from Beta.
B. Alpha can contain multiple valid file references to Beta.
C. It is impossible to lock records in both Alpha and Beta simultaneously.
D. Layouts from Beta cannot be displayed in the same window as layouts from Alpha.
E. A table occurrence from Beta is required on Alpha's Relationships Graph in order to call a script in Beta
from Alpha.
Answer: ABD

certification FileMaker   certification FM0-301   certification FM0-301   FM0-301

NO.12 Which two statements about relationships are true in FileMaker Pro 7? (Choose two.)
A. The > operator only works using numeric match fields.
B. You can build a relationship using multiple match fields.
C. It is possible to create a valid relationship where one match field is unindexed.
D. A table occurrence must be connected to at least one other table occurrence.
E. When enabling the option, "Allow creation of records in this table via this relationship", only =, >=,
<= will properly populate match keys.
Answer: BC

FileMaker   FM0-301   FM0-301 examen   FM0-301   FM0-301 examen

NO.13 A database has two tables, Planet and Moon. Moons are related to a single planet and their
relationship is set to delete related records in the Moon table when a Planet record is deleted. Which
two things happen when the Planet table is deleted from the Tables tab of the Define Database dialog?
(Choose two.)
A. All data in the Planet table are deleted.
B. All records in the Moon table are deleted.
C. All records in the Moon table remain unaffected.
D. All records in the Moon table are deleted if the option to "Also remove occurrences of these tables in
the graph" was selected when deleting the Planet table.
E. All table occurrences of both Planet and Moon tables are removed if the option to "Also remove
occurrences of these tables in the graph" was selected when deleting the Planet table.
Answer: AC

certification FileMaker   FM0-301 examen   certification FM0-301   FM0-301 examen   FM0-301

NO.14 Which statement is true in FileMaker Pro 7?
A. The Save record changes automatically layout option does not apply to users with [Full Access]
privileges.
B. On a layout by layout basis, you can specify whether record changes made in Browse mode will be
saved automatically.
C. On a layout by layout basis, you can specify whether changes made to the layout when exiting Layout
mode will be saved automatically.
D. If the Save record changes automatically option has been turned off for a layout, then users will be
prompted to save their changes only when exiting the layout.
Answer: B

FileMaker   FM0-301   FM0-301   FM0-301   FM0-301   FM0-301

NO.15 Consider the return delimited data in the Contact field of a FileMaker Pro 7 database are:
John Smith
Mary Jones
Julie Hyde
Which three formulas could be used to extract the string Mary Jones from Contact? (Choose three.)
A. Middle (Contact ; 12 ; 10)
B. MiddleValues (Contact ; 2)
C. MiddleWords (Contact ; 3 ; 2)
D. MiddleWords (Contact ; 3 ; 4)
E. MiddleValues (Contact ; 2 ; 1)
Answer: ACE

FileMaker   FM0-301 examen   FM0-301   FM0-301

NO.16 Given the following formula:
If( DayOfWeek (myDate) = 3 and (myField = 13 or myField = 23) ;
Get (FoundCount) ; Get (TotalRecordCount))
Which two statements are true? (Choose two.)
A. If myField is 13, the test to see if myField = 23 will not be performed.
B. If DayOfWeek(myDate) returns 6, neither of the tests involving myField will be performed.
C. If DayOfWeek(myDate) returns 3 and myField returns 8, then this formula will return the total number
of records in the found set.
D. Regardless of whether the test is true or false, both Get(FoundCount) and Get(TotalRecordCount) will
be evaluated during execution of this formula.
Answer: AB

FileMaker examen   certification FM0-301   FM0-301 examen   certification FM0-301

NO.17 A number field in FileMaker Pro 7 called AmountPaid is set to auto-enter the following formula:.
The Do not replace existing value of field (if any) option is unchecked.
Which statement is true?
A. The calculation will only be evaluated the first time a value is entered into AmountPaid .
B. A user will not be able to manually edit the field once the calculation has been evaluated.
C. If the value in the AmountDue field is changed, the AmountPaid field will be re-evaluated.
D. The calculation will prevent a user from entering an incorrect value into the AmoundPaid field.
Answer: C

FileMaker   FM0-301   FM0-301 examen   FM0-301   FM0-301   certification FM0-301

NO.18 Click the Exhibit button.
You have a FileMaker Pro 7 layout based on the table occurrence of Classes. You have a portal showing
records from the table occurrence Students.
What happens if you place the field Students::Name into the portal?
A. The field displays <Field Missing> .
B. The field displays an enrolled student's name in each row of the portal.
C. The field displays the first matching student's name in every portal row.
D. The field displays an enrolled student's name in each row of the portal only if the student name is
calculated in the Enrollment table.
Answer: B

FileMaker   certification FM0-301   certification FM0-301

NO.19 Click the Exhibit button
Consider a FileMaker Pro 7 database with two tables called Salesperson and Order, and a relationship
between the two tables based on a SalespersonID field. The relationship is configured as shown in the
exhibit. There is a layout called Salesperson Detail, based on the Salesperson table occurrence, with a
portal showing Order records via the above relationship.
Which three statements are true? (Choose three.)
A. Deleting a Salesperson record also deletes all related Order records.
B. It is possible to create new Order records by importing data into the Salesperson table.
C. It is possible to create new Salesperson records by importing data into the Order table.
D. Users may create new Order records by entering data into the portal on the Salesperson Detail layout
E. It is possible to create a new Salesperson record using a Set Field [ ] script step in a script that runs in
the context of the Order table.
F. It is possible to create a new Salesperson record by typing into a related salesperson field displayed on
a layout that is based on the Order table.
Answer: DEF

FileMaker   FM0-301   FM0-301 examen   FM0-301 examen

NO.20 Click the Exhibit button.
You want to build a FileMaker Pro 7 database that models a business organizational chart. One person
may manage no one or many people. One person may be managed by at most one other person.
You want to build the system in such a way that a single layout showing information about a person can
display both the name of the current person's manager (if any) and the names of all people managed by
the current person.
What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to
construct the layout?
A. one
B. two
C. three
D. four
Answer: A

FileMaker examen   FM0-301   certification FM0-301   FM0-301 examen