多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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;

  • A、$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
  • B、Mysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
  • C、$ mysql – u root – p – h localhost test < /tmp/t1.sql
  • D、Mysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
  • E、$ mysqlinport – u root – p – h localhost test /tmp/t1.sql
正确答案:D,E
答案解析:
进入题库查看解析

微信扫一扫手机做题