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.
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.
相关考题：
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
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
Which two statements are true about the primary key constraint in a table？ （）A、It is not possible to disable the primary key constraint.B、It is possible to have more than one primary key constraint in a single table.C、The primary key constraint can be referred by only one foreign key constraint.D、The primary key constraint can be imposed by combining more than one column.E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
You execute the following command to audit database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
You plan to execute the following command to perform a Flashback Database operation in your database： SQL FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation
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；
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 command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）A、A CHECK constraint is created on the OID column.B、A NOT NULL constraint is created on the OID column.C、The ORDERS table is the only object created in the USERS tablespace.D、The ORDERS table and a unique index are created in the USERS tablespace.E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
You execute the following command to audit the database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command？（）A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
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
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
You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that： a） No other user data in the database is affected. b） The operation takes the minimum possible time. Which option would you choose？（）A、use the ROLLBACK command with SCN 663571B、perform Flashback Transaction Query with SCN 663571C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
User A executes the following command to drop a large table in your database：SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A、It fails to delete the records because the records are locked in SHARE mode.B、It deletes the rows successfully because the table is locked in SHARE modeC、It fails to delete the records because the table is locked in EXCLUSIVE mode.D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
You execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
多选题Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
多选题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
多选题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（）ANo flashback is possible to bring back the ITEM table.BThe ORDER table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDER table are disabled.DThe dependent referential integrity constraints in the ORDER table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin.
单选题View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（）A The PRIMARY KEY is created along with a new index.B The PRIMARY KEY is created and it would use an existing unique index.C The PRIMARY KEY would be created in a disabled state because it is using an existing index.D The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
多选题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；
多选题Which two statements are true about the primary key constraint in a table？ （）AIt is not possible to disable the primary key constraint.BIt is possible to have more than one primary key constraint in a single table.CThe primary key constraint can be referred by only one foreign key constraint.DThe primary key constraint can be imposed by combining more than one column.EThe non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
单选题You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that： a） No other user data in the database is affected. b） The operation takes the minimum possible time. Which option would you choose？（）A Use ROLLBACK command with SCN 663571.B Perform Flashback Transaction Query with SCN 663571.C Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.D Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
多选题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
单选题User A executes the following command to drop a large table in your database： SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table： SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）AIt fails with a Resource Busy error.BIt deletes the rows successfully because the table is locked in SHARE mode.CIt fails to delete the records because the table is locked in EXCLUSIVE mode.DIt deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
多选题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（）ANo flashback is possible to bring back the ITEM table.BThe ORDERS table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDERS table are disabled.DThe dependent referential integrity constraints in the ORDERS table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin