FILEMAKER Set 1

Question - 15 Maximum mark : - 28

Home
All Exams
FILEMAKER Online Mock Tests
FILEMAKER Set 1

A table in a FileMaker 13 solution has a text field CompanyName. 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?

All of the records will be imported, No error message will be displayed. ✘ The user will see the custom error message, but the import will continue if the user overrides the error. ✘ All records with a value for CompanyName will be imported. The user will see the specified custom message. ✘ 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 couldnot be imported due to errors, along with a count of those records. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A new solution is created with Iwo 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?

Since it is the only occurrence of the Client table on the graph, it cannot be deleted. ✘ Any records in the Contracts table that were related to matching Client records are deleted. ✘ The formula in the calculation field Name Full (defined as Name First & " & Name Last) will be broken. ✘ Any records in the Contracts table that were related to matching Client records will have values in the Client ID field deleted. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement is true about the Filter Portal Records feature in FileMaker Pro 13?

The portal filter formula must refer to at least one field in the immediately related table. ✘ The feature requires one or more additional relationships to be added to the Relationships Graph. ✘ The portal filter formula may not refer to any globally stored fields, summary fields, or unstored calculation fields. ✘ There can be one unique filter formula applied for each portal state (Normal State, In Focus, Hover, or Pressed). ✔ Aggregate functions (e.g., Sum, Count) based on the portal's relationship will not be affected by the portal's filter formula. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Given the following Relationships Graph for a FileMaker are all table occurrences sharing the same source table: The solution has the following layout based on the Trainer table occurrence: If a developer modifies the layout to be based on the Manager table occurrence instead of Trainer, what happens to the data that is displayed?

The name, phone, and address fields will no longer display data, and the portal will show all employees related to the manager record. ✘ The name, phone, and address fields will change to show the manager's data, and the portal shows all employees related to the manager record. ✘

The name, phone, and address fields will change to show the manager's data, but the portal will need to be edited to Show related records from: the Managertable occurrence as well.

✘ The name, phone, and address fields will now show data for the first related trainer of the first class of the first employee of the current manager, and the portalwill show all employees related to the manager record. ✔

The name, phone, and address fields will now show data for the first related trainer of the first class of the first employee of the current manager, and the portalwill show all employees that have been enrolled in that trainer's classes.

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Given the following Relationships Graph in a FileMaker 13 solution: A layout is based on the table occurrence Class and a portal shows records from the table occurrence Employee. If the field Trainer: : Name is placed into the portal, what is the result?

The text is displayed in each row of the portal. ✘ Each row shows the name of each enrolled employee's first related trainer. ✘ The name of the first related trainer for the class is repeated in each row of the portal. ✘ The name of the trainer for the first class enrolled by the first Employee record of the portal is repeated in each row of the portal. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A layout is using a theme that sets a field to have a text color of "green" and a text style of "bold". FieldA has conditional formatting where the text color is "red" when the data in FieldB = 1. A new style is created and applied to FieldA where the text color is "blue" and the text style is "italic" but the style is not saved to the theme. If FieldB = 1, how would the data in FieldA be formatted?

The text color is "red" and the text style is "italic".

✘

The text color is "red" and the text style is "bold".

✘

The text color is "blue" and the text style is "italic".

✘

The text color is "green" and the text style is "bold".

✔

The text color is "red" and the text style is "bold" and "italic".

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Given the following return-delimited data in a Team field of a FileMaker 13 solution:
Andy Jones
Bernie Lee
Carry Lane
Which formula would result in the string "Bernie Lee" (without quotes or leading/trailing carriage returns) from Team?

ListValues (Team ; 2) ✘ Middle (Team ; 12 ; 10) ✘ GetValue (Team ; ✘ MiddleValues (Team ; 2 ; 1) ✔ Trim (Middlewords (Team ; 3 ; 4)) ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The following formula in a calculation field returns a Text result:

Let( tmp = "2 * 5" Evaluate( Quote ( tmp ) ) )

What value will be returned?

10 ✘

2*5

✘

"10", quotes included

✘

"2 * 5", quotes included

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which formula returns the calendar quarter (1. 2. 3, 4) of a date contained in a field called myDate?

Option A ✘ Option B ✘ Option C ✘ Option D ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Given a custom function created in FileMaker Pro 13 Advanced defined as Explode (str): What is the result of Explode (Bob)?

Bo
B ✘ BBo
Bo ✘ BB
Bo ✘ BBo
Bob ✔ BobBo
B ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

FILEMAKER Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner