Advanced Review Questions Flashcards
1
Q
It is possible, in theory, to implement a many-to-many relationship between tables A and B by using multivalued attributes in each table. What important design problem in many-to-many relationships cannot be solved using this technique?
A
Often it will be necessary to store additional attributes as part of the relationship between the two entities.
i.e., In the many-to-many relationship between Actor and Movie, it would be desirable to store a character’s name for a specific movie. Resolving the relationship using multivalued attributes would leave no place to store such information.
1
Q
Describe how an object behaves when it has multiple conditional formatting options.
A
FileMaker Pro will apply the formatting options for all of the true conditions specified. If multiple true conditions are specified with conflicting formatting (such as two conditions that specify different background colors), FileMaker Pro applies only the formatting associated with the last true condition.
1
Q
What are some of the possible pitfalls of executing a script step in an incorrect context?
A
The action might be performed against the wrong table, which could lead to records being added to or deleted from a different table than you intended or to actions being performed against an incorrect found set of records.
1
Q
How might you use FileMaker Server’s ability to trigger an operating-system script?
A
You might use it to trigger a script with a specific user account that can perform more fine-grained backups than the FileMaker Server tools allow or that copied backed-up files to a remote volume (privileges permitting).
1
Q
What are three capabilities available via the FileMaker Pro client that are not available via FileMaker WebDirect?
A
The FileMaker Pro client has the following capabilities that do not translate to FileMaker WebDirect:
- Show multiple open windows at once
- Perform scripted interactions with the user’s file system
- Preview mode
- Custom menus
2
Q
What is an entity, in database terms?
A
An entity is a type or class of thing that has a distinct existence—something that one wishes to track in a consistent fashion. Entities can exist at various level of abstraction. Examples of entities could be such things as Invoice, Customer, Animal, Inspection, Horse, Contact, Product, and the like.
2
Q
How can you tell that you have reached the correct list of entities and attributes for a database?
A
There is no truly “correct” list of entities and attributes for any database problem. The quality of the list is determined by how well it supports the necessary functions of the system being designed.
2
Q
Describe a technique for implementing a many-to-many relationship between two tables, A and B, that overcomes the limitations of trying to use multivalued attributes.
A
Use a third table (“join table” or “join entity”) that contains a foreign key for each of tables A and B and has a many-to-one relationship with table A and table B.
2
Q
Number fields can store text characters. TRUE or FALSE
A
TRUE
4
Q
What are the four object states for which you can specify appearance attributes?
A
The four object states are:
- Normal State
- Hover
- In Focus
- Pressed
5
Q
What are some limitations of the ODBC Import feature compared to ESS
A
- ODBC Import cannot make any changes to data in the original ODBC data source
- ODBC Import must use a DSN on each individual FileMaker Pro desktop, and it cannot use a single DSN on a central hosting machine, as ESS may do.
6
Q
What are the three most important factors in determining how a container field behaves?
A
- How the field’s storage options are defined
- How it is optimized on the layout
- How the user inserts data into the container field.
7
Q
What formula would you use to find the number of characters in the first word of a string?
A
Length ( LeftWords ( text ; 1 ) )
9
Q
How does FileMaker Pro store date, time, and timestamp data?
A
- Dates are stored as the number of days since 1/1/0001
- Time is stored as the number of seconds since midnight
- Timestamps as the number of seconds since midnight on 1/1/0001
10
Q
What are the drag options available in the Field Picker for Field Placement and Label Position?
A
- Fields can be positioned side-by-side or in a stack
- Field labels can be placed above or to the left of each field.
10
Q
What are some advantages of the ODBC Import capability in FileMaker Pro compared to the External SQL Sources (ESS) feature?
A
- ODBC Import can be used to draw data from any of dozens of ODBC-compatible data sources; ESS currently only supports three major data sources.
- It is possible to extract data using a handcrafted SQL query using ODBC Import, which is not possible with ESS.
11
Q
Describe the difference between static and a dynamic value lists.
A
-
Static value list - choices are hard-coded into the value list itself.
- i.e., a Status value list might have Active and Inactive as its two choices.
- Dynamic value list - choices are generated from data in a table. The choices can change dynamically as records are added or removed from the table.
12
Q
What are some common reasons for choosing bar, line, area, pie, or scatter as a chart type?
A
- Pie chart - to show comparisons of parts to a whole
- Bar chart - to show comparisons among a set of elements
- Line and area charts - to show data trends over time
- Scatter charts - to show the correlations between two data series
12
Q
What do you have to do to create a ranking subsummary report?
A
You have to select the Reorder based on summary field option in the sort records dialog and select a summary field to reorder by.
12
Q
Why is it important to give users an easy way to log out of a FileMaker WebDirect solution?
A
As a long as a user is not logged out of a FileMaker WebDirect solution, that user is consuming a licensed connection. If the user is idle, eventually the session timeout will trigger and log them out automatically, but the sooner an idle user gives up their connection, the sooner that connection is free for another client to use.
13
Q
What is a self-relationship? Give an example.
A
The term “self-relationship” denotes a scenario in which a table is related to itself. A typical example is an organizational chart, in which each employee record relates to another employee record denoting that employee’s direct manager.
15
Q
What is a foreign key, and how is it different from a primary key?
A
A field that holds the value of a primary key from another table (a “foreign” table). Unlike a primary key, it need not be unique and may in some circumstances be empty. It is used to indicate a relationship between rows in one table and those in another.
16
Q
What are the ramifications of using the Set Error Capture [On] script step?
A
Turning error capture on makes it necessary to trap for, handle, and report error conditions that otherwise would automatically be handled and reported by FileMaker Pro.
16
Q
What benefits does FileMaker Server confer when deploying databases?
A
- Supports FileMaker WebDirect and FileMaker Go clients
- Supports large numbers of FileMakerPro clients
- Backs up solutions on a schedule
- Uses external directories for user authentication
- Added SSL security for data transfer
- Remote ODBC/JDBC support
- PHP and XML support.
17
Describe the various ways that scripts can be activated.
* By defining a layout object as a button that runs a script
* From the Scripts menu if it has been set to display there (or any other menu through the use of custom menu sets)
* Scripts assigned to certain menu items may be triggered using a keyboard shortcut
* As a subscript of another script
* By some layout, object, or file trigger, such as entering a layout, entering a field, or opening a file; and FileMaker Server can also schedule execution of scripts.
17
How much data can a text field store?
A text field can hold about **2GB of data** ( a billion characters )
19
What are some important characteristics of a primary key?
A primary key should be:
* unique
* non-empty
* It should not be possible to change the value of a primary key.
19
Besides FileMaker Server, what other software is necessary to depoloy FileMaker solutions to the web?
FileMaker Server must be installed in conjunction with a supported web server (Apache on OS X, Internet Information Server on Windows).
21
In what folders can FileMaker Server backups be created?
FileMaker Server backs up databases to folders on one or more local volumes (connected hard drives or SANs). These files should be backed up to other volumes and integrated into an overall backup strategy.
21
How do you instruct the **Insert from URL** script step to use an HTTP POST request vs. an HTTP GET request?
* **HTTP GET** url starts with either HTTP or HTTPS.
* **HTTP POST** url starts with HTTPPOST or HTTPSPOST
21
How does FileMaker read a date internally?
As an integer (whole number) representing the number of days elapsed from 1/1/0001 up to the specified date.
22
What are some of the pros and cons of indexing?
**Pros:** Indexing dramatically speeds up searches, and is used by relationships, value lists, and the auto-complete functionality.
**Cons:** Indexing increases file size and may impact performance of operations that require index maintenance, such as importing or deleting large sets of records.
22
What formula would you use to determine the date exactly one week from today?
Get ( CurrentDate ) + 7
22
How many concurrent FileMaker WebDirect connections are supported by FileMaker Server?
The number of concurrent FileMaker WebDirect and/or FileMaker Go connections is governed by the number of purchased connection licenses, plus the one connection license that comes with FileMaker Server.
23
What is a break field?
When you create a subsummary part, the field by which you choose to group records is called the break field.
Whenever the value of the break field changes, the report “breaks” and FileMaker Pro starts a new subsummary group.
23
When should you consider creating a crosstab report?
Create a crosstab report when data needs to be summarized by two categorical variables, but usig a report with multiple subsummary parts would make the data difficult to analyze.
24
Rewrite the following formula using a Let() function to avoid the need for nesting functions within one another:
`GetValue ( Colors ; ValueCount ( LeftValues ( Colors ; Counter )) - 1 )`
`Let ([ `
`x = LeftValues (Colors ; Counter); vCount = ValueCount(x) `
`]; `
`GetValue(Colors ; vCount-1) `
`)`
24
How many digits of precision do number fields hold?
A number field can hold up to **800 digits** of numeric precision, **400 to either side** of the decimal point.
The default precision for a number field is **16 decimal places**.
25
Under what circumstances would Int ( x ), Floor( x ), and Truncate( x ; 0 ) not return the same result?
For any positive number x, all three functions will return the same result. However, if x is a negative number, Floor( x ) is different than Int( x ) and Truncate( x ; 0 )
27
What is external authentication?
External authentication allows FileMaker Pro to interact with a networked authentication server (Active Directory or Open Directory) or with accounts and groups defined on the server itself to test the credentials of users attempting to log into a database. Rather than authenticate against individual accounts stored in a database, FileMaker Server (which is required for external authentication) passes the user’s credentials to the authentication server, which in turn passes back a list of the groups to which the user belongs. You control what level of access members of various groups have (if any) by setting up an account for each group.
29
What are the differences between summary fields and aggregate functions
* **Summary fields** aggregate data from a subgroup of the current found set
* **Aggregate functions** are used to aggregate data from sets of related records.
30
What effect does enabling the **fmreauthenticate10** extended priveleges have?
If a user’s privilege set has the **fmreauthenticate10** extended privilege enabled, then the user can put FileMaker Go in the background for up to 10 minutes without having to re-authenticate. After 10 minutes, the user will be prompted to re-enter their username and password.
32
What forms of database security are controlled from FileMaker Server?
FileMaker Server can control the following forms of database security:
* Use of external directory service for authentication
* Restrict IP addresses that may access the Admin Console
* Use external groups to control access to the Admin Console
* List only the databases each user is allowed to access
* Require secure (SSL) connections for clients
33
In what ways can a FileMaker Pro developer alter the structure of a shadow table?
* Add "supplemental fields" to a shadow table, though these fields must be either unstored calculations or summary fields.
* Add additional validation criteria to individual shadow fields, though it is not possible to alter any validation criteria already present on the field.
* Select Date, Time, or Timestamp as the FileMaker field type for DATETIME and SMALLDATETIME SQL fields, even though the FileMaker type defaults to Timestamp.
34
How is time read internally by FileMaker Pro
As an integer representing a duration of seconds from midnight.
i.e. 10 a.m. is seen internally as "36000"
36
What anchors need to be set in order to make an object stretch vertically when a window is resized?
Setting both the top and bottom anchors will cause an object to stretch vertically when the window is resized.
36
How many data series can be charted using a pie chart?
A pie chart must contain **one data series and one label series**. Additional data series will be ignored.
37
Why are script parameters useful?
They allow you to write scripts that avoid hard-coding specific values. These values can then be passed into the script from the outside, allowing the same script to be used in many different circumstances.
39
What script steps may be used in FileMaker Pro scripts that are run by FileMaker Server? Give three examples of incompatibile script steps.
Only Server-compatible script steps may be run from FileMaker Server. Three examples of incompatible script steps are:
* Export Field Contents
* Save Records as PDF
* Print
40
What are the three ways to specify the data series for a chart?
The three ways to specify data for a report are
1. Using the current found set
2. Using delimited data from the current record
3. Using data from a related field.
41
How can you prevent someone from creating an external file reference to a database solution?
Use the **File Access** settings within the **Manage Security** dialog to prohibit external file references from being created into your solution.
41
What are some limitations of shadow tables and fields in FileMaker Pro?
Any native FileMaker Pro features that work with table indexes will not work correctly with shadow fields and tables, except for relationships and value lists. This includes features such as field auto completion, and the **Insert from Index** command. In addition, styled text and binary data (such as container field data) are not supported in ESS.
42
Describe what it means for a field to be set to Use global storage.
A field that has been defined to use global storage holds one value per file rather than one value per record. Globally stored values are specific to a single user’s session and are not shared between users.
42
When would you choose to use a window style of **Dialog Window (Modal)?**
When you want to strictly control a user’s interaction with the window, to prevent them from navigating away from the dialog before completing the interaction.
43
What is the difference between a pre-event and post-event script trigger?
* **Pre-event script triggers -** the script is performed before the triggering event is processed, and can cancel the triggering event by returning false.
* **Post-event triggers -** happen after the triggering event has completed.
45
What sorts of FileMaker Pro fields are not appropriate targets for a relationship match?
You cannot use unindexed or unindexable fields as the target of a relationship match. This would include any field that is deliberately left unstored or any field that cannot be stored, such as fields with global storage, summary fields, or calculation fields that reference globally stored fields, summary fields, or related fields.
45
What is a "shadow table"?
A shadow table is a table that is created in a FileMaker Pro database when a table from an Extended SQL Source is added to the **Relationships Graph**. The FileMaker Pro table “shadows” the table in the original SQL data source.
47
True or False: A layout can be attached to multiple table occurrences.
**FALSE**
## Footnote
Every layout must be attached to one and only one table occurrence.
49
What four layout objects are able to contain other layout objects?
The four layout objects that can contain other layout objects are:
* Portals
* Tab Controls
* Side Controls
* Popover Buttons.
49
What is the purpose of the **Go to Related Record** script step?
The purpose of the **Go to Related Record** script step is to navigate from a record (or set of records) to some set of related records.
50
What is recursion and what does it allow custom functions to do?
A recursive custom function is any custom function that references itself. Recursion allows custom functions to perform a set of functions iteratively, which is something regular calculation functions cannot do.
52
What keys trigger a script associated with a button that you have tabbed to?
Pressing the Space bar or the Return key will trigger a script once you have tabbed to a button.
54
What is the difference between auto-entering Account Name versus Name on creation or modification of a record?
**Account Name** is the value supplied during authentication when opening a database file.
**Name** refers to the User Name, as defined in the Preferences dialog.
Best practice is to use account name
56
How does FileMaker Pro store textual data internally?
As **Unicode values**, which require up to 2 bytes of information per character
58
What is a “multivalued attribute”?
A multivalued attribute is a field that may contain more than one distinct value, such as a Color field that contains the values red, orange, and pink in a return-delimited list.
59
What purpose do extended priveleges serve?
All but one of the preconfigured extended privileges determine the data sharing options (i.e., FileMaker WebDirect accessibility) that are permitted by a privilege set. Developers can create additional extended privileges and use them to control other actions as they see fit.
61
What is an attribute, in database terms? How does it differ from an entity?
An attribute is a characteristic of an entity, rather than an entity in its own right. An Invoice would be a good example of an entity. An Invoice entity might have attributes such as “date paid,” “customer ID,” and “total amount.”
62
What is ODBC?
ODBC (Open Database Connectivity) is an abstraction technology intended to allow client applications access to a wide range of supported data sources.
64
What is the maximum size of data that a container field can hold?
A container field can hold **4GB**
65
What is a multi-predicate relationship in FileMaker Pro? Give an example.
A multi-predicate relationship in FileMaker Pro is a relationship with more than one match criterion.
Ex., a relationship between Student and Class Enrollment where the Enrollment’s StudentID matches the Student’s StudentID, and the Enrollment’s ClassCategory is not “Science.” This relationship would correspond to the query “Find me all of this student’s non-science classes.”
67
When a new object is created on a layout, which style will automatically be applied?
When a new layout is created on a layout, the object’s Default style for the layout’s theme is applied.
68
What type of data can a container field store?
Binary data
69
What is a DSN?
A DSN (Data Source Name) is a stored configuration for connecting to a specific ODBC data source. A DSN needs access to a specific ODBC driver and is platform-specific.
71
When a 1 is returned in a Boolean operation, is the statement true or false?
True
72
How is a timestamp stored in FileMaker Pro?
A timestamp is a combination of date and time and is stored as the number of seconds since midnight on 1/1/0001
73
What is encryption at rest and how do you enable it?
Encryption at rest means encrypting the physical database file itself. It protects against hacking by someone with access to the physical file. Use the **Developer Utilities** in FileMaker Pro Advanced to create an encrypted copy of a file.
75
When creating a crosstab report, how do you decide which variable to represent in rows and which variable to represent in columns?
The column headings should be known in advance and should be fixed, whereas the variable represented in rows can be more continuous and open ended.
76
What is the difference between a local and a global variable
The value of a local script variable persists only for the duration of the script in which it is defined. A global variable, on the other hand, persists for the duration of the user’s session or until it is explicitly unset.
77
Why would you build a report using ExecuteSQL and virtual lists?
Reports built using ExecuteSQL and virtual lists can provide improved performance and flexibility over other reporting techniques. They also reduce clutter on the graph and in data tables.
79
True or False: Tooltips, conditional formatting, and script trigger settings are retained when an object is duplicated.
**True.** All of an object’s settings are retained when it is duplicated.
80
Why is report planning important?
Incorporating report planning in the foundation is a good way to uncover additional requirements and to validate the data model. It also reduces the risk of rework late in a project.
81
What is the difference between setting a field to validate always as opposed to only during data entry?
If a field is set to validate Always, the validation rules will apply to any modification of the field, including through imports and by scripts.
82
In a calculation formula, what is the difference between using the operators &, +, and "and"?
Use the **ampersand symbol** (&) to concatenate text strings together
Use the **plus sign** (+) to add numbers together
Use the word **"and"** for specifying multiple conditions in a logical test
83
Why is it important for a database table to have a primary key?
A primary key is a means by which a row in a database table may be uniquely identified. Without such an identifier, database operations might operate on the wrong row or on multiple rows.
84
True or False: You can have multiple Inspector tools open at the same time.
**TRUE**
## Footnote
It can be helpful to set up your development environment with multiple Inspector tools open to different tabs.
86
If you remove a user's privilege to delete records, what will happen if a script attempts to delete a record?
Unless a script has been set to run with full access privileges, a script will run with the same privileges as the currently logged in user.
In other words, if a user does not have the privilege to delete records, then neither can a script.
*By disabling privileges and enabling some scripts to run with full access privileges, you can precisely control access to functionality like creating and deleting records.*
87
What is the difference between open and secure storage for a remote container field?
* **Open storage** - FileMaker Pro will by default store that field’s files in a clear hierarchical folder system, named by the file, table and field. (A developer can modify this default path.)
* **Secure storage** - the file and file path will be encrypted.
88
What formula would you use to get the contents of a bar code stored in the container field
`OrderItem::Barcode`
`GetContainerAttribute ( OrderItem::Barcode ; “barcodeText” )`
89
What is an ODBC driver?
**ODBC driver -** a piece of software that connects client applications to a specific ODBC data source.
ODBC drivers are generally platform-specific (though an ODBC driver may be configured on a server in such fashion as to allow clients from multiple platforms to use the same server-side driver).
90
Field data types can affect the behavior of sorting. TRUE or FALSE
**TRUE**
91
Describe what role accounts and privilege sets play in securing a database solution, and what is the relationship between them?
* **Accounts** are the credentials (username and password) that are used to log in to a solution.
* **Privilege sets** govern what you can see and do within a solution.
Your account determines your privilege set; every account is associated with a single privilege set. Each user should have a unique account (Joe, Mary, etc.), but a privilege set generally describes a class or type of user (SalesRep, Admin, Managers, etc.).
92
What is the date range that FileMaker is able to store?
FileMaker Pro is able to store and retrieve any date between 1/1/0001 and 12/31/4000
93
Why is it necessary to use FileMaker Server's backup schedules as the primary backup, rather than just using a system-level backup tool?
If a system-level tool attempts to back up open database files (FileMaker or otherwise), there is a high likelihood the backups will be corrupted.
94
What are the differences between sharing FileMaker Pro data using ODBC/JDBC from the FileMaker Pro client and sharing such data using FileMaker Server?
When sharing FileMaker Pro client data via ODBC/JDBC using the FileMaker Pro client, only applications running on the same local machine may access the data. When sharing FileMaker Pro data via ODBC/ JDBC using FileMaker Server, remote applications on other computers and other networks may access the shared data.
95
What is the difference between a one-to-many and a many-to-one relationship?
One-to-many and many-to-one relationships differ only in perspective. Herd-to-Animal is a one-to- many relationship, while Animal-to-Herd is the same relationship viewed from a many-to-one perspective.
96
What does the term “optionality” mean in relational database design? Why might it be important to note optionality in a database design diagram such as an ERD?
“Optionality” refers to an understanding of any further limits placed on a database relationship, specifically, how many of a specific entity may or must participate in the relationship. For example, the relationship of Student to Class Enrollment is one-to-many, but it may also be true that a student must always have at least one Class Enrollment record. Noting these constraints, on an ERD or elsewhere, may provide important clues to business rules.
97
Think of three examples of one-to-many or many-to-one relationships.
Herd-to-Animal (one herd may have many animals); Spacecraft-to-Mission (one spacecraft may fly many missions); Constellation-to-Star (one constellation generally contains many stars).
98
What are the two methods for creating new fields in a FileMaker Pro database?
* Manage Database dialog
* Field Picker
* A layout in Table View
## Footnote
**All methods require full access privileges in the file**
99
Reading a URL request for a web service to do something, how do you tell what the entry point is and what the parameter/value pairs are?
The entry point or base URL for a web service is the first segment up to the question mark. Each parameter/value pair is separated with an ampersand.
100
What is a "shadow field"?
A shadow field is a field in a shadow table that corresponds to a field in the original SQL source table.
101
The format of FileMaker Pro date fields is the same on all computer operating systems.
TRUE or FALSE
**FALSE**
102
What are the software requirements for FileMaker Server on Windows?
* IIS web server must be enabled on all machines in a single- or multiple machine deployment
* Java Runtime Environment 7 Update 17
* Bonjour for Windows 3.0.0.10
* Microsoft Visual Studio C++ 2012 Redistributable Package
* Microsoft Application Request Routing 2.5
## Footnote
! - FileMaker Server installer automaticallly installs these components if they are not on the user's machine.
! - To install FileMaker Server, users must have administrator privileges
103
What ports must be open to install FileMaker Server on a user's machine?
* 80 (HTTP)
* 443 (HTTPS)
* 16000 for Admin Console users
* 2399 for ODBC/JDBC connections
104
What are the supported ESS Data Sources?
* MS SQL Server 2008 R2
* MS SQL Server 2012
* MySQL 5.6
* Oracle 11g R2
105
What are the minimum OS requirements for **FileMaker Server 13**?
* Windows 8 Pro (64-bit)
* Windows Server 2012 Standard Edition (64-bit)
* Windows Server 2008 (Standard & Enterprise) R2 SP1 (64-bit)
* Windows 2008 Enterprise edition (requires FileMaker Server 13.0v5)
* Windows 7 Professional Edition SP1 (64-bit)
* OS X Yosemite 10.10 (requires FileMaker Server 13.0v5)
* OS X Mavericks v10.9.x
* OS X Mountain Lion and OS X Mountain Lion Server v10.8.5
106
What are the hardware requirements for FileMaker Server 13?
Minimum
* **CPU** - Dual Core
* **RAM** - 4 GB
* **Hard Drive** - 80 GB or more, dependent of file size, requires minimum of 10 GB free space
Recommended
* **CPU** - 4-Core
* **RAM** - 8 GB
* **Hard Drive** - 80 GB or more, dependent of file size, requires minimum of 10 GB free space
107
What are the supported web browsers for **FileMaker WebDirect**?
* Safari 8 on OS X v10.10 Yosemite
* Safari 6.1.x and Safari 7.x
* IE 10.x or 11.x
* Chrome 27.x
108
What are the recommended hardware configurations for a **web publishing server** for **FileMaker 13 WebDirect**?
of FM WD concurrent users - RAM - CPU
1-6 - Second machine is not required, intall on DB server
7-16 - 8GB - 4-Core
16-26 - 12GB - 8-Core
27-50 - 16GB - 12-Core
109
What are the capacitites for the different FileMaker products through FileMaker Server 13?
**_Types of clients_** **-** **_Tested_** **-** **_Theoretical_**
FileMaker Pro - 250 - Unrestricted
CWP - 200 - 2000
FileMaker Go - 50 - Unrestricted
FM WebDirect - 50 - 50
ODBC/JDBC - 50 - Unrestricted
110
What is the security included in FileMaker Server 13?
* Supports **AES-256 encryption of data at rest** when the database files are encrypted by FileMaker Pro 13 Advanced. Sharing, reading from, and writing to AES-256 encrypted files is supported by all products in the FileMaker 13 platform.
* Supports **SSL** with **AES-256** encryption of data in transit when the database files are hosted with FileMaker Server 13.
* Supports third party Certificate Authority (CA) SSL certificates to prevent Man in the Middle (MitM) attacks when the database files are hosted with FileMaker Server 13.
111
Windows 7 and Windows 8 are not supported for deployment use on multiple-machine installations.
TRUE or FALSE
**TRUE**
112
How many databases can FileMaker Server host?
125 databases
113
What are some additional things to keep in mind when installing FileMaker 13 Server?
* You may need to disable or uninstall anti-virus before running the FileMaker Server installer. Don't enable anti-virus software again until after the Deployment assistant has finished
* You can't run two different versions of FileMaker Server on the same machine at the same time
* Use a static IP address
* **OS X:** Avoid using the OS X Server application to enable any HTTP services while running FileMaker Server. HTTP services provided by OS X Server can interfere with
FileMaker Server.
114
How do you get to the FileMaker Server Admin Console
https://localhost:16000/admin-console
115
Web viewers cannot dynamically expand to display content beyond the border of the web viewer
TRUE or FALSE
**TRUE**
116
What are the two ways you can perform FileMaker Server database backups?
Scheduled backups and Progressive backups
117
What is a **Salt**?
A salt is a combination fo the database file's encryption password and a randomly generated, universally unique identifier (UUID) used during database encryption
118
How do you open an encrypted database that is hosted on FileMaker Server?
By using Admin Console or the *fmsadmin* command line interface (CLI). As server administrator, you should open the file with its encryption password, so that FM clients can use the encrypted database.
119
Are container fields that are stored externally backed up by default?
No but you can specify whether to back up the container file folders.
120
TRUE or FALSE
## Footnote
You need to enable the ODBC/JDBC data source feature of FileMaker Server to host FileMaker Pro databases that access an external SQL data source via ODBC.
**FALSE**
## Footnote
You only need to enable the ODBC/JDBC data source feature within FileMaker Server when the FileMaker file is acting as the data source
121
What is the maximum allowed database RAM cache can be set to?
Half of the physical RAM
physical RAM (MB) divided by 2
122
TRUE or FALSE
## Footnote
Globally stored values are specific to each user's session.
**TRUE**
123
What are the two types of index techniques
* **Value index** - consists of the first 100 characters of each value (return-separated item) in a text field
* **Word index** - contains entries for every unique word in the field
124
What are some reasons a field must be indexed
* If it is needed for relationships
* If there are value lists based on the field
* To use the Auto-complete using existing values field control option
* To use the Unique value and Existing value field validation options
125
What calculation fields cannot be stored or indexed?
A calculation field that references
* A related field
* A summary field
* Another unstored calculation field
* A field with global storage
126
What are some drawbacks to **Storing only a reference** option?
* Any db user who wishes to see the referenced file must have access to the disk volume on which the original file is stored.
* Cross-platform issues - mac will not see files inserted by Windows users as a reference, and vice versa
* If the original file is moved or renamed, the container field will not be able to find the object
* FileMaker Go clients cannot access files stored as a reference.
127
What are the 3 ways to insert data into container fields?
* Manually via the Insert menu or Drag & Drop
* Scripted
* Import
128
TRUE or FALSE
## Footnote
Regarding container fields, **Optimize for Interactive** is supported in portals.
**FALSE**
129
What is the storage limit for a container file for WebDirect users?
300 MB
130
TRUE or FALSE
## Footnote
Script variables are not available outside the file in which they are defined
**TRUE**
131
TRUE or FALSE
## Footnote
**OnObjectKeystroke** and **OnLayoutKeystroke** are supported on FileMaker WebDirect
**FALSE**
132
TRUE or FALSE
External authentication requires FileMaker Server; a local file cannot be externally authenticated.
**TRUE**
133
TRUE or FALSE
## Footnote
You must have at least FileMaker account associated with [Full Access] privilege set.
**TRUE**
134
What is the ShareID?
The Shared ID is uded to link multiple encrypted files together.
The Shared ID is case sensitive
135
What two things need to happen for a FileMaker database to be accessible to FileMaker WebDirect
* One or more account privilege sets must have the **fmwebdirect** extended privilege granted to them
* There must be an available licensed connection on FileMaker Server.
136
TRUE or FALSE
## Footnote
Users can add quick charts to a layout in FileMaker WebDirect
**FALSE**
137
When you perform a script that uses the Get(LastError) Function with control script steps, which control script steps do not clear the last error condition reported?
* If
* Else
* Else If
* End If
* Loop
* Exit Loop If
* End Loop
* Exit Script
* Halt Script
