CIW CIW Certifications 1D0-437 Questions & Answers

• Question 61:

  Which of the following correctly creates a SQL statement that will insert the values of the $name and $age variables into a database? The statement is assigned to the $sqlStmt variable. Assume a CHAR data type for $name and an INT data type for $age.

  A. $sqlStmt = q{INSERT INTO aTable (NAME, AGE) VALUES ($name, $age)};

  B. $sqlStmt = q{INSERT INTO aTable (NAME, AGE) VALUES ($name\, $age)};

  C. $sqlStmt = qq{INSERT INTO aTable (NAME, AGE) VALUES ($name, $age)};

  D. $sqlStmt = qq{INSERT INTO aTable (NAME, AGE) VALUES (\$name\, $age)};

  Correct Answer: C

• Question 62:

  Consider the following program code:

  %color = (sun => yellow, apple => red);

  reverse(%color);

  @colorKeys = sort(keys(%color));

  foreach(@colorKeys)

  {

  print($color{$_} . );

  }

  What is the result of executing this program code?

  A. The code will output the following: apple sun

  B. The code will output the following: sun apple

  C. The code will output the following: red yellow

  D. The code will output the following: apple red sun yellow

  Correct Answer: C

• Question 63:

  Which line of code represents the correct syntax to establish a reference to adatabase handle?

  A. $dbh = DBI::connect("dbi:mysql:myPhoneBook");

  B. $dbh = DBD:->connect("dbi::mysql::myPhoneBook");

  C. $dbh = DBD::connect("mysql:dbi:myPhoneBook");

  D. $dbh = DBI->connect("dbi:mysql:myPhoneBook");

  Correct Answer: D

• Question 64:

  Consider the following program code:

  @array = ("Y", "W", "X");

  @array = sort(@array);

  unshift(@array, "Z");

  print(@array[0]);

  What is the output of this code?

  A. W

  B. X

  C. Y

  D. Z

  Correct Answer: D

• Question 65:

  Consider the following program code:

  $x = 10;

  LOOP: while ($x < 15)

  {

  print ($x );

  if ($x >= 14 andand $x <= 20)

  {

  $x += 2;

  redo LOOP;

  } else { $x++; } } What is the result of executing this program code?

  A. The code will output the following: 11 12 13 14 15 16 17 18 19

  B. The code will output the following: 10 11 12 13 14 16 18 20 22

  C. The code will output the following: 10 11 12 13 14 16 18 20

  D. The code will output the following: 10 11 12 13 14 15 16 17 18 19 20

  Correct Answer: B

• Question 66:

  Which one of the following choices lists valid assertions that represent places within a string?

  A. \b, \B, \x, \X

  B. \A, \B, \Z, \G

  C. \z, \Z, \g, \y D. \Y, \X, \Z, \A

  Correct Answer: B

• Question 67:

  Consider the following program code:

  $Animal = Dogs bark;

  package Cat;

  $Animal = Cats purr;

  {

  package Fish;

  $Animal = Fish swim;

  } p

  ackage main;

  print $Animal;

  What is the result of executing this program code?

  A. The code will fail at line 4.

  B. The code will output the following: Dogs bark

  C. The code will output the following: Cats purr

  D. The code will output the following: Fish swim

  Correct Answer: B

• Question 68:

  Running your Perl scripts with a w switch will perform which task?

  A. Print all commands to the screen

  B. Print warnings to the error.log file

  C. Print check points in loops

  D. Print warnings to the screen

  Correct Answer: D

• Question 69:

  Consider the following program code:

  if ("Apple" gt "Pear")

  {

  print("True ");

  }

  else { print("False "); } if ("Banana" le "Banana") { print("True "); } else { print("False "); } What is the result of executing this program code?

  A. False False

  B. False True

  C. True False

  D. True True

  Correct Answer: B

• Question 70:

  Which statement will open the /etc/passwd file for reading only?

  A. open(PASSFILE "+>/etc/passwd");

  B. open(PASSFILE, "/etc/passwd");

  C. open(PASSFILE "+

  D. open(PASSFILE, ">/etc/passwd");

  Correct Answer: B