Free Zend Certified Engineer Exam 200-710 Exam Practice Test

An unbuffered database query will: (Choose 2)

• Return the first data faster
• Return all data faster
• Free connection faster for others scripts to use
• Use less memory

What is the output of the following code?$text = 'This is text';$text1 = <<<'TEXT'$text TEXT;$text2 = <<<TEXT$text1 TEXT;echo "$text2";

• This is text
• $text
• $text1
• $text2

Is the following code vulnerable to SQL Injection ($mysqli is an instance of the MySQLi class)?$age = $mysqli->real_escape_string($_GET['age']);$name = $mysqli->real_escape_string($_GET['name']);$query = "SELECT * FROM `table` WHERE name LIKE '$name' AND age = $age";$results = $mysqli->query($query);

• No, the code is fully protected from SQL Injection.
• Yes, because the $name variable is improperly escaped.
• Yes, because the $name variable and the $age variable is improperly escaped.
• Yes, because the $age variable is improperly escaped.
• E: Yes, because you cannot prevent SQL Injection when using MySQLi

Which DOMElement property provides a reference to the list of the element's children?

Consider the following table data and PHP code, and assume that the database supports transactions. What is the outcome?Table data (table name "users" with primary key "id"):idnameemail1annaalpha@example.com2bettybeta@example.org3claragamma@example.net5suesigma@example.infoPHP code (assume the PDO connection is correctly established):$dsn = 'mysql:host=localhost;dbname=exam';$user = 'username';$pass = '********';$pdo = new PDO($dsn, $user, $pass);try {$pdo->exec("INSERT INTO users (id, name, email) VALUES (6, 'bill', 'delta@example.com')");$pdo->begin();$pdo->exec("INSERT INTO users (id, name, email) VALUES (7, 'john','epsilon@example.com')");throw new Exception();} catch (Exception $e) {$pdo->rollBack();}

• The user 'bill' will be inserted, but the user 'john' will not be.
• Both user 'bill' and user 'john' will be inserted.
• Neither user 'bill' nor user 'john' will be inserted.
• The user 'bill' will not be inserted, but the user 'john' will be.

Please provide the value of the $code variable in the following statement to set an HTTP status code that signifies that the requested resource was not found.http_response_code($code);

Which sentence describes the following regular expression match? preg_match('/^\d+(?:\.[0-9]+)?$/', $test);

• It matches float numbers with thousand seperators.
• It matches float numbers without thousand seperators.
• It matches binary integer numbers.
• It matches any string.
• E: It does not match anything

Which php.ini setting is usually required to use an opcode cache?

• extension
• zend_extension
• optimizer
• dl

What DOMElement method should be used to check for availability of a non-namespaced attribute?

• getAttributeNS()
• getAttribute()
• hasAttribute()
• hasAttributeNS()

One common security risk is exposing error messages directly in the browser. Which PHP configuration directive can be disabled to prevent this?

• html_display
• error_reporting
• display_errors
• error_log
• E: ignore_repeated_errors