Adobe ACE ColdFusion 9A0-127 Questions & Answers

• Question 61:

  Given the following code:

  select *

  from category

  where categoryid in

  Which command results in a successful query execution?

  A. ( )

  B. ()

  C. ()

  D. ()

  Correct Answer: A

• Question 62:

  Which three isolation attributes allow dirty read, non-repeatable read, or phantom? (Choose three.)

  A. read_committed

  B. repeatable_read

  C. serializable

  D. read_uncommitted

  Correct Answer: ABD

• Question 63:

  Which use of in a WHERE clause successfully filters a column named RECORDID to retrieve rows with primary key values that match a set of values in a list?

  A. WHERE recordid IN ()

  B. WHERE recordid IN (

  C. WHERE recordid IN ()

  D. WHERE recordid IN

  Correct Answer: A

• Question 64:

  What is the required data type of the tag NESTED attribute?

  A. Boolean

  B. String

  C. Date/Time

  D. Numeric

  Correct Answer: A

• Question 65:

  Your application has the following query that is running slowly: SELECT * FROM ...

  You want to know the amount of time the query takes so you can log it.

  Which variable contains the length of time the query took to run?

  A. data.executionTime

  B. result.data.executionTime

  C. result.timeExecution

  D. data.recordcount

  Correct Answer: A

• Question 66:

  You capture the RESULT structure of a query that performs an INSERT, UPDATE, or DELETE operation. What does the structure's RECORDCOUNT property represent?

  A. the number of rows in the table after the query is executed

  B. the number of rows in the table before the query is executed

  C. different values for the INSERT, UPDATE or DELETE operations

  D. the number of rows affected by the query

  Correct Answer: D

• Question 67:

  Which tag successfully queries data from a query object named qData?

  A. SELECT * FROM PEOPLE ORDER BY FIRSTNAME

  B. SELECT * FROM qData ORDER BY FIRSTNAME

  C. SELECT * FROM PEOPLE ORDER BY FIRSTNAME

  D. SELECT * FROM qData ORDER BY FIRSTNAME

  Correct Answer: B

• Question 68:

  In your application you run the following query:

  SELECT id, name, email FROM users;

  Which query tag allows you to query the results of the getUsers query?

  A.

  B.

  C.

  D.

  Correct Answer: B

• Question 69:

  Click the Exhibit button.

  

  The table person contains the data shown in the exhibit. You have issued the following query:

  select *

  from person

  where lastname like

  Which ColdFusion expression safely parameterizes the query to return all records that have lastnames starting with data input to a form field (form.search)?

  A.

  B.

  C.

  D.

  Correct Answer: C

• Question 70:

  You are using cfquery to access a database.

  Which SQL clause allows you to modify records already stored in the database?

  A. UPDATE

  B. SELECT

  C. INSERT

  D. DELETE

  Correct Answer: A