CIW 1D0-437 Online Practice Questions and Exam Preparation

CIW 1D0-437 Online Questions & Answers

• Question 11:

  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;
  B. $sth = $dbh->prepare(SELECT * FROM aTable); $sth->execute;

• Question 12:

  Consider that a file named test.txt contains this line of text:

  One line of test text.

  What is the output of the following lines of code?

  $file = "test.txt";

  open (OUT, "<$file") || (die "cannot open $file: $!");

  seek(OUT, 15, 0);

  read(OUT, $buffer, 5);

  print $buffer . "\n";

  print tell(OUT);

  A. t text 20
  B. t tex 19
  C. t text 19
  D. t tex 20
  D. t tex 20

• Question 13:

  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};
  C. getpass(\@array4);

• Question 14:

  Which statement will print the capital attribute of the $kansas object?

  A. print ("capital"=>$kansas);
  B. print {$kansas}=>(capital);
  C. print (capital)
  D. print $kansas->{"capital"};
  D. print $kansas->{"capital"};

• Question 15:

  Consider the program code in the attached exhibit. What is the result of executing this program code?

  

  A. The code will output the following: 50
  B. The code will output the following: 0
  C. The code will output the following: 5
  D. The code will output the following: multiply(5, 10)
  B. The code will output the following: 0

• Question 16:

  Consider the following program code:

  package Dog;

  $string = Walk the dog.;

  if($string eq Walk the dog.)

  {

  package Cat;

  $string = Pet the cat.;

  print($string\n);

  }

  print ($string\n);

  What is the result of executing this program code?

  A. The code will output the following: Pet the cat.
  B. The code will output the following: Walk the dog.
  C. The code will output the following: Pet the cat. Walk the dog.
  D. The code will output the following: Walk the dog. Pet the cat.
  C. The code will output the following: Pet the cat. Walk the dog.

• Question 17:

  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
  C. Pittsburgh:Atlanta:Nashville:Boston

• Question 18:

  Consider the following program code:

  $var = 10;

  package Alpha;

  $var = 20;

  {

  package Beta;

  $var = 30;

  }

  package Gamma;

  $var = 40;

  {

  print $var;

  }

  What is the output of this code?

  A. 10
  B. 20
  C. 30
  D. 40
  D. 40

• Question 19:

  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
  A. Jan Feb May Apr Mar

• Question 20:

  Consider the following lines of code:

  $_ = "This is a test";

  s/^([^ ]*)\s*([^ ]*)/$2 $1/;

  print;

  What is the output of these lines of code?

  A. h Tis a test
  B. is This a test
  C. i Thiss a test
  D. his T is a test
  B. is This a test