网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “ 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. ” 相关考题
考题
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.
考题
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.
考题
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.
考题
Youexecutedthiscommandtocreateatemporarytable：SQLCREATEGLOBALTEMPORARYTABLEreport_work_area（startdateDATE，enddateDATE，classCHAR（20））ONCOMMITPRESERVEROWS；WhichstatementistrueabouttherowsinsertedintotheREPORT_WORK_AREAtableduringatransaction（）A.Therowsstayinthetableonlyuntilsessiontermination.B.Therowsstayinthetableonlyuntilthenexttransactionstartsonthetable.C.Therowsarevisibletoallcurrentsessionsafterthetransactioniscommitted.D.Therowsstayavailableforsubsequentsessionsafterthetransactioniscommitted
考题
Youissuedthefollowingcommand:ALTERDATABASEENABLEBLOCKCHANGETRACKING;Whatwillbetheresultofissuingthiscommand?()
A.Theblockchangetrackingfeatureisenabled，andtheinformationaboutthesystemchangenumberiswritteninthechangetrackingfile.B.Theblockchangetrackingfeatureisenabled，andtheinformationaboutthelogsequencenumberiswritteninthechangetrackingfile.C.Theblockchangetrackingfeatureisenabled，andtheinformationabouttheblocksthatarechangedsincethelastbackupiswritteninthechangetrackingfile.D.Theblockchangetrackingfeatureisenabled，andtheinformationaboutthelocationsofthedatafilesandtheonlineredologfilesarewritteninthechangetrackingfile.
考题
We can advise the manager, but in the end, it is he who has the _____ say.
A、lastB、finalC、endD、full
考题
在三菱PLC程序中，结束指令的符号为（）。 A. NOP B. NOT C. END D. ENPA．NOPB．NOTC．ENDD．ENP
热门标签
最新试卷
