最新の1Z0-921問題集で試験を準備する

Oracle 1Z0-921 試験概要:

Oracle 1Z0-921 試験シラバストピック:

Oracle MySQL 2021 Implementation Essentials 認定 1Z0-921 試験問題：

1. What are the two main components required to set up persistent storage for MySQL on Kubernetes?
Response:

A) Pod and ReplicaSet
B) Secret and Deployment
C) PVC (Persistent Volume Claim) and ConfigMap
D) PVC (Persistent Volume Claim) and PV (Persistent Volume)

2. Which three are characteristics of the JSON data type?

A) It supports indexing directly against the JSON-defined column.
B) It validates the JSON syntax on insert or merge.
C) Comparisons of JSON values are not case-sensitive.
D) A set of SQL functions substantially support the SQL utilization of the data type.
E) It is based on the TEXT data type.
F) Key or array references enable quick read-access to look up document elements directly.

3. Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

A) Only the t2 table is created.
B) Only the t1 table is created.
C) Both the tables, t1 and t2, are created.
D) Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

4. Which three options are valid reasons for using a primary key in a table?

A) exporting data faster with mysqldump
B) to make it easier to change the PRIMARY KEY value
C) preventing duplicate keys
D) automatic storage of data in a sorted order
E) increasing performance when using select statements
F) maintaining a history of row insertions or updates

5. You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

A) CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;
B) CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE
C) CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)
D) CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)
E) CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;

質問と回答：