CIW PERL FUNDAMENTALS (1D0-437) Free Practice Test

Question 1

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;

Correct Answer: D

Question 2

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 fail at line 3 because $y contains string data.

C. The code will output the following:
125

D. The code will output the following:
75

Correct Answer: D

Question 3

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

Correct Answer: C

Question 4

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

D. The code will output the following:
50

Correct Answer: B

Question 5

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

Correct Answer: C

Question 6

The filehandle INPUT is associated with the file represented by $file. Which statement will close the filehandle INPUT?

A. INPUT(close, $file);

B. close(INPUT);

C. closeINPUT;

D. close (INPUT, $file);

Correct Answer: B

Question 7

Consider the following code:
@cities = qw( Pittsburgh Atlanta Nashville Boston );
$city = join (":", @cities);
What is the value of $city after the code is executed?

A. PittsburghAtlantaNashvilleBoston

B. Pittsburgh:Atlanta:Nashville:Boston

C. Pittsburgh Atlanta Nashville Boston

D. Pittsburgh, Atlanta, Nashville, Boston

Correct Answer: B

Welcome to TestSimulate

CIW PERL FUNDAMENTALS (1D0-437) Free Practice Test