Pass the FileMaker Filemaker Certification FM0-302 Questions and answers with CertsForce

Viewing page 2 out of 4 pages
Viewing questions 11-20 out of questions
Questions # 11:

Click the Exhibit button.

You run the following script from a layout assigned to the table occurrence Teachers:

Go to Related Record [Show only related records; From table: "Enrollment";

Using layout: "Enrollment" (Enrollment)]

Assuming there are matching records in all tables, what is the found set when the script completes?

Question # 11
Options:

A.

No records will be shown.


B.

the enrollment records for the first class for the current teacher record


C.

the enrollment records for all the classes for the current teacher record


D.

the enrollment records for the first class for all teacher records in the found set in Teachers


Expert Solution
Questions # 12:

Which type of file results from converting a CDML format file using the FileMaker CDML Converter?

Options:

A.

XSL style sheet


B.

CSS style sheet


C.

HTML document


D.

XHTML document


Expert Solution
Questions # 13:

A script saves a group of records as a PDF. The resulting file needs to be saved on a user's desktop and the filename must contain that person's name along with the current date (without additional user input). Which technique accomplishes this?

Options:

A.

This can only be done using a plug-in.


B.

When specifying the output file, you use a filepath that references a variable containing the desired filename and path.


C.

When specifying the output file, you use a filepath that references a globally stored field containing the desired filename and path.


D.

When specifying the output file, use a filepath that references a calculation field that uses both Get (DesktopPath) and the Get (UserName) functions.


Expert Solution
Questions # 14:

Given the formula:

Choose( Qty / 100; 0; 2; 4; 6; 8 )

If the field Qty contains the value 250, what is the result?

Options:

A.

0


B.

2


C.

4


D.

6


E.

8


Expert Solution
Questions # 15:

Click the Exhibit button.

Given a layout including the Tab Control shown in the exhibit, what are two valid methods to navigate to the Phones tab? (Choose two.) Note: None of the contents of the Phones tab exist anywhere else on the layout.

Question # 15
Options:

A.

You perform a script that includes Go to Field [ ] targeting one of the fields on the Phones tab.


B.

You perform a script that includes Go to Tab [ ] targeting the Phones tab and one of the fields in the tab.


C.

You use the Tab key until the Tab Control becomes active, then navigate to Phones using Arrow keys and press the Space bar. This works only if the Tab Control is included in the layout's Tab Order.


D.

You use the Tab key until the Tab Control becomes active, then navigate to Phones using Arrow keys and press the Space bar. This works only if at least one field in the Phones tab is included in the layout's Tab Order.


Expert Solution
Questions # 16:

Which two can be used to import data into a FileMaker Pro 8 file directly from FileMaker Pro 6, without first having to export the data from FileMaker Pro 6? (Choose two.)

Options:

A.

XML


B.

SYLK


C.

HTML


D.

ODBC


Expert Solution
Questions # 17:

While in a FileMaker Pro 8 database on a layout based on the Customer table occurrence, the following script is run:

Show All Records

Go to Record/Request/Page [First]

Loop

If [Customer::Category <> "A"}

Omit Record

Else

Go to Record/Request/Page [Next; Exit after last]

End If

Exit Loop If [Get ( FoundCount )= 0]]

End Loop

After the script stops running, which two statements are true? (Choose two.)

Options:

A.

All customer records in Category A are omitted.


B.

If there are no Category A records, the found set is 0.


C.

All customer records in Category A are in a found set.


D.

If there are no Category A records, the found set is all records.


Expert Solution
Questions # 18:

What is a valid way of adding comments inside a calculation formula in FileMaker Pro 8 database?

Options:

A.

# Comment Here


B.

/* Comment Here */


C.

<* Comment Here *>


D.


Expert Solution
Questions # 19:

Which two statements are true regarding the use of plug-ins? (Choose two.)

Options:

A.

Plug-ins provide additional script step capabilities.


B.

Plug-ins provide additional calculation capabilities.


C.

The Auto Update feature is implemented with a plug-in.


D.

Plug-ins can only be used on FileMaker Pro 8 and FileMaker Pro 8 Advanced.


Expert Solution
Questions # 20:

Given a new privilege set in a FileMaker Pro 8 database, which two extended privileges can be enabled to enable an external application to connect to the database? (Choose two.)

Options:

A.

Access via ActiveX


B.

Access via ODBC/JDBC


C.

Access via FileMaker Mobile


D.

Access via External Application


Expert Solution
Viewing page 2 out of 4 pages
Viewing questions 11-20 out of questions