Winter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Login / Register

Question # 4

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.

Full Access
Question # 5

Which three are valid types listed in the FileMaker Pro 8 Export Records to File dialog? (Choose three.)

A.

XSL

B.

Merge

C.

HTML Table

D.

Microsoft Excel

E.

Microsoft Access

Full Access
Question # 6

Which three text functions are case sensitive? (Choose three.)

A.

Exact()

B.

Filter()

C.

Replace()

D.

Substitute()

E.

PatternCount()

Full Access
Question # 7

For accounts that are authenticated via FileMaker, which two are controlled by privilege sets in FileMaker Pro 8? (Choose two.)

A.

which accounts are authenticated

B.

minimum password length for associated accounts

C.

whether or not the passwords of associated accounts expire

D.

how many failed login attempts are allowed before associated accounts are disabled

Full Access
Question # 8

A layout showing records from a People table has the Save record changes automatically checkbox disabled in the Layout Setup dialog. Which two actions cause FileMaker Pro 8 to display a dialog asking whether or not you want to save changes to the current record? (Choose two.)

A.

importing records into the People table

B.

editing a field value on the layout and attempting to commit the record

C.

running a script that navigates to that layout, changes a field value, and performs a Commit Records/Requests[No Dialog] script step

D.

running a script that navigates to that layout, changes a field value, and performs a Commit Records/Requests[Skip data entry validation] script step

Full Access
Question # 9

In the Fields tab of the Define Database dialog in FileMaker Pro 8, which two are valid field types? (Choose two.)

A.

Time

B.

Image

C.

Global

D.

Repeating

E.

Timestamp

Full Access
Question # 10

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

A.

XSL style sheet

B.

CSS style sheet

C.

HTML document

D.

XHTML document

Full Access
Question # 11

What are three valid sources for directly importing records into FileMaker Pro 8 file? (Choose three.)

A.

JDBC

B.

ODBC

C.

Excel files

D.

XML format

E.

HTML table format

Full Access
Question # 12

Which three technologies/products may be used in conjunction with FileMaker Server 8 Advanced to produce custom Web pages? (Choose three.)

A.

JSP

B.

UML

C.

PHP

D.

CDML

E.

XSLT

Full Access
Question # 13

Click the Exhibit button.

Given the FileMaker Pro 8 relationship graph shown in the exhibit, a layout assigned to the Teachers table occurrence has fields Name and Address, and a portal showing the Students table occurrence.

If a developer assigns the layout to the Advisors table occurrence, what happens to the data displayed?

A.

Name and Address do not display data and the portal shows all students of the current advisor.

B.

Name and Address show the current advisor and the portal shows all students of the current advisor.

C.

Name and Address show the first teacher of the first class of the first student of the current advisor and the portal shows all students of that teacher.

D.

Name and Address show the first teacher of the first class of the first student of the current advisor and the portal shows all students of the current advisor.

Full Access
Question # 14

Which two statements are true of a FileMaker Pro 8 database? (Choose two.)

A.

Users can move and resize windows that are created through a script.

B.

Names of new windows created through the New Window script step must be unique.

C.

If a file has been configured to perform a script when closing the file, this script will always run when a window associated with that file is closed.

D.

It is possible to use a script to change the name of an existing window.

E.

There is no way to prevent a user from using the New Window menu command to create new windows.

Full Access
Question # 15

Given the formula:

1 and (1 & 1)

What is the numeric result?

A.

0

B.

1

C.

2

D.

12

Full Access
Question # 16

In FileMaker Pro 8, which two statements are true for layout setup options? (Choose two.)

A.

The Menu Set setting determines the default menu set to install for the layout.

B.

Show field frames when record is active determines the scroll bar behavior of portals.

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.

The Save record changes automatically layout options determine the behavior of record commits for the layout in browse mode.

Full Access
Question # 17

Click the Exhibit button.

You want to build a FileMaker Pro 8 database that models a business organizational chart. One person may manage zero or more 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 about a person can display the name of the current person's manager as well as a portal of the people managed by the current person (as shown in the exhibit).

Assume that there are no lookup fields or calculation fields defined in any table, and there are no scripts in the file.

What is the minimum number of table occurrences you must use to construct the layout?

A.

one

B.

two

C.

three

D.

four

Full Access
Question # 18

Given the formula:

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

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

A.

0

B.

2

C.

4

D.

6

E.

8

Full Access