网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
如何在tablespace里增加数据文件?
参考答案
更多 “ 如何在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.
考题
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
考题
合并数据文件包括两种方式:一种是从外部数据文件中增加个案到当前数据文件中,另一种是从外部数据文件中增加_________到当前数据文件中。
热门标签
最新试卷