Oracle
1Z0-883 · Question #89
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'…
The correct answer is A. Mysql> LOAD DATA INFILE `/tmp/t1.sql' INTO TABLE t1; D. $ mysqlinport u root p h localhost test /tmp/t1.sql. See the full explanation below for the reasoning.
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';
How the community answered
(20 responses)- A75% (15)
- B5% (1)
- C15% (3)
- E5% (1)
Community Discussion
No community discussion yet for this question.