1D0-437 Exam - CIW PERL FUNDAMENTALS

Question No: 2

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

A. Disconnect=>$dbh;

B. disconnect $dbh;

C. $dbh->disconnect;

D. Close($dbh);

View Answer

Question No: 3

Consider the following program code:

%color = (sun => yellow, apple => red); reverse(%color);

@colorKeys = sort(keys(%color)); foreach(@colorKeys)

{

print($color{$_} . );

}

What is the result of executing this program code?

A. The code will output the following: apple sun

B. The code will output the following: sun apple

C. The code will output the following: red yellow

D. The code will output the following: apple red sun yellow

View Answer

Question No: 4

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

A. print ("capital"=>$kansas);

B. print {$kansas}=>(capital);

C. print (capital)<={$kansas};

D. print $kansas->{"capital"};

View Answer

Question No: 5

Which one of the following statements uses correct syntax and expressions?

A. do (print "Hello $a") until ($a = 10);

B. do {$a++} until {$a == $b}\;

C. do {$in = $in++} while ($in < 100);

D. do ($a++) until ($b = $a);

View Answer

Question No: 6

Which one of the following while statements uses correct syntax and expressions?

A. while {0} (print "OK");

B. while ($c != 99) {print "OK"}

C. while {$b eq "OK"} (print "$a++");

D. while ($_) Do {print "OK");

View Answer

Question No: 7

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

View Answer

Question No: 8

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

View Answer

Question No: 9

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

View Answer

Question No: 10

Consider the following program code:

$Animal = Dogs bark; package Cat;

$Animal = Cats purr;

{

package Fish;

$Animal = Fish swim;

}

package main; print $Animal;

What is the result of executing this program code?

A. The code will fail at line 4.

B. The code will output the following: Dogs bark

C. The code will output the following: Cats purr

D. The code will output the following: Fish swim

View Answer

Question No: 11

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

View Answer