TEMPORARY tablespace和PERMANENT tablespace 的区别是?
TEMPORARY tablespace和PERMANENT tablespace 的区别是?
相关考题:
Which statement about the enabling of table compression in Oracle Database 11g is true?() A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.B. Compression can be enabled only at the table level for both direct loads and conventional DML.C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.
YouwanttomoveallobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask() A.FULLB.SCHEMASC.TRANSFORMD.REMAP_SCHEMAE.REMAP_TABLESPACE
Thewarninglevelthresholdvalueforatablespace,EXECUTEDBMS_SERVER_ALERT.SET_THRESHOLD(dbms_server_alert.tablespace_pct_full,dbms_server_alert.operator_ge,80,dbms_server_alert.operator_ge,90,1,1,NULL,dbms_server_alert.object_type_tablespace,’DATA’);Whatwillbetheresultofthecommand?()
YouaremaintainingyourOLTPdatabaseinOracle10g.YouhavenotsetthewarninglevelandcriticallevelthresholdvaluesforspaceusageoftheDATA1tablespace.Whatwillbetheimpact?() A.Nowarninglevelorcriticallevelalertwillbegenerated.B.Awarninglevelalertwillneverbegenerated,butacriticallevelalertwillbegeneratedwhen97percentspaceoftheDATA1tablespaceisused.C.Acriticallevelalertwillneverbegenerated,butawarninglevelalertwillbegeneratedwhen85percentspaceoftheDATA1tablespaceisused.D.Awarninglevelalertwillbegeneratedat85percentspaceusageoftheDATA1tablespace,andacriticallevelalertisgeneratedat97percentspaceusageoftheDATA1tablespace.
YouwanttomovealltheobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask?() A.FULLB.SCHEMASC.REMAP_SCHEMAD.REMAP_DATAFILESE.REMAP_TABLESPACE
使用impdp时,希望将源库的对象放到目标库不同的用户和表空间下,要用什么参数?() A. REMAP_SCHEMAB. REMAP_SCHEMA, REMAP_TABLESPACEC. REMAP_SCHEMA, REMAP_TABLESPACE , REMAP_DATAFILED. REMAP_SCHEMA, REMAP_TABLESPACE , REMAP_DATAFILE ,REUSE_DATAFILES
YouneedtoimportalldefinitionsofobjectsbelongingtotheTS_EMPLOYEEStablespacebyusingtheexportfileexpdat.dmp.Whichimportstatementiscorrect?() A.imphr/hrTABLES=(ts_employees)rows=yB.impsystem/managerFROMUSER=hrfile=expdat.dmpC.imphr/hrTRANSPORT_TABLESPACE=yfile=expdat.dmpD.impsystem/managerTRANSPORT_TABLESPACE=yTABLESPACE=ts_employees