1D0-437 Exam Dumps - CIW PERL FUNDAMENTALS

Go to page:

Question # 17

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.

$sqlStmt = q{INSERT INTO aTable (NAME, AGE) VALUES ($name, $age)};

$sqlStmt = q{INSERT INTO aTable (NAME, AGE) VALUES ($name\, $age)};

$sqlStmt = qq{INSERT INTO aTable (NAME, AGE) VALUES ($name, $age)};

$sqlStmt = qq{INSERT INTO aTable (NAME, AGE) VALUES (\$name\, $age)};

Full Access

Question # 18

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

\@array4;

@array4($ref);

getpass(\@array4);

getpass{@array4};

Full Access

Question # 19

Consider the following program code:

$x = 0;

$y = 5;

{

print ($x $y );

}

while (++$x < 5 && ++$y < 10);

print ($x $y );

What is the result of executing this program code?

The code will output the following:

1 6 2 7 3 8 4 8 5 10 6 11

The code will output the following:

0 5 1 6 2 7 3 8 4 9 4 9

The code will output the following:

0 5 1 6 2 7 3 8 4 9 5 10

The code will output the following:

0 5 1 6 2 7 3 8 4 9 5 9

Full Access

Question # 20

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-zA-Z_0-9]/;

/^w/;

/[^a-zA-Z_0-9]/;

/[^0-Z$]/;

Full Access

Question # 21

Consider the following lines of code:

@array1 = ("apples", "oranges", "pears", "plums");

foreach (@array1) {print "$_\n"};

What is the result of these lines of code?

applesorangespearsplums

apples oranges pears plums