Zend 200-710 Online Practice Questions and Exam Preparation

Zend 200-710 Online Questions & Answers

• Question 231:

  You want to access the 3rd character of a string, contained in the variable $test. Which of the following possibilites work? (Choose 2)

  A. echo $test(3);
  B. echo $test[2];
  C. echo $test(2);
  D. echo $test{2};
  E. echo $test{3};
  B. echo $test[2];
  D. echo $test{2};

• Question 232:

  Which MIME type is always sent by a client if a JPEG file is uploaded via HTTP?

  A. image/jpeg
  B. image/jpg
  C. image/pjpeg
  D. Depends on the client system
  D. Depends on the client system

• Question 233:

  Consider the following table data and PHP code. What is the outcome?

  Table data (table name "users" with primary key "id"):

  

  PHP code (assume the PDO connection is correctly established):

  $dsn = 'mysql:host=localhost;dbname=exam';

  $user = 'username';

  $pass = '********';

  $pdo = new PDO($dsn, $user, $pass);

  $cmd = "SELECT * FROM users WHERE id = :id";

  $stmt = $pdo->prepare($cmd);

  $id = 3;

  $stmt->bindParam('id', $id);

  $stmt->execute();

  $stmt->bindColumn(3, $result);

  $row = $stmt->fetch(PDO::FETCH_BOUND);

  A. The database will return no rows.
  B. The value of $row will be an array.
  C. The value of $result will be empty.
  D. The value of $result will be '[email protected]'.
  D. The value of $result will be '[email protected]'.