QUESTION: 49

Which of the following code segments correctly readies a database query, creating a valid statement handle and a result set? Assume $dbh represents a valid database handle.

$sth = $dbh->prep_statement(SELECT * FROM aTable); $sth->execute_statement;
$sth = $dbh->prepare(SELECT * FROM aTable);
$sth->execute;
$sth = $dbh->prep_statement(SELECT * FROM aTable); $sth->execute;
$sth = $dbh->prepare_statement(SELECT * FROM aTable); $sth->execute_statement;

Answer(s): B

Explanation:

[Note] Only have method "$ dbh -> prepare( ...)",
$ dbh -> prep_ statement ( ...) is not existed

Reveal Solution Next Question

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

Answer(s): C

Reveal Solution Next Question

QUESTION: 51

Consider the following statement:
$buffer = a string;
Also consider that a file named test.txt contains the following line of text:
One line of test text.
What is the output of the following lines of code? $file = "test.txt";
open (OUT, "<$file") || (die "cannot open $file: $!"); read(OUT, $buffer, 15, 4);
print $buffer;

astrOne line of test
astOne line of tes
astrOne line of tes
astOne line of test

Answer(s): B

Reveal Solution Next Question

QUESTION: 52

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
apples
apples oranges pears plums

Answer(s): D

Reveal Solution Next Question

Free 1D0-437 Exam Braindumps (page: 13)

QUESTION: 49

Explanation:

QUESTION: 50

QUESTION: 51

QUESTION: 52