niusouti.com

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

题目

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

1.ClicktheExhibitbutton.Given:10.11.ProductName:12.ProductPrice:13.Foragivenproductinstance,whichthreejsp:setPropertyattributesmustbeusedtoinitializeitspropertiesfromtheHTMLform?()A.idB.nameC.typeD.paramE.property

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

3.You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）A. It retrieves the latest version of the table from the recycle binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

4.AJSPpageneedstosetthepropertyofagivenJavaBeantoavaluethatiscalculatedwiththeJSPpage.Whichthreejsp:setPropertyattributesmustbeusedtoperformthisinitialization?()A.IdB.ValC.NameD.ParamE.ValueF.Property

更多“The RECYCLEBIN parame”相关问题

  • 第1题：

    WhichofthefollowingOraclefeaturesutilizetheundotablespace?()

    A.FlashbackQuery

    B.FlashbackDrop

    C.FlashbackTable

    D.FlashbackDatabase

    E.TransactionProcessing

    F.RecycleBin


    参考答案：A, C, E

  • 第2题：

    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

    • A、The table is moved to the SYSAUX tablespace.
    • B、The table is moved to the SYSTEM tablespace.
    • C、The table is removed from the database permanently.
    • D、The table is renamed and remains in the TBSFD tablespace.

    正确答案: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；


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

  • 第4题：

    A JSP page needs to set the property of a given JavaBean to a value that is calculated with the JSP page. Which three jsp：setProperty attributes must be used to perform this initialization？（）

    • A、Id
    • B、Val
    • C、Name
    • D、Param
    • E、Value
    • F、Property

    正确答案:C,E,F

  • 第5题：

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


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

  • 第6题：

    单选题
    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）
    A

    The table is moved to the SYSAUX tablespace.

    B

    The table is moved to the SYSTEM tablespace.

    C

    The table is removed from the database permanently.

    D

    The table is renamed and remains in the TBSFD tablespace.


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

相关内容