Oracle
1Z0-883 · Question #89
1Z0-883 Question #89: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #89. The question stem and answer options stay visible for context.
Question
In a test database, you issue the SELECT ... INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it. Mysql> SELECT * INTO OUTFILE `/tmp/t1.sql' from t1; mysql> TRUNCATE t1; Which two methods will restore data to the t1 table?
Options
- AMysql> LOAD DATA INFILE `/tmp/t1.sql' INTO TABLE t1;
- B$ mysqladmin u root p h localhost test restore /tmp/t1.sql
- C$ mysql u root p h localhost te<lt; /tmp/t1.sql
- D$ mysqlinport u root p h localhost test /tmp/t1.sql
- EMysql> INSERT INTO t1 VALUES FROM `/tmp/t1.sql';
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.