FileMaker Developer Essentials for FileMaker 12 Beta 認定 FM1-306 試験問題:

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

A) Let (m = Month (myDate) ;
Case (m > 0 ; 1 ; m > 3 ; 2 ; m > 6 ; 3 ; 4)
)
B) Ceiling (Month (myDate) / 3)
C) Int (Month (myDate) / 3)
D) Mod (Month (myDate); 3) + 1
E) Let (m = Month (myDate) ;
Choose (m ; 1 ; 1 ; 1 ; 2 ; 2 ; 2 ; 3 ; 3 ; 3 ; 4 ; 4 ; 4)
)

2. Which operation requires a database file to be open in FileMaker Pro 12?

A) Creating a copy of a file, in which the OnFirstWindowOpen script trigger is disabled in the copy
B) Performing a File Maintenance option
C) Rebuilding the index of an individual field without affecting other field indexes
D) Creating a copy of a file based on its logical structure (same as Compacted Copy)

3. Which formula returns "05-2012" given a date field myDate that contains the date May 20,
2012?

A) RightWords (Filter (GetAsText (myDate); "xx-xx-xxxx"); 2)
B) GetAsDate (myDate ; "MM-YYYY")
C) Right ("0" & Month (myDate); 2) & "-" & Year (myDate)
D) Month (myDate) & "-" & Year (myDate)

4. Which two statements are true if two windows in a FileMaker Pro 12 database display records based on the same layout? (Choose two.)

A) If a record is being edited in one window, the user will be prompted to save or revert the record when they attempt to switch to the same record in the second window.
B) If a custom menu set is installed in one window, it will become the active menu set in the other window as well.
C) If a record is being edited in one window, it cannot be edited in the other window.
D) A find performed in one window will be available as a Recent Find in the other window.
E) If a new record is created in one window, it will become the active record in both windows after it has been committed in the original window.

5. Which two statements are true regarding object styles in FileMaker 12? (Choose two.)

A) A text box will not display Hover state styles.
B) The Alternate Record state is unique to the Body part.
C) Hover state styles for a field will supersede Conditional Formatting styles when a mouse pointer is hovering over the field.
D) Only the Normal State is recognized for object styles in FileMaker Go 12.
E) Only the Normal State will function in Table View for fields in the Body part.

質問と回答：