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.sqlB.Mysql＞ INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql‘C.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sqlD.Mysql＞ 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
相关考题：
请选择下面File参数书写正确的一项( )。A．File("d:\\file\test3.txt")B．File("d:\\file\\test3.txt")C．File("d:\file\test3.txt")D．File("d:\file\\test3.txt")
Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?() A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n
YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）A.V$DATABASEB.V$FLASHBACK_DATABASE_STATC.V$FLASHBACK_DATABASE_LOGD.V$RECOVERY_FILE_DEST
YouaremanaginganOracleDatabase10gdatabasethatusesOracleManagedFiles(OMF).Youenabledtheblockchangetrackingfeatureforthedatabase.Whichstatementregardingthechangetrackingfileistrue?() A.Oneblockchangetrackingfileiscreatedforeachdatafile.Bydefault，thefileiscreatedinDB_CREATE_FILE_DEST.B.Oneblockchangetrackingfileiscreatedforeachdatafile.Bydefault，thefileiscreatedinBACKGROUND_DUMP_DEST.C.Oneblockchangetrackingfileiscreatedforthedatabase.Bydefault，thefileiscreatedinDB_CREATE_FILE_DEST.D.Oneblockchangetrackingfileiscreatedforthedatabase.Bydefault，thefileiscreatedinBACKGROUND_DUMP_DEST.
请选择下面File参数书写正确的一项( )。A．File("d:\\file\test3.txt")B．File("d;\\file\\test3.txt")C．File("d:\file\test3.txt")D．File("d:\file\\test3.txt")
已知如下信息: select * from nls_database_parameters where parameter like '%CHARACTERSET%'; PARAMETER VALUE ----------------- ------------------- NLS_CHARACTERSET WE8MSWIN1252 NLS_NCHAR_CHARACTERSET AL16UTF16 echo $NLS_LANG AMERICAN_AMERICA.ZHS16GBK 请问执行这句话, exp userid=test/test TABLES=TEST FILE=test.dmp,,则导出的字符集是?()A. WE8MSWIN1252B. AL16UTF16C. ZHS16GBK
Examinethefollowingparametersettingsfromaninitialization（init.ora）file：DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles（OMF）databaseusingthesesettings，whatistheresult？（）A.AB.BC.CD.D
定义fp为文件型指针变量,以读写方式打开一个已存在的文本文件test.dat，下面fopen函数正确的调用方式是:A．FILE *fp; fp=fopen("test.dat", "rb");B．FILE*fp; fp=fopen("test.dat", "r+");C．FILE *fp; fp=fopen("test.dat", "r");D．FILE *fp; fp=fopen("test.dat", "rb+");
下列四组SQL命令，全部属于数据定义语句的命令是（）A．CREATE，DROP，UPDATEB．CREATE，DROP，ALTERC．CREATE，DROP，GRANTD．CREATE，DROP，SELECT
下列四组SQL命令，全部属于数据定义语句的命令是（）。A．CREATE，DROP，ALTERB．CREATE，DROP，UPDATEC．CREATE，DROP，GRANTD．CREATE，DROP，SELECT