Oracle MySQL 8.0 Database Developer - 1Z0-909 Free Exam Questions

A. The column must have a default value.

B. The column must be a generated column referencing only an existing attribute of doc.

C. The column must be a generated column referencing any attribute of doc.

D. The column must be used in a unique constraint.

E. The column must be indexed.

A. It inserts a row with no error or warning.

B. It inserts a row with an error.

C. It fails with a warning.

D. It fails with an error.

E. It inserts a row with a warning.

A. SELECT 'Car' RLIKE 'Ca?' INTO @r;

B. SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;

C. SELECT STRCMP('Car'/Ca?') >= 0 INTO @r;

D. SELECT 'Car' LIKE 'Ca?' INTO @r;

A. It allows one to bypass the SQL layer of the server.

B. It can store documents greater than 4 GB.

C. There is no access to relational tables.

D. It helps to store data items in a schema-less key-value store.

E. It depends heavily on strictly typed data.

A. Buffered queries should be used on large tables when the result size is unknown.

B. Buffered queries must be explicitly enabled using mysqliuseresult.

C. Results are sent to the calling PHP process for buffering.

D. Buffered queries are enabled by default.

E. Additional queries on the same session are blocked until the result set is released.

F. Results are sent from the server to the browser for buffering.

G. Large results can have a negative impact on performance.

A. log_queries_not_using_indexes

B. log_queries_not_using_indexes=ON

C. log_throttle_queries_not_using_indexes=100

D. log__slow_admin_statements=1

A. Execution performance can be improved by using like instead of RLIKE.

B. Execution performance can be improved by adding an index on column description.

C. The statement takes advantage of index description_idx.

D. No index will improve statement performance.

E. Execution performance can be improved by, using a composite index with column description as the leftmost prefix column description.