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. TES

题目

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.

相似考题

1.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.

2.Thewarninglevelthresholdvalueforatablespace,&ensThewarninglevelthresholdvalueforatablespace，DATA1，issetto60%andthecriticallevelthresholdvalueissetto80%.Thetablespace，DATA1，isinfrequentlyusedandisnotapartoftheproductionenvironment.Youissuedthefollowingcommand：SQL>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？（）

3.YouaremaintainingyourOLTPdatabaseinOracle10g.YouhavenotsetthewarninglevelandcriticallevelthresholdvaluesforspaceusageoftheDATA1tablespace.Whatwillbetheimpact?()A.Nowarninglevelorcriticallevelalertwillbegenerated.B.Awarninglevelalertwillneverbegenerated，butacriticallevelalertwillbegeneratedwhen97percentspaceoftheDATA1tablespaceisused.C.Acriticallevelalertwillneverbegenerated，butawarninglevelalertwillbegeneratedwhen85percentspaceoftheDATA1tablespaceisused.D.Awarninglevelalertwillbegeneratedat85percentspaceusageoftheDATA1tablespace，andacriticallevelalertisgeneratedat97percentspaceusageoftheDATA1tablespace.

4.YouwanttomoveallobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask()A.FULLB.SCHEMASC.TRANSFORMD.REMAP_SCHEMAE.REMAP_TABLESPACE

更多“An online tablespace, TEST_TBS, is full and you realize that no server－managed tablespace ”相关问题

  • 第1题：

    YouwanttomovealltheobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask?()

    A.FULL

    B.SCHEMAS

    C.REMAP_SCHEMA

    D.REMAP_DATAFILES

    E.REMAP_TABLESPACE


    参考答案：C

  • 第2题：

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


    正确答案：
     

  • 第3题：

    使用impdp时,希望将源库的对象放到目标库不同的用户和表空间下,要用什么参数?()

    A. REMAP_SCHEMA

    B. REMAP_SCHEMA, REMAP_TABLESPACE

    C. REMAP_SCHEMA, REMAP_TABLESPACE , REMAP_DATAFILE

    D. REMAP_SCHEMA, REMAP_TABLESPACE , REMAP_DATAFILE ,REUSE_DATAFILES


    参考答案D

  • 第4题：

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


    正确答案：
     

  • 第5题：

    创建数据库时自动建立的tablespace名称？


    正确答案：
     

  • 第6题：

    YouneedtoimportalldefinitionsofobjectsbelongingtotheTS_EMPLOYEEStablespacebyusingtheexportfileexpdat.dmp.Whichimportstatementiscorrect?()

    A.imphr/hrTABLES=（ts_employees）rows=y

    B.impsystem/managerFROMUSER=hrfile=expdat.dmp

    C.imphr/hrTRANSPORT_TABLESPACE=yfile=expdat.dmp

    D.impsystem/managerTRANSPORT_TABLESPACE=yTABLESPACE=ts_employees


    参考答案：C

相关内容