1z0-320 試験問題を無料オンラインアクセス

You have a text file named "xyz.csv" exported from another system.

You are asked to import data to a MySQL Database table named "country".
The table definition is as follows:

Identify the action that imports the data from Workbench or MySQL Client to the database correctly.

• A.Create a DIRECTORY LINK object on the database and use INSERT into mycountry SELECT * from mycountry.csv.
• B.Use the LOAD DATA INFILE syntax to load data into the database table.
• C.Use mysqlimport to load the mycountry.csv data file with the --csv option specified.
• D.Convert the data into MDI and restore the MySQL data from it.

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

• A.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]...]
• B.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.
• 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=replicationdestinations=master:3306, slave:3306The Java application can connect to bind_port=7001

You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of a large table named INVENTORY. What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?

• A.ANALYZE TABLE INVENTORY;
• B.mysqlcheck INVENTORY
• C.mysqldump INVENTORY
• D.OPTIMIZE TABLE INVENTORY;

You are setting up a MySQL Cluster on two machines, where each machine is hosting the following:
-1x ndbmtd
-1x ndb_mgmd
-1x mysqld
The cluster is started. What will happen if the network connection between the two machines is disconnected?

• A.The MySQL Cluster service will be paused. After the network is online, the MySQL Cluster service will be resumed.
• B.The entire cluster will be shut down.
• 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.

Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances.

• A.SMS
• B.Direct support call from an Oracle representative
• C.Email
• D.Notification tab on the dashboard
• E.Browser pop-ups