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()
第1题:
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()
第2题:
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?()
第3题:
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) ()
第4题:
Which two statements are correct regarding the Oracle Flashback Drop feature? ()
第5题:
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()
第6题:
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()
第7题:
A CHECK constraint is created on the OID column.
A NOT NULL constraint is created on the OID column.
The ORDERS table is the only object created in the USERS tablespace.
The ORDERS table and a unique index are created in the USERS tablespace.
The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
第8题:
UPDATE TABLE
CREATE CLUSTER
TRUNCATE TABLE
ALTER TABLE MOVE
INSERT INTO···VALUES
ALTER TABLE···DROP COLUMN
ALTER TABLE···DROP PARTITION
第9题:
The PRIMARY KEY is created along with a new index.
The PRIMARY KEY is created and it would use an existing unique index.
The PRIMARY KEY would be created in a disabled state because it is using an existing index.
The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
第10题:
It is not possible to disable the primary key constraint.
It is possible to have more than one primary key constraint in a single table.
The primary key constraint can be referred by only one foreign key constraint.
The primary key constraint can be imposed by combining more than one column.
The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
第11题:
All the related indexes and views are automatically dropped
The flashback drop feature can recover only the table structure
Only the related indexes are dropped whereas views are invalidated
The flashback drop feature can recover both the table structure and its data
第12题:
No flashback is possible to bring back the ITEM table.
The ORDERS table is dropped along with the ITEM table.
The dependent referential integrity constraints in the ORDERS table are disabled.
The dependent referential integrity constraints in the ORDERS table are removed.
The table definition of the ITEM table and associated indexes are placed in the recycle bin
第13题:
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?()
第14题:
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()
第15题:
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?()
第16题:
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?()
第17题:
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?()
第18题:
You execute the following command toauditdatabase activities: SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command()
第19题:
Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.
You can flash back a dropped table provided row movement has been enabled on the table.
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.
When you execute the DROP TABLESPACE? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.
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.
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.
第20题:
No flashback is possible to bring back the ITEM table.
The ORDER table is dropped along with the ITEM table.
The dependent referential integrity constraints in the ORDER table are disabled.
The dependent referential integrity constraints in the ORDER table are removed.
The table definition of the ITEM table and associated indexes are placed in the recycle bin.
第21题:
DROP TABLE MYTABLE PURGE;
PURGE RECYCLEBIN;
PURGE TABLE MYTABLE;
PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0;
第22题:
Use ROLLBACK command with SCN 663571.
Perform Flashback Transaction Query with SCN 663571.
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
第23题:
It fails with a Resource Busy error.
It deletes the rows successfully because the table is locked in SHARE mode.
It fails to delete the records because the table is locked in EXCLUSIVE mode.
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.