单选题You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）A Extents would be managed by the freelists.B The segment would be managed by bitmaps.C The segment would be managed by the freelist

题目
单选题
You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）
A

Extents would be managed by the freelists.

B

The segment would be managed by bitmaps.

C

The segment would be managed by the freelists.

D

Free space would be managed by the data dictionary.

相似考题

1.In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.On further investigation, you find that buffer busy waits is caused by contention on data blocks.Which option would you consider first to decrease the wait event immediately?（）A. Decreasing PCTUSEDB. Decreasing PCTFREEC. Increasing the number of DBWN processD. Using Automatic Segment Space Management (ASSM)E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

2. You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）A、set PCTFREE and PCTUSED to 50B、specify extent allocation as UniformC、specify extent allocation as AutomaticD、create the tablespace as bigfile tablespaceE、create the tablespace as smallfile tablespaceF、set segment space management to AutomaticG、use the RESIZE clause while creating the tablespace

3.Which two statements about bigfile tablespaces are true？ （）A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.

4. The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：  ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation， you find that SMD is a small file tablespace.  Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

更多“单选题You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）A Extents would be managed by the freelists.B The segment would be managed by bitmaps.C The segment would be managed by the freelist”相关问题

  • 第1题：

    As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）

    • A、Coalesce the application tables at a regular interval.
    • B、Export and Import the application tables a regular interval.
    • C、Drop and recreate the application tables at a regular interval.
    • D、Move the application tables to a tablespace with less space usage.
    • E、Distribute the application tables across multiple tablespaces depending on usage.
    • F、Move the application tables to automatic segment space management tablespace.

    正确答案:F

  • 第2题：

    Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)

    • A、Database must be running in archivelog mode.
    • B、Automatic undo management must be enabled.
    • C、Undo retention guarantee must be enabled.
    • D、The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

    正确答案:B,D

  • 第3题：

    You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）

    • A、DROP TABLE 
    • B、ALTER TABLE 
    • C、RESIZE 
    • D、COALESCE

    正确答案:A

  • 第4题：

    You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

    • A、The database automatically determines the extent-sizing policy for the tablespace.
    • B、The segments are automatically shrunk when the contents are removed from them.
    • C、The allocation of extents within the tablespace is managed through the dictionary tables.
    • D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
    • E、The space utilization description of the data blocks in segments is managed through free lists.

    正确答案:A,D

  • 第5题：

    Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）

    • A、Oracle Managed Files are used for this instance.
    • B、The USER_DATA tablespace is managed using FET$/UET$ tables.
    • C、The COMPATIBLE initialization parameter must be 9.0.0 or higher.
    • D、Space within segments in the USER_DATA tablespace is managed with freelists.

    正确答案:A,C

  • 第6题：

    You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）

    • A、All the extents will be of the same size.
    • B、Bitmap will be used to record free and allocated extents.
    • C、Free extents will be managed by the data dictionary tables.
    • D、The tablespace will be system managed and the users cannot specify the extent size.

    正确答案:B

  • 第7题：

    多选题
    Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）
    A

    It readily responds to dynamic changes for concurrent access.

    B

    It improves performance and space utilization in a multiple-instance environment.

    C

    It requires fewer space related options then freelist managed structures.

    D

    It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.


    正确答案： C,D
    解析： 暂无解析

  • 第8题：

    多选题
    Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）
    A

    Oracle Managed Files are used for this instance.

    B

    The USER_DATA tablespace is managed using FET$/UET$ tables.

    C

    The COMPATIBLE initialization parameter must be 9.0.0 or higher.

    D

    Space within segments in the USER_DATA tablespace is managed with freelists.


    正确答案： B,A
    解析： 暂无解析

  • 第9题：

    单选题
    In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）
    A

    Decreasing PCTUSED

    B

    Decreasing PCTFREE

    C

    Increasing the number of DBWN process

    D

    Using Automatic Segment Space Management (ASSM)

    E

    Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation


    正确答案： B
    解析： 暂无解析

  • 第10题：

    多选题
    You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）
    A

    It may advise the use of online table redefinition for tables in dictionary managed tablespace.

    B

    It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

    C

    It may advise the use of online table redefinition for tables in locally managed tablespaces

    D

    It will detect and advise about chained rows.

    E

    It may advise the use of segment shrink for free list managed tables.


    正确答案： D,C
    解析： 暂无解析

  • 第11题：

    多选题
    Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)
    A

    Database must be running in archivelog mode.

    B

    Automatic undo management must be enabled.

    C

    Undo retention guarantee must be enabled.

    D

    The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).


    正确答案： A,C
    解析： 暂无解析

  • 第12题：

    单选题
    As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）
    A

    Coalesce the application tables at a regular interval.

    B

    Export and Import the application tables a regular interval.

    C

    Drop and recreate the application tables at a regular interval.

    D

    Move the application tables to a tablespace with less space usage.

    E

    Distribute the application tables across multiple tablespaces depending on usage.

    F

    Move the application tables to automatic segment space management tablespace.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）

    • A、Extents would be managed by the freelists.
    • B、The segment would be managed by bitmaps.
    • C、The segment would be managed by the freelists.
    • D、Free space would be managed by the data dictionary.

    正确答案:B

  • 第14题：

    You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）

    • A、It may advise the use of online table redefinition for tables in dictionary managed tablespace.
    • B、It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
    • C、It may advise the use of online table redefinition for tables in locally managed tablespaces
    • D、It will detect and advise about chained rows.
    • E、It may advise the use of segment shrink for free list managed tables.

    正确答案:B,C,D

  • 第15题：

    Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）

    • A、It readily responds to dynamic changes for concurrent access. 
    • B、It improves performance and space utilization in a multiple-instance environment. 
    • C、It requires fewer space related options then freelist managed structures. 
    • D、It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.

    正确答案:A,C,D

  • 第16题：

    You work as a database administrator for Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：  ERROR at Line 1：  ORA-10635： Invalid segment ortablespacetype What could be the reason？（）

    • A、The table is partitioned
    • B、The table name is wrong.
    • C、It is an index-Organized table （IOT）
    • D、The table is stored in locally managedtablespace.
    • E、The table is stored in atablespacewhere segment space is managed manually.

    正确答案:E

  • 第17题：

    In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）

    • A、Decreasing PCTUSED
    • B、Decreasing PCTFREE
    • C、Increasing the number of DBWN process
    • D、Using Automatic Segment Space Management (ASSM)
    • E、Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

    正确答案:D

  • 第18题：

    Which two are the prerequisites to enable Flashback Data Archive？（）

    • A、 Database must be running in archivelog mode.
    • B、 Automatic undo management must be enabled.
    • C、 Undo retention guarantee must be enabled.
    • D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment  Space Management （ASSM）.

    正确答案:B,D

  • 第19题：

    单选题
    You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）
    A

    All the extents will be of the same size.

    B

    Bitmap will be used to record free and allocated extents.

    C

    Free extents will be managed by the data dictionary tables.

    D

    The tablespace will be system managed and the users cannot specify the extent size.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    多选题
    You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）
    A

    The database automatically determines the extent-sizing policy for the tablespace.

    B

    The segments are automatically shrunk when the contents are removed from them.

    C

    The allocation of extents within the tablespace is managed through the dictionary tables.

    D

    The space utilization description of the data blocks in segments is recorded inbitmapblocks.

    E

    The space utilization description of the data blocks in segments is managed through free lists.MANUAL


    正确答案： E,C
    解析： 暂无解析

  • 第21题：

    单选题
    You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）
    A

    DROP TABLE 

    B

    ALTER TABLE 

    C

    RESIZE 

    D

    COALESCE


    正确答案： B
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements about bigfile tablespaces are true？ （）
    A

    The bigfile tablespace have only one data file.

    B

    The segment space management is automatic.

    C

    The extent management is dictionary managed.

    D

    The database can have only one bigfile tablespace.

    E

    The bigfile tablespace can be converted to a smallfile tablespace.


    正确答案： D,B
    解析： 暂无解析

  • 第23题：

    多选题
    Which two are the prerequisites to enable Flashback Data Archive？（）
    A

    Database must be running in archivelog mode.

    B

    Automatic undo management must be enabled.

    C

    Undo retention guarantee must be enabled.

    D

    The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment  Space Management （ASSM）.


    正确答案： A,D
    解析： 暂无解析

相关内容