Examine the statement：  
SQL> CREATE TABLESPACE user_data 
2> EXTENT MANAGEMENT LOCAL 
3> SEGMENT SPACE MANAGEMENT AUTO；  
Which twp assumptions must be true for this statement to execute successfully？（）

单项选择题The EMPLOYEES table is stored in the SAMPLE tablespace.  The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.  Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace.  Which object will be exported by this command？（）   exp system manager tablespaces=SAMPLE

A.Only the EMPLOYEES table.
B.Only the EMPLOYEES table and its corresponding primary key index.
C.The EMPLOYEES table and partition P1.
D.The EMPLOYEES table， IPK_EMP index， and the SALES table.

单项选择题Whatshouldyoulookatfirsttocomputethenumberofundoblockswrittenpersecondtodisk？（）

A.V$UNDOSTAT
B.V$TRANSACTION
C.V$ROLLSTAT
D.DBA_UNDO_EXTENTS
E.DBA_ROLLBACK_SEGS

单项选择题What is true regarding a transaction executed in Automatic Undo Management mode？（）

A.A
B.B
C.C
D.D

多项选择题YoucanuseOracleFlashbacktolookatpastactivityinyourdatabase.WhataretwoothercharacteristicsofOracleFlashback？（）

A.Oracle Flashback uses undo information to construct consistent data. 
B.You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
C.You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
D.Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

单项选择题Whatistrueaboutversion-enabledtables？（）

A.The unit of versioning is the schema.
B.It is possible to version enable a table pertaining to SYS.
C.There are as many segments as versions for the same base table.
D.It is possible to create workspaces if there is no version-enabled table in the database.