New Questions 3

Which of the following accurately describes the roles of the Database Interface Module (DBI) and the Database Driver Module (DBD)?

A. DBI transmits instructions to a database; DBD directs method calls to DBI.

B. DBD transmits instructions to a database; DBI directs method calls to DBD.

C. DBI makes available database-specific code; DBD transmits method calls to DBI.

D. DBD makes available database-specific code; DBI translates method calls to DBD.

New Questions 4

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

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

New Questions 6

Consider the following code block: BEGIN {print ("Jan ");}

BEGIN {print ("Feb ");}

END {print ("Mar ");}

END {print ("Apr ");}

Print ("May ");

What is the result of this code block?

A. Jan Feb May Apr Mar

B. Jan Feb Mar Apr May

C. Mar Apr May Jan Feb

D. May Jan Feb Mar Apr

New Questions 7

Which statement will print the capital attribute of the $kansas object?

A. print ("capital"=>$kansas);

B. print {$kansas}=>(capital);

C. print (capital)<={$kansas};

D. print $kansas->{"capital"};

New Questions 8

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.

New Questions 9

In Perl, packages are used for which task?

A. To label a program

B. To encrypt a program

C. To create new keywords

D. To define a namespace

New Questions 10

Consider the following lines of code:

sub mySub {

$_ = @_[1];

$a = shift;

$b = shift;

return $a * $b * $_;

}

mySub(1,2,3);

What is the output of these lines of code?

A. No output results from this code.

B. 6

C. 2

D. 4

New Questions 11

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 2 3 4

B. The code will output the following: 1 3 4

C. The code will output the following: 1 3 5

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

New Questions 12

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