Oracle 1Z0-909 Oracle MySQL 8.0 Database Developer Exam Exam Practice Test Questions

• Question 1

  Which two differences exist between the timestamp and date time data types?

  • timestamp has larger range of values.
  • timestamp uses less storage space.
  • timestamp stores more decimal points in seconds
  • timestamp converts the value based on the session time zone.
  • timestamp stores the interval between two dates.

  Show Answer Answer: B,D Next

• Question 2

  Which two are true about MySQL connectors?

  • Connectors must be installed on both the client and server hosts.
  • Connector/J is based on Connector/
  • Connector/ODBC is available on Unix, Windows, and MacOS X.
  • Connector/NET runs on the Windows platform only.
  • Connector/Python is released in precompiled binary and source code.

  Show Answer Answer: A,B Next

• Question 3

  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?

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

  Show Answer Answer: B,E Next

• Question 4

  Examine this statement: DECLARE not_found CONDITION FOR SQLSTATE '02000'; In which two statements can not found be used?

  • in a leave statement to exit a loop
  • in an if statement
  • in a while loop
  • in a handler declaration
  • in a signal statement

  Show Answer Answer: C,E Next

• Question 5

  Which two are true about MySQL Document Store?

  • It helps to store data items in a schema-less key-value store.
  • It can store documents greater than 4 GB.
  • It depends heavily on strictly typed data.
  • It allows one to bypass the SQL layer of the server.
  • There is no access to relational tables.

  Show Answer Answer: A,D Next