PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which of the following SQL statements can you use to accomplish this?

You have created a table based on the following data:
<code>
EmpID NUMBER (5) PRIMARY KEYEmpName VARCHAR2 (35) NOT NULL Salary NUMBER (9,
2) NOT NULL CommissionNUMBER (4, 2) ManagerName VARCHAR2 (25) ManagerID NUMBER (5)
</code>
Now, you wantto display the names of employees and their managers, using a self join.
Which of the following SQL statements can you use to accomplish this? Each correct answer
represents a complete solution. Choose two.

Which of the following functions will you use instead of * if you want to print the root element of the XML fi

You run the following PHP script:
<code>
<?php include(“xml.inc”);
if (!$dom = domxml_open_mem($xmlstr)) {
echo “Error while parsing the XML document \n”;
exit;
}
$a = **********
print_r($a);
?>
</code>
Which of the following functions will you use instead of * if you want to print the root element of the
XML file?

Which of the following code snippets will you insert at line number 14 to get the following output?

You have been given the following PHP script:
<code>
1. <?php
2. $xmlstring = <<<XML
3. <?xml version=”1.0″ encoding=”ISO -8859-1″?>
4. <email>
5. <to>jenny@PassGuide.com</to>
6. <from>john@PassGuide.com</from>
7. <heading>Technical issue in Linux OS</heading>
8. <body>There is a technical issue in my Linux system. Please Fix it. </body>
9. </email>
10. XML;
11. $xml = new SimpleXMLElement($xmlstring);
12. foreach($xml->children() as $child)
13. {
14. <Insert code here.>
15. }
16. ?>
</code>
Which of the following code snippets will you insert at line number 14 to get the following output?


Page 79 of 101« First...102030...7778798081...90100...Last »