违法和不良信息举报 联系客服
免费注册 登录

The RECYCLEBIN parame

题目

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
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第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 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题：

WhichofthefollowingOraclefeaturesutilizetheundotablespace?()

A.FlashbackQuery

B.FlashbackDrop

C.FlashbackTable

D.FlashbackDatabase

E.TransactionProcessing

F.RecycleBin


参考答案：A, C, E

第3题：

ClicktheExhibitbutton.Given:10.11.ProductName:12.ProductPrice:13.Foragivenproductinstance,whichthreejsp:setPropertyattributesmustbeusedtoinitializeitspropertiesfromtheHTMLform?()

A.id

B.name

C.type

D.param

E.property


参考答案：B, D, E

第4题：

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

第5题：

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

第6题：

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 bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column


参考答案：A

第7题：

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

第8题：

AJSPpageneedstosetthepropertyofagivenJavaBeantoavaluethatiscalculatedwiththeJSPpage.Whichthreejsp:setPropertyattributesmustbeusedtoperformthisinitialization?()

A.Id

B.Val

C.Name

D.Param

E.Value

F.Property


参考答案：C, E, F

第9题：

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

第10题：

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

相关内容