单项选择题
YouwanttomovealltheobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask？（）
- A.FULL
B.SCHEMAS
C.REMAP_SCHEMA
D.REMAP_DATAFILES
E.REMAP_TABLESPACE
点击查看答案&解析
相关考题
-
单项选择题
YoumovedtheindexEMP_NO_INDXfromonetablespacetoanotherandthenissuedthefollowingcommandtorebuildtheindexEMP_NO_INDX：SQL>ALTERINDEXEMP_NO_INDXREBUILDONLINE；WhichtableallowstheuserstoaccesstheEMP_NO_INDXindexwhileperformingtherebuildoperation？（）A.Index-organizedtableB.MappingTableC.ClusteredTableD.JournalTable
A.Index-organizedtable
B.MappingTable
C.ClusteredTable
D.JournalTable -
单项选择题
Youdiscoveranout-of-spaceconditioninthedatabase.Youdecidetosuspendasessionforfiveminutes.Youissuethefollowingcommandtosuspendthesession：ALTERSESSIONENABLERESUMABLE；Whichcommandcouldyouissuetoenabletheresumablespaceallocationfeatureatthesessionlevel？（）A.ALTERSESSIONENABLERESUMABLE_TIMEOUT=5；B.ALTERSYSTEMENABLERESUMABLE_TIMEOUT=5；C.ALTERSESSIONENABLERESUMABLE_TIMEOUT=300；D.ALTERSYSTEMENABLERESUMABLETIMEOUT=300；
A.Youdecidetosuspendasessionforfiveminutes.Youissuethefollowingcommandtosuspendthesession：ALTERSESSIONENABLERESUMABLE；Whichcommandcouldyouissuetoenabletheresumablespaceallocationfeatureatthesessionlevel？（）
A.ALTERSESSIONENABLERESUMABLE_TIMEOUT=5；
B.ALTERSYSTEMENABLERESUMABLE_TIMEOUT=5；
C.ALTERSESSIONENABLERESUMABLE_TIMEOUT=300；
D.ALTERSYSTEMENABLERESUMABLETIMEOUT=300； -
单项选择题
YoucreatedtheDEPTtablebyusingthefollowingcommand：CREATETABLEscott.dept（deptnoNUMBER（3），dnameVARCHAR2（15），locVARCHAR2（15））STORAGE（INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4）；YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshrinkoperation，youwanttoensurethattherecoveredspaceisreturnedtothetablespaceinwhichtheDEPTtableisstored.YoudonotwanttoshrinktheindexescreatedontheDEPTtable.WhatwillyoudotoshrinktheSCOTT.EMPtable？（）
A.dept
