CIW 1D0-437 Online Practice Questions and Exam Preparation

CIW 1D0-437 Online Questions & Answers

• Question 1:

  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";
  D. print OUTPUT "Here's my data.\n";

• Question 2:

  Consider the following program code:

  %employees = ("Lucy", "Accounting", "Armando", "Finance",

  "Adrienne", "Marketing");

  delete($employees{"Lucy"});

  Which of the following lines of code has the same effect as the preceding code?

  A. %employees = ("Adrienne", "Marketing");
  B. %employees = ("Lucy", "Accounting");
  C. %employees = ("Lucy", "Accounting", "Armando", "Finance");
  D. %employees = ("Armando", "Finance", "Adrienne", "Marketing");
  D. %employees = ("Armando", "Finance", "Adrienne", "Marketing");

• Question 3:

  Consider the following code:

  $_ = "New York";

  @array2 = split(//);

  What is the value of $array2[0] after the code is executed?

  A. ""
  B. "N e w"
  C. "NewYork"
  D. "N"
  D. "N"

• Question 4:

  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 5:

  Which line of code represents the correct syntax to establish a reference to a database 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");
  D. $dbh = DBI->connect("dbi:mysql:myPhoneBook");

• Question 6:

  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;
  D. s/perl/Perl/g;

• Question 7:

  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)};
  C. $sqlStmt = qq{INSERT INTO aTable (NAME, AGE) VALUES ($name, $age)};

• Question 8:

  Consider the following program code:

  if ("cool" =~ m/[cool]{4}/)

  {

  print("True ");

  }

  else

  {

  print("False ");

  }

  if ("cool" =~ m/[col]{4}/)

  {

  print("True ");

  }

  else

  {

  print("False ");

  }

  What is the output of this code?

  A. False False
  B. False True
  C. True False
  D. True True
  D. True True

• Question 9:

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

  

  A. The code will output the following: Bumblebee
  B. The code will output the following: HumhlHee
  C. The code will output the following: BumblHee
  D. The code will output the following: HumblHee
  D. The code will output the following: HumblHee

• Question 10:

  Which one of the following choices uses the correct syntax for a valid array assignment?

  A. @cities = Akron, Memphis, Ogden, Phoenix;
  B. @cities =~ ("Akron, Memphis");
  C. @cities =~ (Akron, Memphis, Ogden, Phoenix);
  D. @cities = ("Akron");
  D. @cities = ("Akron");