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 droppedB、T

题目

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
相似考题

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.Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()A. You cannot roll back this statement.B. All pending transactions are committed.C. All views based on the DEPT table are deleted.D. All indexes based on the DEPT table are dropped.E. All data in the table is deleted, and the table structure is also deleted.F. All data in the table is deleted, but the structure of the table is retained.G. All synonyms based on the DEPT table are deleted.

3.You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation? ()(Choose two.)A. Backup compression should be enabledB. Parallelism for the channel should be set to 2C. All the files must be backed up as backup setsD. The backup may be stored either on disk or on media with media manager

4.You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

更多“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 droppedB、Th”相关问题

  • 第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 trace options on Junos devices?（）

    • A、You can see the contents of the log file by entering the show log <filename> command.
    • B、Trace options will send information to your screen automatically.
    • C、Trace options are limited to one protocol at a time.
    • D、The file name and a set of flags may be specified when enabling traceoptions.

    正确答案:A,D

  • 第3题：

    You issued the following command：        SQL> DROP TABLE MYTABLE；        SQL> SHOW RECYCLEBIN  The following output is returned：        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13：20：11：31  You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）

    • A、 DROP TABLE MYTABLE PURGE；
    • B、 PURGE RECYCLEBIN；
    • C、 PURGE TABLE MYTABLE；
    • D、 PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

    正确答案:C,D

  • 第4题：

    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

  • 第5题：

    You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)

    • A、Backup compression should be enabled
    • B、Parallelism for the channel should be set to 2
    • C、All the files must be backed up as backup sets
    • D、The backup may be stored either on disk or on media with media manager

    正确答案:C,D

  • 第6题：

    You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

    • A、All the objects of scott are moved to the Recycle Bin.
    • B、Any objects in the Recycle Bin belonging to scott are purged.
    • C、All the objects owned by scott are permanently dropped from the database.
    • D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
    • E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

    正确答案:B,C

  • 第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?（）

    • 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

  • 第8题：

    多选题
    You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）
    A

    No flashback is possible to bring back the ITEM table.

    B

    The ORDER table is dropped along with the ITEM table.

    C

    The dependent referential integrity constraints in the ORDER table are disabled.

    D

    The dependent referential integrity constraints in the ORDER table are removed.

    E

    The table definition of the ITEM table and associated indexes are placed in the recycle bin.


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

  • 第9题：

    多选题
    You issued the following command：        SQL> DROP TABLE MYTABLE；        SQL> SHOW RECYCLEBIN  The following output is returned：        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13：20：11：31  You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）
    A

    DROP TABLE MYTABLE PURGE；

    B

    PURGE RECYCLEBIN；

    C

    PURGE TABLE MYTABLE；

    D

    PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；


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

  • 第10题：

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

  • 第11题：

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

  • 第12题：

    多选题
    You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about theeffect of the command（）
    A

    No flashback is possible to bring back the ITEM table.

    B

    The ORDERS table is dropped along with the ITEM table.

    C

    The dependent referential integrity constraints in the ORDERS table are disabled.

    D

    The dependent referential integrity constraints in the ORDERS table are removed.

    E

    The table definition of the ITEM table and associated indexes are placed in the recycle bin


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

  • 第13题：

    You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（） 

    • A、 Backup compression should be enabled
    • B、 Parallelism for the channel should be set to 2
    • C、 All the files must be backed up as backup sets
    • D、 The backup may be stored either on disk or on media with media manager

    正确答案:C,D

  • 第14题：

    Which two statements are true regarding undo tablespaces（）

    • A、The database can have more than one undo tablespace.
    • B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
    • C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
    • D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

    正确答案:A,C

  • 第15题：

    You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）

    • A、No flashback is possible to bring back the ITEM table.
    • B、The ORDER table is dropped along with the ITEM table.
    • C、The dependent referential integrity constraints in the ORDER table are disabled.
    • D、The dependent referential integrity constraints in the ORDER table are removed.
    • E、The table definition of the ITEM table and associated indexes are placed in the recycle bin.

    正确答案:A,D

  • 第16题：

    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

    • A、All data along with the table structure is deleted 
    • B、The pending transaction in the session is committed 
    • C、All indexes on the table will remain but they are invalidated 
    • D、All views and synonyms will remain but they are invalidated 
    • E、All data in the table are deleted but the table structure will remain

    正确答案:A,B,D

  • 第17题：

    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

  • 第18题：

    You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about theeffect of the command（）

    • A、No flashback is possible to bring back the ITEM table.
    • B、The ORDERS table is dropped along with the ITEM table.
    • C、The dependent referential integrity constraints in the ORDERS table are disabled.
    • D、The dependent referential integrity constraints in the ORDERS table are removed.
    • E、The table definition of the ITEM table and associated indexes are placed in the recycle bin

    正确答案:A,D

  • 第19题：

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

  • 第20题：

    多选题
    You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）
    A

    All the objects of scott are moved to the Recycle Bin.

    B

    Any objects in the Recycle Bin belonging to scott are purged.

    C

    All the objects owned by scott are permanently dropped from the database.

    D

    All the objects of scott in the Recycle Bin must be purged before executing the DROP command.

    E

    Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.


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

  • 第21题：

    多选题
    Which two statements are true regarding undo tablespaces（）
    A

    The database can have more than one undo tablespace.

    B

    The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.

    C

    Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.

    D

    An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.


    正确答案： C,B
    解析： A答案：可以有一个或多个undo表空间，A答案正确。 
    sys@TEST0924> select TABLESPACE_NAME，CONTENTS from dba_tablespaces； TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO 
    EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected. 
    B答案：UNDO_TABLESPACE只能用于自动undo段模式，B答案错误

  • 第22题：

    多选题
    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
    A

    All data along with the table structure is deleted

    B

    The pending transaction in the session is committed

    C

    All indexes on the table will remain but they are invalidated

    D

    All views and synonyms will remain but they are invalidated

    E

    All data in the table are deleted but the table structure will remain


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

  • 第23题：

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

相关内容