CIW Master CIW Enterprise Developer 1D0-437 Questions & Answers

• Question 1:

  Which of the following choices demonstrates the correct syntax to pass a reference to a subroutine?

  A. \@array4;

  B. @array4($ref);

  C. getpass(\@array4);

  D. getpass{@array4};

  Correct Answer: C

• Question 2:

  Which one of the following choices will replace all occurrences of the word perl with the word Perl?

  A. s/Perl/perl/I;

  B. s/"perl"/"Perl"/g;

  C. s/"perl"/"Perl"/;

  D. s/perl/Perl/g;

  Correct Answer: D

• Question 3:

  Which statement writes data to the filehandle OUTPUT?

  A. print "Here's my data.\n" > OUTPUT

  B. write OUTPUT "Here's my data.\n";

  C. write OUTPUT ">Here's my data.\n";

  D. print OUTPUT "Here's my data.\n";

  Correct Answer: D

• Question 4:

  Which of the following methods of calling a subroutine is not valid?

  A. $namex = getname();

  B. getname() = @array1;

  C. $yearstogo = $Retireage Currentage();

  D. $yearstogo = $Retireage Currentage($name);

  Correct Answer: B

• Question 5:

  Which of the following describes the functionality of the DBI tables method?

  A. The tables method returns a list of all system tables in a database.

  B. The tables method returns a list of all user-defined tables in a database.

  C. The tables method returns a list of all tables in a database.

  D. The tables method returns a list of all related tables in a database.

  Correct Answer: C

• Question 6:

  Consider the following lines of code: 1.$playerStr = "Today's player is Bob Petit."; 2.if($playerStr =~ /[Ruth|Gehrig|DiMaggio]/) {

  3. $game = "Baseball";

  4.}else{

  5. $game = "Basketball";

  6.}

  7.print $game;

  What is the output of these lines of code?

  A. No output is generated due to an error in line 2.

  B. Basketball

  C. Baseball

  D. No output is generated due to an error in line 3.

  Correct Answer: C

• Question 7:

  Which of the following code segments correctly readies a database query, creating a valid statement handle and a result set? Assume $dbh represents a valid database handle.

  A. $sth = $dbh->prep_statement(SELECT * FROM aTable); $sth->execute_statement;

  B. $sth = $dbh->prepare(SELECT * FROM aTable);$sth->execute;

  C. $sth = $dbh->prep_statement(SELECT * FROM aTable); $sth->execute;

  D. $sth = $dbh->prepare_statement(SELECT * FROM aTable); $sth->execute_statement;

  Correct Answer: B

• Question 8:

  Consider the following code:

  @cities = qw( Pittsburgh Atlanta Nashville Boston ); $city = join (":", @cities);

  What is the value of $city after the code is executed?

  A. PittsburghAtlantaNashvilleBoston

  B. Pittsburgh, Atlanta, Nashville, Boston

  C. Pittsburgh:Atlanta:Nashville:Boston

  D. Pittsburgh Atlanta Nashville Boston

  Correct Answer: C

• Question 9:

  Consider the following program code:

  $x = 5;

  $y = 10;

  while (++$x < 10 andand ++$y < 15)

  {

  print ($x $y );

  }

  print ($x $y );

  What is the result of executing this program code?

  A. The code will output the following: 6 11 7 12 8 13 9 14 10 15

  B. The code will output the following: 6 11 7 12 8 13 9 14 10 14

  C. The code will output the following: 5 10 6 11 7 12 8 13 9 13

  D. The code will output the following: 5 10 6 11 7 12 8 13 9 14

  Correct Answer: B

• Question 10:

  Consider the following code block:

  BEGIN {print ("Jan ");}

  BEGIN {print ("Feb ");}

  END {print ("Mar ");}

  END {print ("Apr ");} Print ("May ");

  What is the result of this code block?

  A. Jan Feb May Apr Mar

  B. Jan Feb Mar Apr May

  C. Mar Apr May Jan Feb

  D. May Jan Feb Mar Apr

  Correct Answer: A