网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）
A. TEST_TBS is a small file tablespace.
B. TEST_TBS is a bigfile tablespace (BFT).
C. TEST_TBS is the default temporary tablespace.
D. TEST_TBS is a dictionary-managed tablespace.
参考答案
更多 “ An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）A. TEST_TBS is a small file tablespace.B. TEST_TBS is a bigfile tablespace (BFT).C. TEST_TBS is the default temporary tablespace.D. TEST_TBS is a dictionary-managed 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
热门标签
最新试卷