多选题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 exten

题目
多选题
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 50

B

specify extent allocation as Uniform

C

specify extent allocation as Automatic

D

create the tablespace as bigfile tablespace

E

create the tablespace as smallfile tablespace

F

set segment space management to Automatic

G

use the RESIZE clause while creating the tablespace

相似考题

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

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.In which scenario will you perform a cancel-based recovery？（）A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database

4.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 tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.

参考答案和解析
正确答案： C,B
解析： 暂无解析
更多“You are creating a locally managed tablespace to meet the fo”相关问题

  • 第1题：

    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

    • A、flash back the database
    • B、perform point-in-time recovery
    • C、perform a full database recovery
    • D、drop and re-create the tablespace
    • E、use Recovery Manager （RMAN） to recover the database

    正确答案:D

  • 第2题：

    You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

    • A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
    • B、 executing a long query that involves a sort operation and the statement runs out of temporary space
    • C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
    • D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

    正确答案:D

  • 第3题：

    You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

    • A、 The index tablespace contains bitmap indexes.
    • B、 The index tablespace contains more than one data file.
    • C、 The index tablespace supports only complete recovery.
    • D、 The index tablespace is not a dictionary-managed tablespace.
    • E、 There is a dependency relationship between a table and its indexes.

    正确答案:E

  • 第4题：

    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

  • 第5题：

    You work as a database administrator for Supportcenter.cn. 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 or tablespace type   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

  • 第6题：

    单选题
    You have created a locally managed tablespace by issuing the following command：        CREATE TABLESPACE data1   DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE        UNLIMITED；   For the DATA1 tablespace， you have set the warning level alert limit to 70 percent.  In which situation will a warning level alert be generated？（）
    A

     when 700 KB is used

    B

     when 700 KB is left as free space

    C

     when 7MB is used

    D

     when 7MB is left as free space

    E

     no alert will be generated because an autoextensible datafile is included in the tablespace


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

  • 第7题：

    单选题
    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

    E

    Threshold values for the TEST_TBS tablespace are not explicitly specified


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

  • 第8题：

    单选题
    You want the size of the tablespace to increase when it is full. Which option would you use？（）
    A

    use automatic extent allocation

    B

    disable threshold for the tablespace

    C

    use freelists to manage the free space

    D

    use automatic segment space management

    E

    create the tablespace as a bigfile tablespace

    F

    use the RESIZE clause while creating the tablespace

    G

    enable AUTOEXTEND for at least one of the data files in the tablespace


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

  • 第9题：

    单选题
    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.


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

  • 第10题：

    单选题
    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.


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

  • 第11题：

    单选题
    You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）
    A

     creating a table in your schema and you exceed your allocated space quota on the tablespace

    B

     executing a long query that involves a sort operation and the statement runs out of temporary space

    C

     loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

    D

     creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error


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

  • 第12题：

    单选题
    You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（）
    A

    The tablespace must be locally managed.

    B

    The tablespace must have only one temp file.

    C

    The tablespace must be made nondefault and offline.

    D

    The tablespace can remain as the default but must have no active sort operations.


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

  • 第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 have created a locally managed tablespace by issuing the following command：        CREATE TABLESPACE data1   DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE        UNLIMITED；   For the DATA1 tablespace， you have set the warning level alert limit to 70 percent.  In which situation will a warning level alert be generated？（）  

    • A、 when 700 KB is used
    • B、 when 700 KB is left as free space
    • C、 when 7MB is used
    • D、 when 7MB is left as free space
    • E、 no alert will be generated because an autoextensible datafile is included in the tablespace

    正确答案:C

  • 第15题：

    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

    • A、 by using the Flashback Database feature
    • B、 by using RMAN incomplete recovery
    • C、 by performing a user-managed incomplete recovery
    • D、 by dropping and re-creating the index tablespace

    正确答案:D

  • 第16题：

    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
    • E、Threshold values for the TEST_TBS tablespace are not explicitly specified

    正确答案:D

  • 第17题：

    单选题
    You work as a database administrator for Supportcenter.cn. 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 or tablespace type   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.


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

  • 第18题：

    单选题
    You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）
    A

     The index tablespace contains bitmap indexes.

    B

     The index tablespace contains more than one data file.

    C

     The index tablespace supports only complete recovery.

    D

     The index tablespace is not a dictionary-managed tablespace.

    E

     There is a dependency relationship between a table and its indexes.


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

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
    A

     by using the Flashback Database feature

    B

     by using RMAN incomplete recovery

    C

     by performing a user-managed incomplete recovery

    D

     by dropping and re-creating the index tablespace


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

  • 第21题：

    单选题
    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
    A

    flash back the database

    B

    perform point-in-time recovery

    C

    perform a full database recovery

    D

    drop and re-create the tablespace

    E

    use Recovery Manager （RMAN） to recover the database


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

  • 第22题：

    单选题
    You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）
    A

    DBMS_STATS 

    B

    DBMS_ALERT 

    C

    DBMS_SPACE 

    D

    DBMS_MONITOR 

    E

    DBMS_SERVER_ALERT

    F

    DBMS_SPACE_ADMIN


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）
    A

     The tablespace must be locally managed.

    B

     The tablespace must have only one temp file.

    C

     The tablespace must be made nondefault and offline.

    D

     The tablespace can remain as the default but must have no active sort operations.


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

相关内容