Skills Test Answers - Zoho Creator

Sorting allows users to do which of the following?

Rearrange data only in descending order
Rearrange data in ascending, descending, by any one or multiple columns
Rearrange data only in ascending order
Rearrange data by only one column



Which of the following is valid syntax for a String List?

("Dog", "Cat", "Duck")
{"Dog", "Cat", "Duck"}
[Dog, Cat, Duck]
{Dog, Cat, Duck}



The area into which users enter data is called?

A Folder
A List
a Form
A Subset



Which of these is not an action on a form?

Circling
Deleting
Adding
Editing



What is the maximum length of a text-type field?

55
155
265
255



Which of these is not a feature in Data Views?

Summary
Paraphrase
List
Grid



Which of the following application components can NOT be embedded on a web page?

Pages
Forms
Script Builder
Reports



Forms can be shared with whom?

Groups Only
Individuals Only
Business contacts
Individuals and Groups



In Zoho CRM data will be categorized into which of these?

Vendors only
Contacts, Leads, and Potentials
Leads only
Contacts only



Which of these is not a Condition classification?

else
else if
if
of course



What role do Dynamic Picklists serve?

List only categories
List categories and subcategories
Delete lists
List only subcategories



What does the Custom Button do?

Removes all actions
Perform infinite actions
Redefines action over time
Perform any action specified



What data object type is an input value for an Email Address field?

Float
Long
String
Map



Worflow is defined as which of the following?

A set of rules you learn
A set of rules you bend
A set of rules you define
A set of rules you break



What is a "Stateless Form"?

A form that does not automatically save information unless scripted to do so
A form that embeds within another form
The form that appears when you click 'Edit' on a record within a report
A form that creates a new Zoho Creator account



Apps can be shared with how may users?

5 users only
any amount of users
10 users per application
1 user per application



Modifcations to applications are changed in how much time?

Next day
Instantly
At least 1 hour
At least 5 minutes



Zoho Creator empowers users to most effectively do which of the following?

Build a fan base
Build applications
Build a work ethic
Build a team



Only pay for the service you use with this system?

1 time flat fee
Pay as you Go
Bi-Annual subscriptions
Annual subscriptions



Graphical interpretation of data is best used for this?

edit reports
Checking information errors
Analyzing information
Ignoring trends



Which of these is not a basic field?

Currency
Number
Formula
Email



What is the variable type of a form object parameter when being passed to an HTML Page?

Int
Float
Bool
String



What is the maximum number of emails that can be sent with a single form action?

As many as the application owner's subscription tier and scripting limit will allow
300
As many as desired by the user
10



With which other Zoho office product does Creator have an available form field type to pull information from a linked Zoho account?

Zoho Sheet
Zoho CRM
Zoho People
Zoho Support



View filters are best used for what purpose?

list all data
delete data
Restrict data to a criteria
analyze data



What is the Deluge script value for a Decision Box field that has been checked?

0
1
"TRUE"
"FALSE"



Which of the following is NOT a valid conditional control statement type?

Else
Then
Else If
If



Conditional statements are what kind of statements?

If not
If because
If else
If so



Which of the following is NOT a valid argument type for a function?

print
int
bool
string



Which of these programs must you learn to use Zoho Creator?

Javascript
None of these
C++
HTML



Which of these is not a Zoho integration program?

Zoho Invoice
Zoho Reports
Zoho Evolve
Zoho CRM



Which of the following file types is supported for data importing?

.ps
.pdf
.xlx
.doc



A one-to-one Lookup field creates a relationship between how many forms?

4
3
2
10



Zoho Creator is known for being all but the following

Accessible
Hard to use
Collaborative
Customizable



Which of these is not an advanced field?

Checkbox
Subform
Formula
Lookup



A one-to-many relationship can be made using either of these two fields?

text field or email field
currency field or decimal field
url field or number field
subform field or bi-directional lookup field



What is the Deluge Script terminology for the data object type referred to in other computer languages as an 'array'?

List
Schedule
Summary
Report



Which of the following script components MUST be included a "fetch records" collection variable?

A range
A field value
A sort column
Criteria to filter the records



What is the default field display type when a lookup field is created?

Drop-down
Multi-Select
Radio
Checkbox



Using multi-select on two forms establishing what kind of relationship?

many-to-many
many-to-one
one-to-many
many-to-none



Which of the following user role types can NOT edit an application?

Developer
User
Zoho Support
Application Owner



What is the proper synax for concatenating several strings into one?

New, York, City
{"New ","York ","City"}
"New " + "York " + "City"
"New "&"York "&"City"



Which of the following actions can be invoked on form validate?

enable/disable
show/hide
Send Email
add/append item



Grouping categorizes records based on which of the following?

Value of the most used fields
Value of only Lookup Fields
Value of the least used fields
Value of any field



Which of these is not a Zoho schedule type?

Group
Custom
Form
Report



Which of the following script components MUST be included a "fetch records" list variable?

A sort column
A field value
A range
An index



Workflow helps to achieve all of the following except?

Increase redundancies
Eliminate manual involvement
Easily build scripts
Automate tasks



Which script function would you use in trying to determine an item's position in a list?

.posOf()
.getIndexOf()
.indexOf()
.get()



Collected data can be imported using all but which file type?

XLS
MDB
JPG
Spreadsheet



Which of the following file types is NOT supported for data exporting?

.doc
.pdf
.csv
.xlx



What is the default amount of records created shown in a newly-created report?

200
20
10
50



Which of the following is NOT a valid aggregation variable?

x = Form_A [Score != null].avg(Score);
x = Form_A [ID != 0].count();
x = Form_A [Value != 0].exp(Value);
x = Form_A [Amount > 0].sum(Amount);



Which of the following components' visibilities can NOT be changed via the 'share/unshare' script action?

Sections
Form Field
Forms
Reports



What is the maximum amount of columns a form can have?

One
Three
Two
Four



Zoho permissions will allow users to do share what?

Sharing only full applications
Share even a module of an application
Share only one application at a time
Share only two modules of an application



Where are saved form input values stored in Zoho Creator?

On your hard drive
In the report tables
In your SQL Database
In the form fields themselves



Which of these is not a viable field type?

Quickbox
Percentage
Radio
Dropdown



What is the maxium number of rows visible in a single page of a grid report type?

30
25
15
40



Which of the following is NOT a valid OpenURL script action argument?

Same window
New Browser
New window
iframe



For application deployment you need which of the following?

Time to check saved features
Time to update manually
No maintenance downtime
Time to install patches



Which of the following strings would require to be re-formatted if used as a URL Parameter?

Mike & Matt
Mike_And_Matt
Mike And Matt
Mike@MikeAndMatt.com



What is the automatic form sharing setting?

Private
Friends
Public
Business contacts only



Which of the following is NOT a valid built-in string function in Deluge?

remove()
substring(,)
toUpperCase()
replaceAny()



What data object type is an input value for a Date-Time field?

Time
Date
Long
Date-Time



Which of the following is a valid built-in List function in Deluge?

.toDate()
.newList()
.toLong()
.size()



Filters are created for all but the following?

Lookup fields
Drop down lists
Single-select fields
Date-Time fields



Reports are customizable via which options?

tables and labels
Pivot charts and Records
Pivot charts and tables
Records and tables



Since Zoho Creator's 2013 App Builder Update, what is the variable type of a checkbox or multi-select lookup field's selection when referring to another record?

List:Bool()
List:String()
List:Float()
List:Int()



Which of the following field types can used be when a user updates/edits a record?

Multi-Line
ID
Added Time
Added User



If no grouping or sorting is applied to a report, what is the default order in which record rows are displayed in that report?

Most Recently Updated Records, Ascending
Most Recently Added Records, Descending
Most Recently Updated Records, Descending
Most Recently Added Records, Ascending



Zoho Creator supports how many advanced fields

15
5
20
10



Which option allows data from one form to be used in another form?

Double-select Lookup Fields
Uni-select Lookup Fields
All-select Lookup fields
Single-select Lookup fields



What data object type is an input value for a Drop-Down List field?

List
Map
List:String()
String



Since Zoho Creator's 2013 App Builder Update, what is the variable type of a drop-down or radio lookup field's selection when referring to another record?

The value of the field referred to in the lookup display
ID
Added_Time
zoho.loginuserid



The Drag and Drop function can be used to do all but the following?

build scripts
build trends
build forms
select required fields



Which of the following script components MUST be included a "for each record" iteration?

A range
A row variable
A sort column
Criteria to filter the records



Which of the following script actions requires a semicolon (;) to be added at the end of the script line?

An iteration
An individual "Add New Record" insertion value
A conditional control statement
A fetch variable



Which of the following-script commands would you NOT use to turn a string that says "D-U-C-K" into "DUCK"?

("D-U-C-K").getAlpha()
("D-U-C-K").replaceAll("-","")
("D-U-C-K").removeAll("-")
("D-U-C-K").trim("-")



Zoho Creator supports how many data types?

15
12
18
10



How many tasks can be performed at different stages of your application?

30
20
40
10