网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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” 相关考题
考题
ClicktheExhibitbutton.Given:10.11.ProductName:12.ProductPrice:13.Foragivenproductinstance,whichthreejsp:setPropertyattributesmustbeusedtoinitializeitspropertiesfromtheHTMLform?()
A.idB.nameC.typeD.paramE.property
考题
AJSPpageneedstosetthepropertyofagivenJavaBeantoavaluethatiscalculatedwiththeJSPpage.Whichthreejsp:setPropertyattributesmustbeusedtoperformthisinitialization?()
A.IdB.ValC.NameD.ParamE.ValueF.Property
考题
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
考题
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
考题
WhichofthefollowingOraclefeaturesutilizetheundotablespace?()
A.FlashbackQueryB.FlashbackDropC.FlashbackTableD.FlashbackDatabaseE.TransactionProcessingF.RecycleBin
考题
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、IdB、ValC、NameD、ParamE、ValueF、Property
考题
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.
考题
多选题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？（）AAll the related indexes and views are automatically droppedBThe flashback drop feature can recover only the table structureCOnly the related indexes are dropped whereas views are invalidatedDThe flashback drop feature can recover both the table structure and its data
考题
多选题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？（）ADROP TABLE MYTABLE PURGE；BPURGE RECYCLEBIN；CPURGE TABLE MYTABLE；DPURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；
考题
单选题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.
热门标签
最新试卷