Free Access Oracle.1Z0-909.v2022-12-19.q24 Practice Test (Page 5)

Question 16

Examine this statement:

A.Inserting COMMIT; SET @m :=: before line 4

B.user who creates the procedure needing the create routine privilege

C.user who creates the procedure needing the create and execute privileges

D.inserting USE <database >; before line 3

E.Inserting DEFINER 'username '@' localhost' clause into the CREATE PROCEDURE statement

Question 17

Examine this bar graph based on columns from the players table:

Which two statements would generate this bar graph?

A.SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;

B.SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

C.SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

D.SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

E.SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

Question 18

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 X Dev API protocol must be enabled to use sockets in Connector/J driver.

C.The socket can only be accessed from the local host.

D.The socket is not implemented in Connector/J driver.

E.socket is a reserved word in Java.