Free Oracle 1z1-320 Exam Dumps Questions & Answers

You want to use Workbench to connect your local MySQL instance by using a local socket. Where would you find the location of the socket file?

• A.  You can find the file by querying the GLOBAL VARIABLE SOCKET_LOCATION parameter.
• B.  The file location is set by using the socket parameter located in the global or local option file.
• C.  The socket file is located in the MySQL data directory.
• D.  You have to set up your session to be able to accept LOCAL SOCKET, and then connect via port 22.
• E.  You always use port 3307 for connecting by using the local socket.

You have the MySQL 5.7 database running. MySQL Enterprise Backup 3.12 is installed and it is used to back up the MySQL 5.7 database. The backup has failed. Identify the reason.

• A.  MySQL Workbench must be installed with MySQL Enterprise Backup to enable the backup to run successfully.
• B.  mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the - -upgrade on MySQL 5.7 database to allow the mysql.backup_progress and mysql.backup_history tables to be patched.
• C.  MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7.
• D.  MySQL 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.
• E.  MySQL 5.7 is supported in MySQL Enterprise Backup 3.x providing that the MySQL 5.7 is pre-registered in the MySQL Enterprise Backup configuration file.

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

• A.  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
• B.  ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads.
• C.  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.
• D.  ndbd is single-threaded mode; however, ndbmtd runs by default in multithreaded mode.
• E.  ndbd can be configured as ndbmtd by applying the option - - mtd.

Which two methods can change password expiration for a database user account? (Choose two.)

• A.  Use an ALTER USER command to change the password expiration
• B.  Update the my.cnf configuration to include default_password_lifetime=100 and restart the server
• C.  Create a new database user account with an explicit password expiration time
• D.  Use the SET GLOBAL command to update the default password expiration time

A keyfile has been generated as follows:
# openssl rand 32 -hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?

• A.  # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup
• B.  # mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - - backup-dir=/var/tmp/backup backup-to-image
• C.  # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup - timestamp backup
• D.  # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile -
  -backup-dir=/var/tmp/backup backup-to-image
• E.  # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile -
  -backup-dir=/var/tmp/backup backup-to-image