A valid raw backup of the shop.

Oracle 1z0-908 Question Answer

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.)

shell> cp /backup/customers.sdi /var/tmp

shell> cp /backup/customers.sdi /var/lib/mysql/shop/

mysql> SOURCE ‘/var/tmp/customers.sdi’

mysql> IMPORT TABLE FROM /var/tmp/customers.sdi

shell> cp /backup/customers.frm /var/lib/mysql/shop/

mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

mysql> ALTER TABLE shop.customers IMPORT TABLESPACE

Oracle 1z0-908 Summary

Price: $52.5 ~~$149.99~~