itgle.com

多选题Which statements are correct regarding indexes？ （）AWhen a table is dropped， the corresponding indexes are automatically dropped.BFor each DML operation performed， the corresponding indexes are automatically updated.CIndexes should be created on columns

题目
多选题
Which statements are correct regarding indexes？ （）
A

When a table is dropped， the corresponding indexes are automatically dropped.

B

For each DML operation performed， the corresponding indexes are automatically updated.

C

Indexes should be created on columns that are frequently referenced as part of an expression.

D

A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.

相似考题

1.The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data

2.Which two statements regarding the Flashback Table feature are correct?()A. Flashback Table can be performed on system tables.B. Flashback Table operation does not shrink the segments.C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.

3.Which two statements are true regarding views?（）A、A subquery that defines a view cannot include the GROUP BY clause B、A view that is created with the subquery having the DISTINCT keyword can be updated C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

4.You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()A. It stores only the temporary table but not its indexes.B. It stores both the temporary table as well as its indexes.C. It must be a nondefault temporary tablespace for the database.D. It can be a default or nondefault temporary tablespace for the database.E. It must be the default temporary tablespace of the user who issues the command.

更多“多选题Which statements are correct regarding indexes？ （）AWhen a table is dropped， the corresponding indexes are automatically dropped.BFor each DML operation performed， the corresponding indexes are automatically updated.CIndexes should be created on columns”相关问题

  • 第1题：

    The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

    • A、All the related indexes and views are automatically dropped
    • B、The flashback drop feature can recover only the table structure
    • C、Only the related indexes are dropped whereas views are invalidated
    • D、The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

  • 第2题：

    Which two statements are TRUE regarding Coherence Indexes ？ （）

    • A、 indexes are maintained by cache entry ownes
    • B、 an application should not suggest an index that another aplication had suggested
    • C、 indexes cannot be sorted
    • D、 each application using Coherence may suggest the same set of indexes when it starts

    正确答案:A,D

  • 第3题：

    Which statements are correct regarding indexes？ （）

    • A、 When a table is dropped， the corresponding indexes are automatically dropped.
    • B、 For each DML operation performed， the corresponding indexes are automatically updated.
    • C、 Indexes should be created on columns that are frequently referenced as part of an expression.
    • D、 A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.

    正确答案:A,B,D

  • 第4题：

    The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

    • A、 All the related indexes and views are automatically dropped
    • B、 The flashback drop feature can recover only the table structure
    • C、 Only the related indexes are dropped whereas views are invalidated
    • D、 The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

  • 第5题：

    Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）

    • A、INDEXES
    • B、SKIP_INDEXES_MAINTENANCE
    • C、SKIP_UNUSABLE_INDEXES
    • D、RESUMABLE
    • E、INDEXES_UNUSABLE

    正确答案:C

  • 第6题：

    Which two are true regarding external tables？ （）

    • A、External tables can be updated. 
    • B、External tables are read-only tables. 
    • C、Indexes can be created on external tables. 
    • D、Indexes cannot be created on external tables.

    正确答案:B,D

  • 第7题：

    多选题
    The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)
    A

    All the related indexes and views are automatically dropped

    B

    The flashback drop feature can recover only the table structure

    C

    Only the related indexes are dropped whereas views are invalidated

    D

    The flashback drop feature can recover both the table structure and its data


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

  • 第8题：

    多选题
    On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）
    A

    Only the ORD_CUSTOMER_IX1 index created.

    B

    Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.

    C

    Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.

    D

    The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.

    E

    Both the indexes are created and used by the optimizer for queries on the ORDERS table.

    F

    Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.


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

  • 第9题：

    多选题
    Which two statements are TRUE regarding Coherence Indexes ？ （）
    A

    indexes are maintained by cache entry ownes

    B

    an application should not suggest an index that another aplication had suggested

    C

    indexes cannot be sorted

    D

    each application using Coherence may suggest the same set of indexes when it starts


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

  • 第10题：

    多选题
    The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）
    A

    All the related indexes and views are automatically dropped

    B

    The flashback drop feature can recover only the table structure

    C

    Only the related indexes are dropped whereas views are invalidated

    D

    The flashback drop feature can recover both the table structure and its data


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

  • 第11题：

    多选题
    Which two statements are true regarding views?（）
    A

    A subquery that defines a view cannot include the GROUP BY clause

    B

    A view that is created with the subquery having the DISTINCT keyword can be updated

    C

    A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

    D

    A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table


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

  • 第12题：

    多选题
    Which statements are true regarding system-partitioned tables?（）
    A

    Only a single partitioning key column can be specified.

    B

    All DML statements must use partition-extended syntax.

    C

    The same physical attributes must be specified for each partition.

    D

    Unique local indexes cannot be created on a system-partitioned table.

    E

    Traditional partition pruning and partitionwise joins are not supported on these tables.


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

  • 第13题：

    Which  statements are correct about temporary tables（）

    • A、Indexes and views can be created on temporary tables.
    • B、Both the data and the structure of temporary tables can be exported.
    • C、Temporary tables are always created in a user’s temporary tablespace.
    • D、The data inserted into a temporary table in a session is available to other sessions.
    • E、Data manipulation language （DML） locks are never acquired on the data of temporary tables

    正确答案:A,C,E

  • 第14题：

    Which statements are true regarding system-partitioned tables？（）  

    • A、 Only a single partitioning key column can be specified.
    • B、 All DML statements must use partition-extended syntax.
    • C、 The same physical attributes must be specified for each partition.
    • D、 Unique local indexes cannot be created on a system-partitioned table.
    • E、 Traditional partition pruning and partitionwise joins are not supported on these tables.

    正确答案:D,E

  • 第15题：

    Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?（）

    • A、It cannot be done in parallel.
    • B、It can be done at the table level or partition level.
    • C、It does not require additional storage because the operation is done online.
    • D、Local and global indexes are maintained automatically during the operation.

    正确答案:B

  • 第16题：

    Which three statements are correct about temporary tables？（）

    • A、Indexes and views can be created on temporary tables.
    • B、Both the data and the structure of temporary tables can be exported.
    • C、Temporary tables are always created in a user’s temporary tablespace.
    • D、The data inserted into a temporary table in a session is available to other sessions.
    • E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.

    正确答案:A,C,E

  • 第17题：

    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

    • A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.
    • B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
    • C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
    • D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

    正确答案:C

  • 第18题：

    What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）

    • A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. 
    • B、You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. 
    • C、Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. 
    • D、Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.

    正确答案:A,B,D

  • 第19题：

    单选题
    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
    A

    The data in the segment will be compacted but the high water mark will not be adjusted 

    B

    The EMPLOYEES table will be changed to read-only mode during the shrink operation 

    C

    The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over

    D

    The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation 

    E

    Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation


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

  • 第20题：

    多选题
    Which two statements regarding the Flashback Table feature are correct?（）
    A

    Flashback Table can be performed on system tables.

    B

    Flashback Table operation does not shrink the segments.

    C

    Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

    D

    Flashback Table operation acquires exclusive data manipulation language (DML) locks.


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

  • 第21题：

    单选题
    Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）
    A

     It cannot be done in parallel.

    B

     It can be done at the table level or partition level.

    C

     It does not require additional storage because the operation is done online.

    D

     Local and global indexes are maintained automatically during the operation.


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

  • 第22题：

    单选题
    Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）
    A

    INDEXES

    B

    SKIP_INDEXES_MAINTENANCE

    C

    SKIP_UNUSABLE_INDEXES

    D

    RESUMABLE

    E

    INDEXES_UNUSABLE


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

  • 第23题：

    多选题
    What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）
    A

    Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status.

    B

    You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually.

    C

    Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query.

    D

    Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.


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

  • 第24题：

    多选题
    Which statements are correct regarding indexes？ （）
    A

    When a table is dropped， the corresponding indexes are automatically dropped.

    B

    For each DML operation performed， the corresponding indexes are automatically updated.

    C

    Indexes should be created on columns that are frequently referenced as part of an expression.

    D

    A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.


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

相关内容