最新的Oracle 1Z1-921免費考試真題

問題1

What SQL keyword must be specified when creating a foreign key constraint?

A. a TRIGGER on the child table for cascading delete statements

B. an index on the foreign key

C. unique PRIMARY key values for both child and parent tables

D. a REFERENCES in the child table to the parent table

E. the SET_FOREGIN variable in the my .cnf file

正確答案: A

問題2

The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?

A.

B.

C.

D.

正確答案: A

問題3

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. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

B. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

C. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';

D. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';

正確答案: A,D

問題4

The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';
Which three are commands that the os-user can execute?

A. KILL PROCESS;

B. GRANT PROXY

C. SHUTDOWN

D. SHOW BINLOG EVENTS;

E. SHOW STATUS;

F. SHOW PROCESSLIST;

正確答案: A,C,E

問題5

Which activity will take place if a table is created with both the compression and encryption options?

A. The compression is performed before tablespace data is encrypted.

B. The tablespace data is encrypted first and then compression is performed.

C. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.

D. The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.

正確答案: A

問題6

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?

A. audit_log_permanent=ON

B. plugin-load=audit_log.so

C. plugin-audit=ON, ALWAYS

D. audit-log=FORCE_PLUS_PERMANENT

E. LOAD PLUGIN=AUDIT_LOG

正確答案: A,D

問題7

Which two statements are correct about MySQL Enterprise Edition?

A. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.

B. MySQL configuration can be changed in /etc/lib/myi.cnf.

C. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

D. Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II).

E. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.

正確答案: B,D

問題8

Which two are advantages of using Document Store in MySQL?

A. MySQL can store XML as a schema-less database

B. MySQL provides a NoSQL API to access the document store

C. MySQL provides a native data type to index PDF documents

D. MySQL provides a native data type to store JSON data as a document

E. MySQL is a document database allowing PDF and Word documents

正確答案: A,B

最新的Oracle MySQL 2021 Implementation Essentials - 1Z1-921免費考試真題

聯系我們

站內鏈接

最新更新