Oracle Discussions

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam

Go to Exam

Exam 1z0-908 topic 1 question 69 discussion

Actual exam question from Oracle's 1z0-908

Question #: 69
Topic #: 1

[All 1z0-908 Questions]

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
H. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE

Show Suggested Answer

Suggested Answer: DG 🗳️

by Dhanushka at July 30, 2023, 2:46 p.m.

Comments

Submit Cancel

LrnsTgh

11 months, 4 weeks ago

Selected Answer: BF

location sdi file match

upvoted 2 times

...

FelipeK

1 year, 1 month ago

Selected Answer: AF

The correct answer are A and F. I tested it.

upvoted 1 times

...

marklv

1 year, 4 months ago

A and F, tested, import table works for myisam in 8

upvoted 1 times

marklv

1 year, 4 months ago

But the commands forgot the quotes, so technically it won't work, but its what it meant

upvoted 1 times

marklv

1 year, 2 months ago

Correction, B and F, A file location doesn't match f

upvoted 2 times

...

...

...

Dhanushka

1 year, 5 months ago

Selected Answer: AD

Import tablespace only for Innodb

upvoted 1 times

...