1D0-437 Online Practice Questions and Answers

Consider the following program code:

$y = 1;

$x = 2;

$z = 3;

do

{

print ($y );

} while ($y eq 2);

do

{

print ($x );

}

until ($x eq 2);

print ($z );

What is the result of executing this program code?

A. The code will output the following: 1 2 3

B. The code will output the following: 3

C. The code will output the following: 2 3

D. The code will output the following: 3 2 1

Consider the following code:

$_ = "New York";

@array2 = split(//);

What is the value of $array2[0] after the code is executed?

A. ""

B. "N e w"

C. "NewYork"

D. "N"

Which Perl debugger commands can be used to step through a script?

A. b and d

B. t and c

C. s and n

D. X and V

Which statement will open the /etc/passwd file for reading only?

A. open(PASSFILE "+>/etc/passwd");

B. open(PASSFILE, "/etc/passwd");

C. open(PASSFILE "+

D. open(PASSFILE, ">/etc/passwd");

Consider the following program code:

$x = 10;

LOOP: while ($x < 15)

{

print ($x );

if ($x >= 14 andand $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

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

Regular expressions are best used for which task?

A. To perform arithmetic functions

B. To determine whether a string matches a specific pattern

C. To perform spelling checks within text files

D. To output data to a text file

Consider the following lines of code:

$_ = "This is a test";

s/^([^ ]*)\s*([^ ]*)/$2 $1/;

print;

What is the output of these lines of code?

A. h Tis a test

B. is This a test

C. i Thiss a test

D. his T is a test

Which of the following choices demonstrates the correct syntax to pass the argument $arg2 to the subroutine getpass?

A. getpass($arg2);

B. call andgetpass($arg2);

C. sub andgetpass($arg2);

D. call getpass($arg2);

Which of the following describes the functionality of the DBI tables method?

A. The tables method returns a list of all system tables in a database.

B. The tables method returns a list of all user-defined tables in a database.

C. The tables method returns a list of all tables in a database.

D. The tables method returns a list of all related tables in a database.