Oracle 1Z0-920 問題集

質問 1：
MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. Which three are MySQL Enterprise Masking and De-identification functions?
A. strict or relaxed masking
B. random data substitution
C. whitelisting and substitution
D. dictionary substitution
E. misspelling
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which Oracle product is certified to work with MySQL Enterprise Edition?
A. Oracle Data Pump
B. Oracle Enterprise Backup
C. Oracle Application Express
D. Oracle Enterprise Manager
正解：D
解説: (Topexam メンバーにのみ表示されます)

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

質問 4：
Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?
A. The opc user can be used to access MySQL only with the created SSH-Key.
B. The OCI instance is still in the "creation" process.
C. You forgot to create the correct SSL/TLC certificate during the setup process.
D. Only root is allowed to access from non-localhost.
E. You forgot to enable port 3306.
正解：E

質問 5：
You are using the innoDB engine and the innodb_f ile_per_table option is set.
You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory.
What will happen to the inventory table?
A. The table statistics will be stored.
B. The table will be optimized and replicated.
C. The table will be checked for errors and repaired.
D. The table storage space will be reduced.
正解：B

質問 6：
Which two deployment architectures could you use for scaling-out database reads?
A. Implementing a three-node, single-primary InnoDB Cluster.
B. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.
C. Edit the configuration file and increase the value for parallel_read_workers and reboot the server
D. Altering the storage engine for all tables to memory to increase performance.
E. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.
正解：A,D