Oracle 1Z0-909 Quiz 1 Topic 10 Questions 1-5

Question: 1

Your session has sqi_mode set to default.

Examine this statement which executes successfully:

q1_1Z0-909

Now examine this statement:

q1_1Z0-909

Which two changes are required to the insert statement so that it inserts the correct data?

* std_id = 10301

* firstname = Mary

* lastname = O'Hagen

* birthdate = November 26, 1997

* reg_date = the current date

AChange DATE () to DAY ().

BChange 'O'Hagen' to 'o\'Hagen'.

CChange date () to CURRENT_TIMESTAMP () .

DChange ' NULL ' to NULL.

EChange ' NULL ' to ' NULL ' .

FChange 'O'Hagen' to 'O\'Hagen'.

Show Answer

Question: 2

Examine this statement which executes successfully:

q2_1Z0-909

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

q2_1Z0-909

Why is an empty result set returned?

AThe select requires json_unquoteo in the where clause.

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

CThe JSON datatype cannot be used in virtual columns.

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

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

Show Answer

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?

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.

Show Answer

Question: 4

You must enforce data integrity for data Inserted in a JSON column.

Which statement successfully creates a constraint in a 3SON column?

ACREATE TABLE fshop (product JSON CHECK (JSON_VALID(product) ) ) ;

BCREATE TABLE fshop ( product JSON, f INT' GENERATED ALWAYS AS (product->'S - id') ) ;

CCREATE TABLE fshop (id INT NOT NULL AUTOINCREMENT, product JSON, PRIMARY KEY (id)) ENGINE=InnoDB;

DCREATE TABLE fshop (id INT NOT NULL AUTO_ INCREMENT, product JSON, CHECK (id>0) ) ENGXNE=InnoDB;

Show Answer

Question: 5

Examine this statement and output:

q5_1Z0-909

Which is true?

AThe underlying table's index on the Name column is not chosen because of low selectivity.

Bmyview cannot be automatically indexed.

Cmyview was defined with the temptable processing algorithm.

DColumn Name in myview can be indexed if the is_updatable attribute is true.

Show Answer

Oracle 1Z0-909 Quiz:1 Topic:10 Questions:1-5