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; -题库考试答案搜索网

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;

多选题

2022-05-22 14:13

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

试题解析

标签： CMS专题 Oracle认证考试 1z0-883

感兴趣题目

Where a container，pallet or similar article of transport is used to consolidate goods，the number of packages or units enumerated in the bill of lading as packed in such article of transport（）to be the number of packages or units in calculating the amount beyond which the carrier or the ship is not reliable.

The carrier is liable for loss of or damage to the goods or delay in delivery caused by fire，（）the claimant proves that the fire arose from fault or neglect on the part of the carrier，his servants or agents.

（）is a computer technology that headsets,sometimes in combination with physical spaces or multi-projected environments,to generate realisitic images,sounds and other sensations that simulate a user’s physical presence in a virtual or imaginary environment.

People wandering in the fairground or park area（）wear a uniform.

______ twice a year, whether it is a car or a bus or a truck, is the rule that every driver must obey in this city.

（）shall be liable for loss of and damage to the Vessel and／or goods arising or resulting from inaccuracies in stating the description，quantity，weight，measurement or contents.

（） are individuals and organizations that are actively involved in the project, or whose interests may be affected as a result of project execution or project completion.

（）, or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.

The （） is used for hauling in or letting out the wires or ropes.

Effects which are dutiable or subject to prohibitions or restrictions should be declared in （）.

The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.

are individuals and organizations that are actively involved in the project，or whose interests may be affected as a result of project execution or project completion．