Online Access Free Oracle.1z1-909.v2022-12-22.q21 Practice Test (Page 4)

1z1-909 Exam Question 11

Examine this statement which executes successfully:

The table is populated with a range of values including jobs for Robert, John, and Katie. Now, examine this statement and output:

Why is an empty result set returned?

A.The json_extract() function requires a length value that matches the field length in the schema.

B.The JSON datatype cannot be used in virtual columns.

C.The select requires json_unquoteo in the where clause.

D.Table statistics must be updated to generate values for the name column.

E.The virtual values in the name column must be accessed using functions.

1z1-909 Exam Question 12

Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice', UCASE ('Alice* )) ;
What is displayed?

A.0

B.1

C.NULL

D.-1

E.ERROR: 1267 (HYOOO): Illegal mix of collations

1z1-909 Exam Question 13

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

A.DELIMITER //
CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER ;

B.ALTER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);

C.ALTER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;

D.DELIMITER //
CREATE TRIGGER age check AFTER INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER;

1z1-909 Exam Question 14

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

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

C.socket is a reserved word in Java.

D.Java treats the socket file as insecure.

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

1z1-909 Exam Question 15

The variables c and d are declared as integer types.
Examine these initialization statements with placeholder value <p1>, which execute successfully:
Now, examine this loop which executes successfully: