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 lo

题目

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

相似考题

1.请选择下面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")

2.YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）A.V$DATABASEB.V$FLASHBACK_DATABASE_STATC.V$FLASHBACK_DATABASE_LOGD.V$RECOVERY_FILE_DEST

3.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.

4.Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?()A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n

更多“In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with yo ”相关问题

  • 第1题：

    请选择下面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")


    正确答案：B
    解析：本题主要考查Java语言中对文件的打开操作。下面3种方法都可以生成一个文件对象或者一个文件夹对象： public File(String pathName);
    public File(String parentStr,String childStr);
    public File(File parentStr,String childStr)。
    选项A错误，text3.txt前应为“\\”；选项B正确；选项C错误，应将“\”换成“\\”：选项D错误，file前应为“\\”。故本题答案是B。

  • 第2题：

    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.A

    B.B

    C.C

    D.D


    参考答案：D

  • 第3题：

    下列四组SQL命令，全部属于数据定义语句的命令是（）

    A．CREATE，DROP，UPDATE

    B．CREATE，DROP，ALTER

    C．CREATE，DROP，GRANT

    D．CREATE，DROP，SELECT


    CREATE ， DROP ， ALTER

  • 第4题：

    已知如下信息: 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. WE8MSWIN1252

    B. AL16UTF16

    C. ZHS16GBK


    参考答案C

  • 第5题：

    定义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+");


    文件在缓冲区上的读写位置

  • 第6题：

    下列四组SQL命令，全部属于数据定义语句的命令是（）。

    A．CREATE，DROP，ALTER

    B．CREATE，DROP，UPDATE

    C．CREATE，DROP，GRANT

    D．CREATE，DROP，SELECT


    CREATE ， DROP ， ALTER

相关内容