多选题Which two operations can be flashed back using the Flashback technology?()ADROP USER SMITH;BDROP TABLE EMPLOYEES;CDROP TABLESPACE USERS;DALTER TABLE SALES_REP DROP PARTITION P1;EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;

多选题
Which two operations can be flashed back using the Flashback technology?()
A

DROP USER SMITH;

B

DROP TABLE EMPLOYEES;

C

DROP TABLESPACE USERS;

D

ALTER TABLE SALES_REP DROP PARTITION P1;

E

ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;


参考解析

解析: 暂无解析

相关考题:

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 enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?() A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.

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

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

On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.B、 You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()A、Drop the table.B、Partition the tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()A、ALTER TABLE SPLIT PARTITIONB、ALTER TABLE MERGE PARTITIONC、ALTER TABLE TRUNCATE PARTITIOND、ALTER TABLE ADD PARTITIONE、ALTER TABLE DROP PARTITIONF、ALTER TABLE MOVE PARTITION

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?()  A、 Drop the table.B、 Partition the table.C、 Truncate the table.D、 Add a column to the table.E、 Rename a column in the table.

Which two operations can be flashed back using the Flashback technology?()A、DROP USER SMITH;B、DROP TABLE EMPLOYEES;C、DROP TABLESPACE USERS;D、ALTER TABLE SALES_REP DROP PARTITION P1;E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()A、UPDATE TABLEB、CREATE CLUSTERC、TRUNCATE TABLED、ALTER TABLE MOVEE、INSERT INTO···VALUESF、ALTER TABLE···DROP COLUMNG、ALTER TABLE···DROP PARTITION

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 EMPLOYEES table is stored in the SAMPLE tablespace.  The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.  Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace.  Which object will be exported by this command?()   exp system/manager tablespaces=SAMPLEA、Only the EMPLOYEES table.B、Only the EMPLOYEES table and its corresponding primary key index.C、The EMPLOYEES table and partition P1.D、The EMPLOYEES table, IPK_EMP index, and the SALES table.

Which two statements are correct regarding the Oracle Flashback Drop feature? ()A、 Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.B、 You can flash back a dropped table provided row movement has been enabled on the table.C、 If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.D、 When you execute the DROP TABLESPACE? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.E、 When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.F、 If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

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

Which two operations can be performed on an external table()A、Create a view on the table.B、Create an index on the table.C、Create a synonym on the table.D、Add a virtual column to the table.E、Update the table using the UPDATE statement.F、Delete rows in the table using the DELETE command

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

多选题Which two operations can be flashed back using the Flashback technology?()ADROP USER SMITH;BDROP TABLE EMPLOYEES;CDROP TABLESPACE USERS;DALTER TABLE SALES_REP DROP PARTITION P1;EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;

多选题Which two statements complete a transaction? ()ADELETE employees;BDESCRIBE employees;CROLLBACK TO SAVEPOINT C;DGRANT SELECT ON employees TO SCOTT;EALTER TABLE employees SET UNUSED COLUMN sal;FSELECT MAX(sal) FROM employees WHERE department_id = 20;

单选题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?()AThe table is moved to the SYSAUX tablespace.BThe table is moved to the SYSTEM tablespace.CThe table is removed from the database permanently.DThe table is renamed and remains in the TBSFD tablespace.

多选题On Jan 11, 2005 at 2:30 P.M., an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator, and you want to return the original values in the table. To do so, you decided to flash back the table. Which two options can you use to flash back a table?()Aby using Oracle Enterprise ManagerBby issuing the FLASHBACK TABLE statement at the RMAN promptCby issuing the FLASHBACK TABLE statement at the SQL promptDby issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

多选题Which two statements are correct regarding the Oracle Flashback Drop feature? ()ARecycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.BYou can flash back a dropped table provided row movement has been enabled on the table.CIf you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.DWhen you execute the DROP TABLESPACE? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.EWhen a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.FIf you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION

单选题Which two operations can be flashed back using the Flashback technology? ()ADROP USER SMITH;BDROP TABLE EMPLOYEES;CDROP TABLESPACE USERS;DALTER TABLE SALES_REP DROP PARTITION P1;EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;

多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP PARTITIONFALTER TABLE MOVE PARTITION

单选题You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?()A Drop the table.B Partition the table.C Truncate the table.D Add a column to the table.E Rename a column in the table.

多选题Which two operations can be performed on an external table()ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command.

多选题Which two operations can be performed on an external table()ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command

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