1. Home
  2. Discussions
  3. Oracle
  4. MySQL Database Administration
  5. 1z0-908 Discussions
  6. 1z0-908 Exam Topic 1 Question 7 Discussion

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 7 Topic 1 Discussion

 Oracle Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 7 Topic 1 Discussion

1z0-908 Exam Topic 1 Question 7 Discussion:
Question #: 7
Topic #: 1

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.

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

B.

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

C.

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

D.

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

E.

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

F.

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

G.

mysql> ALTER TABLE shop.customers IMPORT TABLESPACE

Get Premium 1z0-908 Questions
Actual exam question for Oracle 1z0-908 exam by Rogue38087 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next