Activedumpsnet Logo
Click the Exhibit button.
Your database has four tables: Customer, Invoice, Line Item, and Product. The relationships are displayed in the Relationships Graph exhibit.
Your users want to select a group of customers and then view all unique products purchased by those customers.
Which two techniques successfully accomplish this without changing the Relationships Graph? (Choose two.)
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.)
The last script step in Script A in File A calls Script B in File B. Which three script steps can be used in Script B to make File B's front most window active without the need to use the Select Window [ ] script step? (Choose three.)
A field in FileMaker Pro 8 has been set to validate Always. Which two actions will trigger validation on that field? (Choose two.)
Which two statements are true regarding the behavior of windows in FileMaker Pro 8 when using Custom Menus? (Choose two.)
Which three occur if the hard disk runs out of space during a "live" backup of files hosted on FileMaker Server 8? (Choose three.)
Click the Exhibit button.
Given the relationship shown in the exhibit, which statement is true?
Click the Exhibit button.
You have a FileMaker Pro 8 layout based on the table occurrence Teachers. You have a portal showing records from the table occurrence Students.
What happens if you place the field Classes::Class Name into the portal?
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.)
Given a custom function created in FileMaker Pro 8 Advanced called "MyFunction" with a single parameter "Number" defined as:
If (
Number = 0 ;
Number ;
Number & ", " & MyFunction ( Number - 1 )
)
What is the result of MyFunction ( -3 )?
In FileMaker Pro 8 which two statements about portals are true? (Choose two.)
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?
What two statements are true for FileMaker Pro 8 Advanced? (Choose two.)
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.)
Given the formula:
1 and (1 & 1)
What is the numeric result?
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?
Which three script steps in a FileMaker Pro 8 database may fail if another user is editing the record on which the script is operating? (Choose three.)
Click the Exhibit button.
What changes need to be made to the database to create a portal on a layout tied to the Customer table occurrence that displays all products (without duplication) that a customer has ever ordered?
