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

如何在tablespace里增加数据文件?

哪个VIEW用来判断tablespace的剩余空间

创建数据库时自动建立的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