Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z1-320 Exam Practice Test

A. You set the firewall per database.

B. You can block out potential threats by setting up a preapproved whitelist.

C. You can automatically delete a user if the user breaks your firewall.

D. You can modify a request with a SQL statement substitution.

E. You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands.

A. The entire cluster will be shut down.

B. The MySQL Cluster service will be paused. After the network is online, the MySQL Cluster service will be resumed.

C. All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.

D. A MySQL Cluster backup process will be kick-started automatically.

E. Components from one of the machines will be chosen as victim. Only one machine will provide service.

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

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

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

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

E. 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.

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

A. You always use port 3307 for connecting by using the local socket.

B. You have to set up your session to be able to accept LOCAL SOCKET, and then connect via port 22.

C. You can find the file by querying the GLOBAL VARIABLE SOCKET_LOCATION parameter.

D. The file location is set by using the socket parameter located in the global or local option file.

E. The socket file is located in the MySQL data directory.

A. Increase the disk space with at least 10% of the database size.

B. Increase the amount of RAM available to the JVM installed with Tomcat. The JVM memory settings are defined by the JAVA_OPTS line of the setenv file, which sets the environment variables for Tomcat (--JvmMs/-Xms and -JvmMx/-Xmx).

C. Increase the necessary operating system swap space (Linux): mkswap /dev/sdx; swapon/dev/sdx,
/etc/fstab.

D. Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).

A. mysqlcheck

B. mysqlimport

C. mysqlslap

D. mysqladmin

E. mysqlshow

A. START SLAVE

B. SLAVE RUN

C. SLAVE START

D. RUN SLAVE

E. START RUN SLAVE

A. CONNECTIONS_PER_HOUR

B. MAX_UPDATES_PER_DAY

C. MAX_CONNECTIONS

D. MAX_QUERIES_PER_HOUR

E. MAX_QUERY_SIZE

A. a REFERENCE in the child table to the parent table

B. UNIQUE PRIMARY KEY values for both child and parent tables

C. a TRIGGER on the child table for cascading DELETE statements

D. the SET_FOREIGN_KEY variable in the my.cnf file

E. an INDEX on the FOREIGN KEY

A. SET mysql.sp_set_firewall_mode= 'RECORDING';

B. CALL mysql.sp_set_firewall_mode ('fwuser@localhost', 'CLEAR');

C. CALL mysql.sp_reload_firewall_rules ('fwuser@localhost');

D. DELETE TABLE INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST;