Oracle 1Z0-320 Questions Answers

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. A MySQL Cluster backup process will be kick-started automatically.
B. The entire cluster will be shut down.
C. Components from one of the machines will be chosen as victim. Only one machine will provide service.
D. All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.
E. The MySQL Cluster service will be pause. After the network is online, the MySQL Cluster service will be resumed.

Answer: E


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. audit-log=FORCE_PLUS_PERMANENT
C. plugin-load=audit_log.so
D. plugin-audit=ON, ALWAYS
E. LOAD PLUGIN=AUDIT_LOG

Answer: AB

https://education.oracle.com/mysql-cloud-service-2018-implementation-essentials/pexam_1Z0-320

https://www.dumpspedia.net/1z0-320-exam-dumps.html

Oracle 1Z0-320 Questions Answers

When there are long-running queries, mysqbackup hangs there to wait for the completion of the queries. You know that the system has only user data on InnoDB and there is no DDL execution during the backup period. There is no update/alternation to tables with non-InnoDB storage engines. Which two ways allow the MySQL Enterprise Backup to be executed without being blocked or without locking?

A. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.
B. 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.
C. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.
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 the - - only-innodb option to back up only InnoDB tables, to avoid blocking.
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 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.

Answer: BE

Oracle 1Z0-320 Question Answer

What are two key differences between the use of ndbd and ndbmtd?

A. ndbd can be configured as ndbmtd by applying the option - - mtd.
B. In the event of critical errors, ndbd generates a trace file with the name ndb_node_id_trace.log.trace_id, whereas ndbmtd generates a trace file with the name
pattern ndb_node_id_trace.log.trace_id_tthread_id
C. ndbd is single-threaded mode; however, ndbmtd runs by default in multithreaded mode.
D. ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads.
E. In the event of critical errors, ndbd generates all trace in error log, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id.

Answer: DE

                              Visit For More Information 1Z0-320 Exam Questions

Oracle 1Z0-320 Question Answer

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;

Answer: D
 

You execute the following statement SELECT NULL_NULL;
What is the result?

A. 0
B. 1
C. TRUE
D. FALSE
E. NULL

Answer: D

Pedestrian struck by vehicle on Oracle, near Ina

TUCSON — A pedestrian is hospitalized after they were struck by a vehicle on Oracle, near Ina.

According to the Northwest Fire Department, the crash happened shortly after 8 p.m. Officials say the victim was taken to the hospital is potentially life threatening injuries.

Arizona Department of Public Safety is now investigation the crash.

Stay with News 4 Tucson as more information becomes available

Oracle 1Z0-320 Question Answer

You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables.
Which syntax accomplishes this?

A. CREATE USER ‘mysqlbackup’@localhost’IDENTIFIED BY ‘new-password’;
B. CREATE USER ‘mysqlbackup’@localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;
GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT SUPER ON *.* TO ‘mysqlbackup’@’ localhost;
GRANT PROCESS ON *.* ‘mysqlbackup’@’localhost’;
C. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* TO ‘’mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@localhost’;
D. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* to ‘mysqlbackup’@localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON, mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON
mysql.backup_history TO ‘mysqlbackup’@’localhost’;
GRANT REPLICATION CLIENT ON *.* to ‘mysqlbackup’@’localhost’;
GRANT SUPER ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT PROCESS ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT LOCK TABLES, SELECT, CREATE, ALTER ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO ‘mysqlbackup’@’localhost’;
E. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;
GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’;

Answer: A

Oracle 1Z0-320 Question Answer

Which statement is true about MySQL enterprise Transparent Data Encryption (TDE)?

A. TDE supports at rest data encryption for InnoDB tables stored in file-per-table tables paces.
B. Lost table space encryption keys can be regenerated only If the master database key is known or present In the KEY VAULT file.
C. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engin = ALL variable in the MySQL configuration file.
D. TDE can encrypt InnoDB and MYSAM tables only when the tables are stored in the system tablespace.

Answer: A


You get a Maintenance notification about your Oracle MySQL Cloud Service. What are the implications?
 
A. There are no maintenance operations planned. You need to do them manually.
B. Depending on the planned outage, you may not be affected by It. You need to read the maintenance details In the support notice.
C. You need to agree to the maintenance windows. If not, you are not affected by the outage.
D. You can expect an outage of your MySQL Cloud Service during the planned time.

Answer: C