CIW 1D0-437 問題集

質問 1：
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->prepare(SELECT * FROM aTable);
$ sth->execute;
B. $sth = $dbh->prep_statement(SELECT * FROM aTable);
$ sth->execute_statement;
C. $sth = $dbh->prepare_statement(SELECT * FROM aTable);
$ sth->execute_statement;
D. $sth = $dbh->prep_statement(SELECT * FROM aTable);
$ sth->execute;
正解：A

質問 2：
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
20
C. t text
19
D. t tex
19
正解：B

質問 3：
Consider the following program code:
$x = 150;
$y = "250";
if (($x + 100) == $y) { print("1 "); }
if ("250" == $y) { print("2 "); }
if ("250" eq $y) { print("3 "); }
if ($x lt $y) { print("4 "); }
if ($x ge $y) { print("5 "); }
What is the result of executing this program code?
A. The code will output the following:
1 3 4
B. The code will output the following:
1 2 3 4 5
C. The code will output the following:
1 3 5
D. The code will output the following:
1 2 3 4
正解：D

質問 4：
Yngve wants to define a character class that includes any alphanumeric word characters.
Which one of the following choices is best suited for this requirement?
A. /[^0-Z$]/;
B. /[a-zA-Z_0-9]/;
C. /[^a-zA-Z_0-9]/;
D. /^w/;
正解：B

質問 5：
Consider the following program code:
1.$x = 100;
2.$y = "-25";
3.$sum = $x + $y;
4.
5.print $sum;
What is the result of executing this program code?
A. The code will output the following:
100-25
B. The code will output the following:
125
C. The code will output the following:
75
D. The code will fail at line 3 because $y contains string data.
正解：C

質問 6：
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. True True
B. False False
C. False True
D. True False
正解：A

質問 7：
Consider the program code in the attached exhibit. What is the result of executing this program code?

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