GUIDEWIRE QUERY API EXAM
QUESTIONS WITH CORRECT ANSWERS
When would you use a row query instead of an entity query? - Answer-1. When the
performance of an entity query is inadequate
2. when you want to reduce the number of implicitly executed queries
3. When you want to use aggregate functions
Where does clicking the "Show Queries" button take you? - Answer-The aggregated
queries view
How should you reference the FirstName field on a Contact? - Answer-
Contact#FirstName
Use caution when using: - Answer-Contains(). You should use it IN ADDITION to an
initial predicate that uses an index.
Which entity column attribute must be typically set to true when compareIgnoreCase() is
used? - Answer-supportsLinguisticSearch
What table alias name is used for a row query in the context info? - Answer-qRoot
When would you use a row query instead of an entity query? - Answer-- When the
performance of an entity query is inadequate
- When you want to reduce the number of implicitly executed queries
- When you want to use aggregate functions
What is a row query? - Answer-A row query uses a single database query on both the
main entity and related entities to provide only the subset of properties that you need.
How do you select the rows? - Answer-QuerySelectColumns.Path
QuerySelectColumns.PathWithAlias
What are the basics of DB Querying??? - Answer-Do it in the DB when you can, and be
careful about dot notation! Do filtering in the DB rather than in memory.
Things to avoid: (filtering entities on databse) - Answer-- using deprecated intersect()
method
- subselect under an or
- where()
- hasMatch()
- countWhere() / Counting results (let the DB query)
- toCollection()
- toList()
iteration over entities from DB to count
QUESTIONS WITH CORRECT ANSWERS
When would you use a row query instead of an entity query? - Answer-1. When the
performance of an entity query is inadequate
2. when you want to reduce the number of implicitly executed queries
3. When you want to use aggregate functions
Where does clicking the "Show Queries" button take you? - Answer-The aggregated
queries view
How should you reference the FirstName field on a Contact? - Answer-
Contact#FirstName
Use caution when using: - Answer-Contains(). You should use it IN ADDITION to an
initial predicate that uses an index.
Which entity column attribute must be typically set to true when compareIgnoreCase() is
used? - Answer-supportsLinguisticSearch
What table alias name is used for a row query in the context info? - Answer-qRoot
When would you use a row query instead of an entity query? - Answer-- When the
performance of an entity query is inadequate
- When you want to reduce the number of implicitly executed queries
- When you want to use aggregate functions
What is a row query? - Answer-A row query uses a single database query on both the
main entity and related entities to provide only the subset of properties that you need.
How do you select the rows? - Answer-QuerySelectColumns.Path
QuerySelectColumns.PathWithAlias
What are the basics of DB Querying??? - Answer-Do it in the DB when you can, and be
careful about dot notation! Do filtering in the DB rather than in memory.
Things to avoid: (filtering entities on databse) - Answer-- using deprecated intersect()
method
- subselect under an or
- where()
- hasMatch()
- countWhere() / Counting results (let the DB query)
- toCollection()
- toList()
iteration over entities from DB to count
