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

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

相似考题

1.You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE 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. Now, you need to reverse the effects of the FLASHBACK TABLE command.Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）A. Restore the backup control file and open the database with RESETLOGS option.B. Perform point-in-time recovery because flashback cannot be performed again on this tableC. 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

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

3. An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）A、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEB、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC、CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD、CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

4.An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)Which of the following SQL statements will provide the table definition that meets the specified requirements?（）A.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEB.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC.CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD.CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

更多“You execute this command to drop the ITEM table， which has t”相关问题

  • 第1题：

    You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

    • A、Immediately following statement execution 
    • B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
    • C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
    • D、After the ALTER TABLE MODIFY command is issued

    正确答案:B

  • 第2题：

    For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

    • A、UPDATE TABLE
    • B、CREATE CLUSTER
    • C、TRUNCATE TABLE
    • D、ALTER TABLE MOVE
    • E、INSERT INTO···VALUES
    • F、ALTER TABLE···DROP COLUMN
    • G、ALTER TABLE···DROP PARTITION

    正确答案:A,E

  • 第3题：

    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

    • A、All data along with the table structure is deleted 
    • B、The pending transaction in the session is committed 
    • C、All indexes on the table will remain but they are invalidated 
    • D、All views and synonyms will remain but they are invalidated 
    • E、All data in the table are deleted but the table structure will remain

    正确答案:A,B,D

  • 第4题：

    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.

    正确答案:A,C

  • 第5题：

    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 mode
    • C、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.

    正确答案:C

  • 第6题：

    User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）

    • A、UPDATE pets…
    • B、SELECT….FROM pets
    • C、INSERT INTO pets…
    • D、ALTER TABLE pets…

    正确答案:B

  • 第7题：

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


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

  • 第8题：

    单选题
    You execute the following command toauditdatabase activities：  SQL>AUDITDROP 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.


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

  • 第9题：

    单选题
    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.


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

  • 第10题：

    多选题
    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
    A

    All data along with the table structure is deleted

    B

    The pending transaction in the session is committed

    C

    All indexes on the table will remain but they are invalidated

    D

    All views and synonyms will remain but they are invalidated

    E

    All data in the table are deleted but the table structure will remain


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

  • 第11题：

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


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

  • 第12题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

  • 第13题：

    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；

    正确答案:C,D

  • 第14题：

    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.

    正确答案:A,D

  • 第15题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第16题：

    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

    正确答案:A,D

  • 第17题：

    One of the users in the PROD database，Adams，complains that his update on the table，TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions，and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority.  Which method would you use to overcome this problem？（）

    • A、execute the command， ALTER SESSION KILL ..， to kill the blocking session
    • B、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
    • C、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
    • D、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
    • E、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session

    正确答案:C

  • 第18题：

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


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

  • 第19题：

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

  • 第20题：

    单选题
    You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）
    A

    a table name which has 100s of records

    B

    a table name which has 10s of records

    C

    a table name which has empty records

    D

    a table name which has 1000s of records

    E

    never use a table name


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

  • 第21题：

    多选题
    For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）
    A

    UPDATE TABLE

    B

    CREATE CLUSTER

    C

    TRUNCATE TABLE

    D

    ALTER TABLE MOVE

    E

    INSERT INTO···VALUES

    F

    ALTER TABLE···DROP COLUMN

    G

    ALTER TABLE···DROP PARTITION


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

  • 第22题：

    单选题
    You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）
    A

    The database instance is not available.

    B

    The ALTER TABLE command does not have WAIT option

    C

    The table or a row in the table is currently locked by another user session.

    D

    The database instance is busy processing other user sessions commands.

    E

    The CUSTOMERS table has no long running query active at the time when this request is made.

    F

    The server process executing the ALTER TABLE command is busy with another command execution


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

  • 第23题：

    单选题
    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.


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

相关内容