Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z1-320 模擬練習

A. Use an ALTER USER command to change the password expiration

B. Create a new database user account with an explicit password expiration time

C. Update the my.cnf configuration to include default_password_lifetime=100 and restart the server

D. Use the SET GLOBAL command to update the default password expiration time

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

B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

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

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

A. The customer reached the database instance limit of 32.

B. The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to date.

C. The customer account might have reached its compute quota.

D. The customer does not have proper user rights.

A. MySQL CS is based on the MySQL Enterprise Product Suite.

B. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.

C. MySQL CS is installed based on the Oracle Flexible Architecture Standard.

D. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard).

E. MySQL CS configuration can be changed in /etc/my.cnf.

F. Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II).

A. Run a mysql command as follows.mysqlbackup will continue. mysql> resume mysqlbackup;

B. Log in to the MySQL server and identify the processid, which issues GLOBAL READ LOCK. Connect the mysql session and terminate the session for the identified "processed" .mysqlbackup will continue

C. Run a mysql command as follows,.mysqlbackup will continue. mysql>UNLOCK TABLES;

D. Issue a SIGTERM to the mysqlbackup process.mysqlbackup will continue

E. An external program or manual work is to be executed to complete the backup and the marker file
"/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' should be removed intentionally.
After the file is removed, mysqlbackup will continue

A. INSERT INTO City_part SELECT * FROM City;

B. CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City;

C. CREATE TABLE City_part LIKE City;

D. CREATE TABLE City_part AS SELECT * FROM City;

A. Use MySQL Router with the following configuration:[DEFAULT]logging_folder=
/var/log/mysqlrouter[logger]level=INFO[routing: failover]bind_port =
7001mode=replicationdestinations=master:3306, slave:3306The Java application can connect to bind_port=7001

B. Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL asjdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] ...
[/[database]] [? propertyName=propertyValue1 [&propertyName2-propertyValue2]...]

C. The default JDBC driver is automatically configured with High Availability Option by pointing the connection URL to any one of the MySQL instances.

D. Use MySQL Router with the following
configuration:[DEFAULT]logging_folder=/var/log/mysqlrouter[logger]level=INFO[routing:
failover]bind_port = 7001mode=read-writedestinations= master:3306, slave:3306The Java application can connect to bind_port=7001.

A. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.

B. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

C. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.

D. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

E. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

F. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.

A. UPDATE TABLE SET ENCRYPTION = 'ON';

B. ALTER TABLE <table> ENCRYPTION = 'Y';

C. ALTER mysql.encryption SET tde_status = 'YES';

D. ALTER INSTANCE ROTATE INNODB MASTER KEY;

A. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - - only-innodb option to back up only InnoDB tables, to avoid blocking.

B. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.

C. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.

D. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use - -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking.

E. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - -no-locking option to backup up the non-InnoDB files. Note that MyISAM, .frm, and other files copied under the --no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.