다운로드 Oracle : 1Z0-908 질문 & 답 PDF & Test Software

Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

• A. Logical upgrades are much faster because they do not require restarting the mysqld process.
• B. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.
• C. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.
• D. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.
• E. Physical upgrades are much faster because they do not require restarting the mysqld process.
• F. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)

• A. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
• B. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
• C. Use PURGE BINARY LOGS to <binlog_name>.
• D. Use SET PERSIST binlog_expire_logs_seconds=<value>.
• E. Set binlog_expire_logs_seconds in my.cnf.
• F. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.

A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1.Confirm that secure_file_priv='/var/tmp'
2.mysql> DROP TABLE shop.customers;
3.shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)

• A. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
• B. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
• C. shell> cp /backup/customers.frm /var/lib/mysql/shop/
• D. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
• E. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
• F. shell> cp /backup/customers.sdi /var/tmp
• G. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
• H. mysql> SOURCE '/var/tmp/customers.sdi'

Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.
Which two statements are true? (Choose two.)

• A. The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')
• B. The primary instance can be specified by using the command
  cluster.setPrimaryInstance(<host>:<port>).
• C. The instance deployed on host2 is elected as the new primary instance.
• D. The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.
• E. The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.
• F. Failure of the instance deployed on host1 provokes an outage.

t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?

• A. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
• B. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
• C. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
• D. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.