Oracle 1Z0-920 問題集

質問 1：
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

質問 2：
What is true about MySQL Enterprise Transparent Data Encryption (TDE)?
A. Tablespace keys are managed manually behind the scenes.
B. Enables data-at-rest encryption by encrypting the physical files of the database.
C. Data is encrypted automatically, in real time, after it is written to storage.
D. Encryption key is stored in a centralized key memory location
正解：B

質問 3：
What SQL keyword must be specified when creating a foreign key constraint?
A. a REFERENCES in the child table to the parent table
B. an index on the foreign key
C. the SET_FOREGIN variable in the my .cnf file
D. unique PRIMARY key values for both child and parent tables
E. a TRIGGER on the child table for cascading delete statements
正解：E

質問 4：
MySQL is installed on a Linux server with the configuration:

Which two methods can change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?
A. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
D. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
正解：A,B

質問 5：
Which two methods help prevent MySQL security risks?
A. Allow unauthorized clients to connect to the server.
B. Transmit plain (unencrypted) data over networks.
C. Grant only permissions that a user requires.
D. Use the secure installation script "mysql_alays_secure_installation".
E. Use a firewall to control access to MySQL ports.
F. Ensure that MySQL accounts have short and easy passwords.
正解：A,B

質問 6：
You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?
A. Use mysqldump to import data from the sakila_dummy database sample data set.
B. Execute the sakila-data. sqi script to populate the database
C. Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;
D. Use MySQL Enterprise High Availability to access one of the available data tables
正解：C