check

Query Writing Quiz

How good are your query writing skills?

10 questions
get 8 correct to pass

Click the button below to start.

Start

Question 1 of 10

How many parts does a single query string contain?

A

It depends on the formula

B

3 - the fid, operator, and value

C

5 - the fid, dbid, operator, separator, and value

Question 2 of 10

What operator indicates "Does not start with"

A

SW

B

NSW

C

XSW

D

XEX

Question 3 of 10

True or False, all operators must be capitalized.

A

True

B

False

Question 4 of 10

True or False, you cannot use a field reference in a query string (in a formula).

A

True

B

False

Question 5 of 10

Which operators can be used in between multiple query strings?

(Select all that apply)
A

EX

B

OR

C

HAS

D

AND

E

OBF

Question 6 of 10

Which query string is in the correct format?

A

{22.EX.On Time}

B

{_fid_22.EX.'On Time'}

C

{22.EX.'On Time'}

D

{22.ex.'On Time'}

Question 7 of 10

Where might query strings be used?

(Select all that apply)
A

Pipeline Advanced Query

B

Formulas

C

URLs

D

Report links

E

Webhooks

F

Summary fields

Question 8 of 10

How is the order of operation determined when multiple query formulas are joined with AND/OR?

A

The placement of commas between the query strings.

B

The use of curly brackets "{ }" around the strings.

C

The placement of parentheses "( )" around the query strings.

D

The line order from top to bottom.

Question 9 of 10

Which sentence best describes this query: ({16.IR.'today'}OR{16.IR.'yesterday'})AND{50.CT.'Not Started'}

A

Field ID 16 is before today or yesterday, and field ID 50 contains "Not Started".

B

Field ID 16 is during today, or field 16 is during yesterday and field ID 50 contains "Not Started".

C

Field ID 16 is during today or yesterday, and field ID 50 contains "Not Started".

D

None of the above

Question 10 of 10

I can get more information on writing queries from...

(Select all that apply)
A

Quick Base Junkie

B

Quickbase

C

The back of a cereal box

Confirm and Submit