Free Oracle 1z1-909 Exam Dumps Questions & Answers

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

Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

• A.  log__slow_admin_statements=1
• B.  log_throttle_queries_not_using_indexes=100
• C.  log_queries_not_using_indexes
• D.  log_queries_not_using_indexes=ON

How does InnoDB choose deadlock victims in MySQL?

• A.  It chooses the transaction with the most modified rows.
• B.  It chooses the transaction randomly.
• C.  It chooses the transaction with the lowest transaction ID.
• D.  It chooses the transaction with the fewest modified rows.
• E.  It chooses the transaction with the most accumulated CPU time.
• F.  It chooses the transaction with the least accumulated CPU time.

Which change will prevent negative ages to be inserted into the people table?

• A.  DELIMITER //
  CREATE TRIGGER age check AFTER INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER;
• B.  DELIMITER //
  CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER ;
• C.  ALTER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);
• D.  ALTER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;

Examine these statement which execute successfully:

Now, examine this desired output:

Which two queries will produce the out?

• A. 
• B. 
• C. 
• D. 
• E.