Oracle 1Z0-320 Online Practice Questions and Exam Preparation

Oracle 1Z0-320 Online Questions & Answers

• Question 51:

  You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing.

  Which two options can reduce the backup size and speed up the backup time?

  A. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
  B. Use mysqldump with the - -changesonly option.
  C. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
  D. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
  E. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
  B. Use mysqldump with the - -changesonly option.
  E. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.

• Question 52:

  By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

  A. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
  B. MySQL Enterprise Backup will back up from Slave automatically.
  C. It provides multi-master access where the application can write and read data across the database servers.
  D. It allows backup to be done on the slave without impacting the master.
  E. You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.
  B. MySQL Enterprise Backup will back up from Slave automatically.
  D. It allows backup to be done on the slave without impacting the master.
  E. You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

• Question 53:

  You have configured MySQL Enterprise Transparent Data Encryption (TDE). What command would you use to encrypt a table?

  A. ALTER mysql.encryption SET tde_status = `YES';
  B. UPDATE TABLE SET ENCRYPTION = `ON';
  C. ALTER TABLE ENCRYPTION = `Y';
  D. ALTER INSTANCE ROTATE INNODB MASTER KEY;
  C. ALTER TABLE ENCRYPTION = `Y';

  ---

  Reference: https://scriptingmysql.wordpress.com/tag/mysql-enterprise-edition/ https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html

• Question 54:

  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';
  A. CREATE USER `mysqlbackup'@localhost'IDENTIFIED BY `new-password';

• Question 55:

  The slave connects to the master and asks for updated records. What command was issued for this to happen?

  A. RUN SLAVE
  B. START RUN SLAVE
  C. SLAVE RUN
  D. SLAVE START
  E. START SLAVE
  D. SLAVE START

• Question 56:

  You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted. What steps would you perform to create a new audit file?

  A. As the root user, execute the FLUSH AUDIT LOGS command. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH.
  B. Stop the MySQL server. Move or rename the existing audit.log file. Restart the MySQL server.
  C. Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME `audit_log.so'; Delete the corrupted file. Restart the MySQL server.
  D. As the root user, execute the SET GLOBAL audit_log_flush=ON command.
  C. Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME `audit_log.so'; Delete the corrupted file. Restart the MySQL server.

• Question 57:

  The MySQL database for backup with used data is configured only with the InnoDB storage engine. System data including SP, VIEWs, and users in the system database are all static. For any changes with system data, the database backup will be done separately.

  You are requested to optimize backup performance to reduce backup time by using MySQL Enterprise Backup for the daily backup operation with user data (configured with the InnoDB storage engine).

  Which three options would you choose to optimize the backup performance?

  A. Shutting down the MySQL database and using MySQL Enterprise Backup to restart the MySQL Database to remove any potential locking
  B. Using the - - only- innodb or - - only- innodb- with 璮rm option to back up only InnoDB tables
  C. Running multiple MySQL Enterprise Backups at the same time to back up the same database to allow parallel database backups on MySQL
  D. Running the backup with the backup policy, full backup and incremental backup, supported by MySQL Enterprise Backup to reduce the daily backup time
  E. Using the - - no-locking option to backup non_InnoDB files
  C. Running multiple MySQL Enterprise Backups at the same time to back up the same database to allow parallel database backups on MySQL
  D. Running the backup with the backup policy, full backup and incremental backup, supported by MySQL Enterprise Backup to reduce the daily backup time
  E. Using the - - no-locking option to backup non_InnoDB files

• Question 58:

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

• Question 59:

  You want to prevent any unauthorized users from gaining access to the personal information of your employees, which is stored in the EMPLOYEE table in a MySQL database. How would you use the MySQL Enterprise Edition Firewall to prevent the following SQL injection attack from exposing the salaries of all your employees?

  SELECT fl_name, salary FROM EMPLOYEE WHERE fl_name= `JHacker' OR 1=1;

  A. Create a blacklist of the SQL commands, which would restrict access to the EMPLOYEE table by using the DETECTING mode.
  B. Create a FIREWALL STORED PROCEDURE to block any external user from executing this SQL statement.
  C. Create a list of approved SQL users by using the INTERROGATION mode.
  D. Create a whitelist of approved SQL commands by using the RECORDING mode, and enable protection by changing it to PROTECTION mode.
  D. Create a whitelist of approved SQL commands by using the RECORDING mode, and enable protection by changing it to PROTECTION mode.

• Question 60:

  How do you restrict a user named joe from being able to connect from any IP address to a MySQL database?

  A. Insert Joe's name into the mysql.user_restriction table, and issue the FLUSH PRIVILEGES command.
  B. You cannot deny access to a user based on his or her username.
  C. CREATE USER `joe'@%' DENY ALL PRIVILEGES
  D. UPDATE mysql.user SET Password=PASSWORD (`Invalid') WHERE User= `joe';
  E. CREATE USER `joe'@'0.0.0.0'SET Password=PASSWORD (`%!%')
  A. Insert Joe's name into the mysql.user_restriction table, and issue the FLUSH PRIVILEGES command.