Latest 1D0-437 Exam Study Guides With New Update Exam Questions

Question No: 2

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?

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

B. The code will execute without error but will output nothing.

C. The code will output the following: 32oz

16oz 8oz

D. The code will output the following: large

medium small

Question No: 3

Consider the program code in the attached exhibit. What is the result of executing this program code?

A. The code will output the following: 50

B. The code will output the following: 0

C. The code will output the following: 5

D. The code will output the following: multiply(5, 10)

Question No: 4

Which of the following choices demonstrates the correct syntax for creating a hash?

A. %passwds = ("denise", "robert", "yolanda") => ("pass1", "pass2", "pass3");

B. %passwds() = ("denise", "pass1", "robert", "pass2", "yolanda", "pass3");

C. %passwds = (denise=> "pass1", robert=> "pass2", yolanda=> "pass3");

D. %passwds{3} = ("denise", "robert", "yolanda") => ("pass1", "pass2", "pass3");

Question No: 5

Which of the following choices demonstrates the correct syntax to pass a reference to a subroutine?

A. \@array4;

B. @array4($ref);

C. getpass(\@array4);

D. getpass{@array4};

Question No: 6

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

A. close (INPUT, $file);

B. closeINPUT;

C. INPUT(close, $file);

D. close(INPUT);

Question No: 7

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

Question No: 8

Consider the following program code:

@array = (10, Masami, 10..13, Niklas); for ($i = 1; $i < $#array; $i++)

{

print($array[$i] );

}

What is the result of executing this program code?

A. The code will output the following: Masami 10 11 12 13

B. The code will output the following: 10 Masami 10 11 12 13

C. The code will output the following: 10 Masami 11 12 13 Niklas

D. The code will output the following: Masami 10 11 12 13 Niklas

Question No: 9

Consider the following program code:

1.$x = 100;

2.$y = 15;

3.$result = $x % $y; 4.

5.print $result;

What is the result of executing this program code?

A. The code will fail at line 3 because % is a unary operator.

B. The code will output the following:

10E+16

C. The code will output the following: 10

D. The code will fail at line 5 because $result is not enclosed by parentheses.

Question No: 10

Consider the following program code:

$x = 10;

LOOP: while ($x < 15)

{

print ($x );

if ($x >= 14 && $x <= 20)

{

$x += 2; redo LOOP;

}

else

{

$x++;

}

What is the result of executing this program code?

A. The code will output the following: 11 12 13 14 15 16 17 18 19

B. The code will output the following: 10 11 12 13 14 16 18 20 22

C. The code will output the following: 10 11 12 13 14 16 18 20

D. The code will output the following: 10 11 12 13 14 15 16 17 18 19 20

Question No: 11

Which one of the following choices lists only valid expression operators?

A. + - ** // B. * ** / // C. ** / ++ % D. */ % -- **