多选题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.sqlBMysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'C$ mysql – u root – p – h localhost test ＜ /tmp/t1.sqlDMysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1E$ mysqlinport – u root – p – h localhost test /tmp/t1.sql
多选题
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
参考解析
解析：
暂无解析
相关考题：
单选题You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）AIncrease the value of table_definition_cacheBIncrease the value of table_open_cache_instancesCDecrease the value of table_open_cache_instancesDIncrease the value of table_open_cacheEDecrease the value of table_definition_cacheFDecrease the value of table_open_cache
多选题Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data. This requires the following config file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I/O overhead. What three changes will reduce disk I/O overheads?（）AUse of soft links for database directories on the same physical diskBUse of delay_key_write=ON for batch index updateCAllocation of RAM to the buffer pool such that more of the data can fit in RAMDPlacement of InnoDB log files and datadir on separate physical disksEUse of separate directories on the same physical disk for log files and data files
单选题You have a login-path named "adamlocal" that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correct for you deployment. You execute this command: $mysql_config_editor print –login-path=adamlocal What is the expected output of this command?（）AThe command prints all parameter for the login-path. The password is replaced with starsBThe command prints the encrypted entry for the login-path. The is only possible to see if an entry existsCThe command prints all parameters for the login-path. The password is shown only when you provide the –password optionDThe command prints all parameters for the login-path. The password is printed in plain tex
单选题You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?（）ASTOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVEBSTOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVECSTOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVEDSTOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
单选题Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）AA syntax error will result as you cannot specify more than one partition in the same statementBAll data in p1 and p3 partitions are removed and the table definition is changedCAll data in p1 and p3 partitions are removed, but the table definition remains unchangedDOnly the first partition (p1) will be dropped as only one can be dropped at any time
多选题Which three methods will show the storage engine for the Country table?（）AABBCCDDEE