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
第1题:
Which two statements are true regarding undo tablespaces()
第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题:
Which two statements are TRUE regarding Coherence Indexes ? ()
第4题:
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?()
第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题:
All six routes will be installed in the routing table.
Two routes will be installed in the routing table.
Four routes will be installed in the routing table.
All the routes were redistributed into BGP from an IGP.
All the routes were originated by BGP with the network command.
第7题:
UPDATE TABLE
CREATE CLUSTER
TRUNCATE TABLE
ALTER TABLE MOVE
INSERT INTO···VALUES
ALTER TABLE···DROP COLUMN
ALTER TABLE···DROP PARTITION
第8题:
All the objects of scott are moved to the Recycle Bin.
Any objects in the Recycle Bin belonging to scott are purged.
All the objects owned by scott are permanently dropped from the database.
All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
第9题:
The database can have more than one undo tablespace.
The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.
An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
第10题:
All data along with the table structure is deleted
The pending transaction in the session is committed
All indexes on the table will remain but they are invalidated
All views and synonyms will remain but they are invalidated
All data in the table are deleted but the table structure will remain
第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题:
Backup compression should be enabled
Parallelism for the channel should be set to 2
All the files must be backed up as backup sets
The backup may be stored either on disk or on media with media manager
第13题:
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)
第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()
第15题:
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? ()(Choose two.)
第16题:
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
第17题:
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?()
第18题:
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
第19题:
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.
第20题:
DROP TABLE MYTABLE PURGE;
PURGE RECYCLEBIN;
PURGE TABLE MYTABLE;
PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0;
第21题:
indexes are maintained by cache entry ownes
an application should not suggest an index that another aplication had suggested
indexes cannot be sorted
each application using Coherence may suggest the same set of indexes when it starts
第22题:
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
第23题:
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
第24题:
Flashback logs are not archived.
Flashback logs are maintained in redo log files.
Flashback logs are maintained in the Flash Recovery Area.
Flashback logs are used to maintain Flashback Database related errors.
Flashback logs need to be cleared manually after you disable Flashback Database.