网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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 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” 相关考题
考题 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

考题 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 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

考题 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 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

考题 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

考题 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 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

考题 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 datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

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

考题 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

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

考题 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 sessionB、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC、execute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking sessionD、execute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking sessionE、execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session

考题 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 petsC、INSERT INTO pets…D、ALTER TABLE pets…

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

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

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

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

考题 单选题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 recordsB a table name which has 10s of recordsC a table name which has empty recordsD a table name which has 1000s of recordsE never use a table name

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

考题 多选题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 issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?()AAll data along with the table structure is deletedBThe pending transaction in the session is committedCAll indexes on the table will remain but they are invalidatedDAll views and synonyms will remain but they are invalidatedEAll data in the table are deleted but the table structure will remain

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

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

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

考题 多选题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? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block