CIW 1D0-437 Exam
CIW Perl Fundamentals exam (Page 3 )

Updated On: 1-Feb-2026

Which of the following accurately describes the roles of the Database Interface Module (DBI) and the Database Driver Module (DBD)?

  1. DBI transmits instructions to a database; DBD directs method calls to DBI.
  2. DBD transmits instructions to a database; DBI directs method calls to DBD.
  3. DBI makes available database-specific code; DBD transmits method calls to DBI.
  4. DBD makes available database-specific code; DBI translates method calls to DB

Answer(s): B



Consider the following program code:
@array = ("one", "two");
push(@array, "three");
shift(@array);
unshift(@array, "four");
pop(@array);
print($array[0]);
What is the output of this code?

  1. one
  2. two
  3. three
  4. four

Answer(s): D



Which of the following choices demonstrates the proper way to close a database connection given that$dbh is the database handle?

  1. Disconnect=>$dbh;
  2. disconnect$dbh;
  3. $dbh->disconnect;
  4. close($dbh);

Answer(s): C



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);

  1. ttext 20
  2. ttex 19
  3. ttext 19
  4. ttex 20

Answer(s): D



Assume $sth is a valid statement handle.
Which of the following correctly outputs the data from the first three columns of a result set?

  1. while(@rcrds = $sth->fetch_array)

    {
    print($rcrds[0]\n);
    print($rcrds[1]\n);
    print($rcrds[2]\n); }
  2. while(@rcrds = $sth->fetch_array)
    {
    print($rcrds[1]\n);
    print($rcrds[2]\n);
    print($rcrds[3]\n);
    }
  3. while(@rcrds = $sth->fetchrow_array)
    {
    print($rcrds[1]\n);
    print($rcrds[2]\n);
    print($rcrds[3]\n);
    }
  4. while(@rcrds = $sth->fetchrow_array)
    {
    print($rcrds[0]\n);
    print($rcrds[1]\n);
    print($rcrds[2]\n);
    }

Answer(s): D



Viewing page 3 of 21
Viewing questions 11 - 15 out of 99 questions



Post your Comments and Discuss CIW 1D0-437 exam prep with other Community members:

Join the 1D0-437 Discussion