1z1-909 試験問題を無料オンラインアクセス

A server hosts MySQL Server and Apache Webserver supporting a PHP/PDO based application.
The application must be migrated from PHP to their Java application server on another host. The MySQL instance remains on the original host.
Examine the PDO connection string used in the existing application:
Mysql:host-localhost;dbname=sales;unix_socket=/var/run/mysql.sock
Which two prevent Java from using the Unix socket?

• A.The socket can only be accessed from the local host.
• B.The X Dev API protocol must be enabled to use sockets in Connector/J driver.
• C.Java treats the socket file as insecure.
• D.The socket is not implemented in Connector/J driver.
• E.socket is a reserved word in Java.

Examine these statements which execute successfully:

Now, examine this query:

What is the result?

• A.It fails with an error.
• B.It inserts a row with an error.
• C.It inserts a row with a warning.
• D.It fails with a warning.
• E.It inserts a row with no error or warning.

The collection col contains all episodes for all seasons for a TV show.
Examine this document which has an example of the details for each episode:

Which query returns all expisode names from the first season?

• A.SELECT doc->"$.name" FROM col WHERE doc->"$.season" = "1";
• B.SELECT name FROM col WHERE season = 1;
• C.SELECT doc->,,$.name,, FROM col WHERE doc->"$ . season" = "1";
• D.SELECT "S.name" FROM col WHERE "S.season" = "1";

Examine these commands and output:

Which is true?

• A.It returns an error because the CREATE TABLE statement automatically recreated the view.
• B.Existing emp_vuL is dropped and a new emp_vu1 created with the new definition.
• C.A new view is created because the previous was dropped on execution of the drop table statement.
• D.It returns an error because the DROP TABLE statement did not drop the view.

Examine these commands which execute successfully:
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?

• A.The trigger activates after any row in the table has been updated.
• B.The trigger activates after any row has been inserted into the table.
• C.The trigger body set causes trigger activation.
• D.Execution of an insert statement causes the trigger to activate.