itgle.com

Youissuedthefollowingcommand：CREATEGLOBALTEMPORARYTABLEadmin_work_area （startdateDATE，enddateDATE，classCHAR（20））ONCOMMITDELETEROWSTABLESPACEtbs_t1；AnindexisthencreatedontheADMIN_WORK_AREAtemporarytable.WhichtwostatementsaretrueregardingtheTBS_T1tablespace

题目

Youissuedthefollowingcommand：CREATEGLOBALTEMPORARYTABLEadmin_work_area （startdateDATE，enddateDATE，classCHAR（20））ONCOMMITDELETEROWSTABLESPACEtbs_t1；AnindexisthencreatedontheADMIN_WORK_AREAtemporarytable.WhichtwostatementsaretrueregardingtheTBS_T1tablespaceintheabovecommand？（）

A.Itstoresonlythetemporarytablebutnotitsindexes.

B.Itstoresboththetemporarytableaswellasitsindexes.

C.Itmustbeanondefaulttemporarytablespaceforthedatabase.

D.Itcanbeadefaultornondefaulttemporarytablespaceforthedatabase.

E.Itmustbethedefaulttemporarytablespaceoftheuserwhoissuesthecommand.

相似考题

1.You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()A. It stores only the temporary table but not its indexes.B. It stores both the temporary table as well as its indexes.C. It must be a nondefault temporary tablespace for the database.D. It can be a default or nondefault temporary tablespace for the database.E. It must be the default temporary tablespace of the user who issues the command.

2.The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task, you issued the following command:SQL> ALTER TABLESPACE hi_data BEGIN BACKUP;Which two statements are true in this scenario? （）A. No transaction on the tablespace is allowed but you can perform queries.B. The tablespace will automatically come out of backup mode when the file copy is complete.C. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.D. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

3.Youexecutedthiscommandtocreateatemporarytable：SQL>CREATEGLOBALTEMPORARYTABLEreport_work_area（startdateDATE，enddateDATE，classCHAR（20））ONCOMMITPRESERVEROWS；WhichstatementistrueabouttherowsinsertedintotheREPORT_WORK_AREAtableduringatransaction（）A.Therowsstayinthetableonlyuntilsessiontermination.B.Therowsstayinthetableonlyuntilthenexttransactionstartsonthetable.C.Therowsarevisibletoallcurrentsessionsafterthetransactioniscommitted.D.Therowsstayavailableforsubsequentsessionsafterthetransactioniscommitted

4.Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;What would be the outcome of this command?（）A. It produces an error because data already exists in the table.B. It produces an error because compression can be enabled at table creation only.C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.

更多“Youissuedthefollowingcommand:CREATEGLOBALTEMPORARYTABLEadmin_work_area (startdateDATE,endd ”相关问题

  • 第1题：

    Youissuedthefollowingcommand:ALTERDATABASEENABLEBLOCKCHANGETRACKING;Whatwillbetheresultofissuingthiscommand?()

    A.Theblockchangetrackingfeatureisenabled，andtheinformationaboutthesystemchangenumberiswritteninthechangetrackingfile.

    B.Theblockchangetrackingfeatureisenabled，andtheinformationaboutthelogsequencenumberiswritteninthechangetrackingfile.

    C.Theblockchangetrackingfeatureisenabled，andtheinformationabouttheblocksthatarechangedsincethelastbackupiswritteninthechangetrackingfile.

    D.Theblockchangetrackingfeatureisenabled，andtheinformationaboutthelocationsofthedatafilesandtheonlineredologfilesarewritteninthechangetrackingfile.


    参考答案：C

  • 第2题：

    Who was the first man to reach the summit of Mount Everest?

    A:top
    B:bottom
    C:end
    D:site

    答案：A
    解析：
    本句意思：谁是第一个登上珠穆朗玛峰顶峰的人？summit意思是“最高点，顶点”，与top （顶部，顶点）意思相近。bottom底部；end结尾；site位置，地点。

  • 第3题：

    在三菱PLC程序中，结束指令的符号为（）。 A. NOP B. NOT C. END D. ENP

    A．NOP

    B．NOT

    C．END

    D．ENP


    C

  • 第4题：

    We can advise the manager, but in the end, it is he who has the _____ say.

    A、last

    B、final

    C、end

    D、full


    正确答案:B

  • 第5题：

    The love of money is the root of all evil.

    A:result
    B:cause
    C:end
    D:force

    答案：B
    解析：
    本句意思：爱钱是罪恶的根源。root意为“根源”，与cause（原因）意思相近。result结果； end终点；force力量。

相关内容