[多选]
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

Which of the following IBM products includes a rich set of tools to monitor the health of System x， BladeCenter-based systems and to automatically take action to minimize costly outages？（） IBM Insight Manager。 Veritas Sysmanage for IBM。 IBM Director。 IBM Netmanage。在对评估基准日企业实际收益进行调整时需调整的项目包括（）。企业销售产品收入。企业对灾区的捐款、支出。一次性税收减免。应摊未摊费用。应提未提费用。 While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（） Block Media Recovery must be used with RMAN.。 You must perform complete recovery of individual blocks.。 You must have a full RMAN backup， not an incremental backup.。 You must use the DBVERIFY utility before using the Block Media Recovery feature.。 A company plans to deploy a two-enclosure, 23-core Power 780 system with AIX, IBM i and Linux in the following configuration: 3 AIX partitions with dedicated network and disk adapters; 1 native IBM i partition acting as a host; 1 hosted IBM i partition; 2 hosted Linux partitions. Which configuration will provide boot disk capability to all partitions?（） Use dual-split backplane in both enclosures for the three AIX partitions and the IBM i partition.。 Put each partition on a dedicated controller using the triple-split backplane option in both enclosures.。 Use the triple-split backplane option in one enclosure for the AIX partitions, and the default dual-split backplane for the IBM i partition in the second enclosure.。 Use the triple-split backplane option in one enclosure for the AIX partitions, and the non-split backplane mode in the second enclosure for the IBM i hosting partition.。地区性产业布局的主要模式（） A.增长极发展模式。 B.点轴布局模式。 C.网罗布局模式。 D.区域梯度发展模式。

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;

参考答案：

● 参考解析

本题暂无解析

当前位置：1z0-883题库

[多选] 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;