Oracle Exam 1Z0-908 Topic 3 Question 7 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 7
Topic #: 3

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

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

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

Cmysql> SOURCE '/var/tmp/customers.sdi'

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

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

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

Gmysql> ALTER TABLE shop.customers IMPORT TABLESPACE

Hmysql> ALTER TABLE shop.customers DISCARD TABLESPACE

Show Suggested Answer

Suggested Answer: D, G

by Helga at May 03, 2022, 08:46 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!