itgle.com

多选题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？（）AOracle Managed Files are used for this instance.

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

相似考题

1.Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()A. It releases the storage space used by the table.B. It does not release the storage space used by the table.C. You can roll back the deletion of rows after the statement executes.D. You can NOT roll back the deletion of rows after the statement executes.E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

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

3.Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)A、Flash recovery area must be definedB、Undo retention guarantee must be enabled.C、Database must be running in archivelog mode.D、Automatic undo management must be enabled.E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

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

参考答案和解析
正确答案： B,C
解析： 暂无解析
更多“多选题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？（）AOracle Managed Files are used for this instance.BTh”相关问题

  • 第1题：

    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

    • A、It releases the storage space used by the table.
    • B、It does not release the storage space used by the table.
    • C、You can roll back the deletion of rows after the statement executes.
    • D、You can NOT roll back the deletion of rows after the statement executes.
    • E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
    • F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

    正确答案:A,D,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题：

    Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.  Which two statements are trueregarding the MRKT tablespace（）

    • A、No more data files can be added to the tablespace.
    • B、Segment space is managed by free lists in the tablespace.
    • C、A user created without being assigned a default tablespace uses this tablespace.
    • D、The tablespace can be dropped with the current setting with segments present in it

    正确答案:A,C

  • 第4题：

    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

    正确答案:A,D

  • 第5题：

    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

  • 第6题：

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


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

  • 第7题：

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

  • 第8题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


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

  • 第9题：

    多选题
    Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)
    A

    Flash recovery area must be defined

    B

    Undo retention guarantee must be enabled.

    C

    Database must be running in archivelog mode.

    D

    Automatic undo management must be enabled.

    E

    The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).


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

  • 第10题：

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

  • 第11题：

    多选题
    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
    A

    It releases the storage space used by the table.

    B

    It does not release the storage space used by the table.

    C

    You can roll back the deletion of rows after the statement executes.

    D

    You can NOT roll back the deletion of rows after the statement executes.

    E

    An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

    F

    You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table


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

  • 第12题：

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

  • 第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 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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

    • A、The database will open, and the tablespace automatically comes out of the backup mode
    • B、The database will be mounted, and recovery must be performed on the USERS tablespace.
    • C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
    • D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

    正确答案:C

  • 第18题：

    多选题
    Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.  Which two statements are trueregarding the MRKT tablespace（）
    A

    No more data files can be added to the tablespace.

    B

    Segment space is managed by free lists in the tablespace.

    C

    A user created without being assigned a default tablespace uses this tablespace.

    D

    The tablespace can be dropped with the current setting with segments present in it


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

  • 第19题：

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

  • 第20题：

    单选题
    You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）
    A

     You must enable the row movement on the SCOTT.EMP table.

    B

     You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

    C

     You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.

    D

     You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.


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

  • 第21题：

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


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

  • 第22题：

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

  • 第23题：

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

  • 第24题：

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

相关内容