Adobe ACE ColdFusion 9A0-127 Questions & Answers

• Question 71:

  Your application accesses a table named users to retrieve data. The users table has three columns: id of type int, name of type string, and email of type string. Which SQL statement retrieves the user with an ID value of 3?

  A. SELECT * FROM users WHERE id = '3'

  B. SELECT * FROM users WHERE ids = 3

  C. SELECT * FROM users WHERE id = 3

  D. SELECT * FROM users WHICH id = 3

  Correct Answer: C

• Question 72:

  Which command successfully inserts a row of data into a table with an automatically generated incremental primary key column named RECORDID and two String columns named FIRSTNAME and LASTNAME?

  A. INSERT INTO PEOPLE (recordid, firstname, lastname) VALUES (nextValue, 'Joe', 'Smith')

  B. INSERT INTO PEOPLE (firstname, lastname) VALUES ('Joe', 'Smith')

  C. INSERT INTO PEOPLE (firstname, lastname) VALUES ("Joe", "Smith")

  D. INSERT INTO PEOPLE (firstname, lastname) ('Joe', 'Smith')

  Correct Answer: B

• Question 73:

  Given the following Application.cfc file:

  If accessed from a cfm page, what is the value of application.myVar?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: A

• Question 74:

  When your application is accessed for the first time, you must set initial data.

  Which method of Application.cfc should be used to detect the first request in a visit of a user?

  A. onApplicationStart

  B. onRequestStart

  C. onServerStart

  D. onSessionStart

  Correct Answer: D

• Question 75:

  The following code is placed in Application.cfc, outside of any function definitions:

  What is the scope and visibility of the variable?

  A. Request scope; visible to all code executed during the current page request

  B. Application scope; visible to code in all pages of the application

  C. This scope; visible as public properties of the CFC

  D. Variables scope; visible only to code in Application.cfc

  Correct Answer: D

• Question 76:

  The following Application.cfc file is placed in the application root folder:

  On Request
  On Request Start

  A CFM page in the application root folder contains the following HTML and text:

  Current Page

  When you browse the CFM page, what is the output?

  A. On Request Start On Request

  B. On Request On Request Start

  C. On Request Current Page On Request

  D. On Request Start On Request Current Page

  Correct Answer: A

• Question 77:

  What is the order of precedence (greatest to least) for execution of the , onError(), and / error handling strategies?

  A. onError, cftry, cferror

  B. , onError(),

  C. , onError(),

  D. , , onError()

  Correct Answer: B

• Question 78:

  You are using the onError method of Application.cfc.

  Which two types of arguments can be passed to the onError method? (Choose two.)

  A. String

  B. Array

  C. Struct

  D. CFerror

  E. CFcatch

  Correct Answer: AC

• Question 79:

  Which font is NOT supported by ?

  A. Arial

  B. Times

  C. Comic Sans MS

  D. any font installed on the server is supported

  Correct Answer: D

• Question 80:

  What is the default format of charts generated by the tag?

  A. jpg

  B. png

  C. flash

  D. gif

  Correct Answer: C