ZF-100-500 試験問題を無料オンラインアクセス

Which of the following are the features of Zend_Layout? Each correct answer represents a complete solution. Choose all th at apply.

• A.It is the configuration of layout name, inflection, and path.
• B.It has a separate scope for l ayout-related variables and content.
• C.It is used to disable layouts and change scripts.
• D.It can be used with ZF MVC components.

Which method can be used to determine whether text within a source file has been translated in Zend_Translate?

• A.isTranslatedAt()
• B.isLocated()
• C.isLocatedAt()
• D.isTranslated()

Which of the following statements describe s the use of a GROUP BY clause?

• A.A GROUP BY clause automatically sorts the grouped result in ascending order, if DESC keyword is not defined.
• B.A GROUP BY clause automatically sorts the grouped result in descending order.
• C.A GROUP BY clause returns a single row of information for each group of rows, in addition to all the rows.
• D.A GROUP BY clause returns a single row of information for each group of rows.

Martin works as a Database Administrator for MTech Inc. He designs a database that has a table named Products. He wants to create a report listing different product categories. He does not want to display any duplicate row in the report. Which of the following SELECT statements will Martin use to create the report?

• A.SELECT Product_No, Prod_Category
  FROM Products
  GROUP BY Product_No;
• B.SELECT DISTINCT Product_No, Prod_Category
  FROM Products;
• C.SELECT Product_No, Prod_Category
  FROM Products
  GROUP BY Product_No ORDER BY Product_No;
• D.SELECT Product_No, Prod_Category
  FROM Products;

You work as a Database Administrator for Dolliver Inc. The company uses an Oracle database. The database contains two tables, named Employees and Departments. You want to retrieve all matched and unmatched rows from both the tables. Which of the following types of joins will you use to accomplish this?

• A.FULL OUTER JOIN
• B.CROSS JOIN
• C.RIGHT OUTER JOIN
• D.LEFT OUTER JOIN