Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

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.

When FileMaker Server 8 is set to Secure connections to FileMaker Server, which two statements are true? (Choose two.)

A.

Secure connections are typically faster because of data encryption.

B.

Secure Sockets Layer (SSL) is used by FileMaker Pro 8 client connections.

C.

Connections between FileMaker Server 8 and FileMaker Pro 8 are encrypted.

D.

Connections between FileMaker Server 8 Advanced and XML clients are encrypted.

Which two statements are true about the [Full Access] privilege set? (Choose two.)

A.

It can be deleted and/or renamed.

B.

It must have at least one account associated with it.

C.

Another privilege set with the same functionality can be created.

D.

Associated accounts cannot log in over a network unless the [fmapp] extended privilege is enabled.

In FileMaker Pro 8 which two statements about portals are true? (Choose two.)

A.

Container fields can be placed in portals.

B.

The initial row setting of a portal can be set by a script.

C.

A sort order applied to a portal overrides any sort order set up for the relationship.

D.

If there are multiple portals on a layout, the Go to Portal Row [First] script step will activate the portal closest to the top, left corner of the layout.

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

Consider two files, Alpha and Beta, where tables from Beta are included in the Relationships Graph of Alpha as external table occurrences. What are two ways to rename Beta while preserving all functionality in Alpha? (Choose two.)

A.

change the file path of the Beta File Reference in Alpha

B.

rename Beta using the File > Save a Copy As... option

C.

rename any table occurrences that are based on Beta to match the new file name

D.

use Tools > Developer Utilities... in FileMaker Pro 8 Advanced to rename Beta

Which three are required to get XML data, using a Web browser, from a database hosted by FileMaker Server 8 Advanced? (Choose three.)

A.

a query string in an HTTP URL request

B.

the FMPDSORESULT or fmresultset grammar

C.

at least one account with the fmxml extended privilege assigned to its privilege set

D.

XML Publishing enabled in the Web Publishing Administration Console

E.

the Export Records [FMPDSORESULT] or Export Records [FMPXMLRESULT] script step included in a script set to run when the database opens

Which two are required for a plug-in to be used with Web Published databases? (Choose two.)

A.

It must be installed on the Web browser.

B.

It must not attempt to display information to the user's screen.

C.

It must be enabled for Web Publishing on FileMaker Server 8 Advanced.

D.

It must be installed in the Plugins directory of the Web Publishing Engine.

Given a stored calculation field modifiedBy that contains the following formula:

Evaluate ( Quote ("Modifiedby: " & Get (AccountName)) ; myField)

Which two statements are true? (Choose two.)

A.

The modifiedBy field will only be updated when the value of myField changes.

B.

The value of myField will be set to the results returned by the modifiedBy field.

C.

The modifiedBy field will be updated whenever a field other than myField is changed.

D.

The modifiedBy field will contain a complete history of everyone who has modified the current record.

E.

The Quote function is used so that the quotation marks around "Modifiedby: " will be escaped properly.

Consider a FileMaker Pro 8 database with the following tables and fields:

Customer: customer_id, first_name, last_name

Order: order_id, customer_id, order_date

Product_Orders: order_id, product_id, quantity_ordered

Product: product_id, product_name, unit_price

Using only Cartesian cross-product ("x") relationships between table occurrences, sorting if necessary, which two actions can be performed? (Choose two.)

A.

determine the date of the most recent order

B.

display all records from the Customer table in a portal

C.

create a value list that shows all orders for a chosen customer

D.

create a portal to show one record for each product that has ever been ordered