Question 1

Consider the following program code:

%hash = (small => 8oz,

medium => 16oz, large => 32oz);

@keys = sort(keys(%hash));

for ($i = 0; $i < 3; $i++) {

print($hash{$keys[$i]}\n);

}

What is the result of executing this program code?

AThe code will fail at line 1 because a hash cannot contain both numeric and string data

BThe code will execute without error but will output nothing.

CThe code will output the following: 32oz 16oz 8oz

DThe code will output the following large medium small

Answer : C

Question 2

Consider the following program code:

$y=l; $x = 2; $z = 3;

{

print ($y); } while ($y eq 2);

{

print ($x); } until ($x eq 2);

print ($z);

What is the result of executing this program code?

AThe code will output the following: 1 23

BThe code will output the following 3

CThe code will output the following 23

DThe code will output the following 32 1

Answer : A

Question 3

Assume $sth is a valid statement handle. Which of the following correctly outputs the data from

the first three columns of a result set?

Awhile(@rcrds = $sth->fetch_array)
{
print($rcrds[0]\n);
print($rcrds[1]\n);
print($rcrds[2]\n); }

Bwhile(@rcrds = $sth->fetch_array)
{
print($rcrds[1]\n);
print($rcrds[2]\n);
print($rcrds[3]\n);
}

Cwhile(@rcrds = $sth->fetchrow_array)
{
print($rcrds[1]\n);
print($rcrds[2]\n);
print($rcrds[3]\n);
}

Dwhile(@rcrds = $sth->fetchrow_array)
{
print($rcrds[0]\n);
print($rcrds[1]\n);
print($rcrds[2]\n);
}

Answer : D

Question 4

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

Attext 20

Bttex 19

Cttext 19

Dttex 20

Answer : D

Question 5

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

ADisconnect=>$dbh;

Bdisconnect$dbh;

C$dbh->disconnect;

Dclose($dbh);