Free Actual Oracle 1Z0-909 Exam Questions & Answers

Question 1

Which two statements are true about aggregate functions?

ASUM () returns o if there are no rows to aggregate.

BMAX () returns null if there are no rows to aggregate.

CCOUNT (distinct) returns a count of the number of rows with different values including Null.

DMIN () cannot use distinct when it executes as a Windows function.

EAVG () does not allow use of the distinct option.

Correct : E

Question 2

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?

AThe X Dev API protocol must be enabled to use sockets in Connector/J driver.

BThe socket is not implemented in Connector/J driver.

CThe socket can only be accessed from the local host.

Dsocket is a reserved word in Java.

EJava treats the socket file as insecure.

Correct : B, E

Oracle 1Z0-909 Exam Questions - Navigate Your Path to Success