Note the following points describing various utilities in Oracle Database 11g：
1. It enables the transfer of data from one database to another.
2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database.
3. It enables the loading of data from an external file into tables of an Oracle database.
4. It provides a tape backup management for the Oracle ecosystem. 
Which point describes the Oracle Data Pump utility（）

多项选择题Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’ u01 app oracle oradata orcl mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.  Which two statements are trueregarding the MRKT tablespace（）

A.No more data files can be added to the tablespace.
B.Segment space is managed by free lists in the tablespace.
C.A user created without being assigned a default tablespace uses this tablespace.
D.The tablespace can be dropped with the current setting with segments present in it

多项选择题WhichtwostatementsaretrueregardingtransactionsinanOracledatabase（）

A.Multiple transactions can use the same undo segment.
B.A transaction is assigned an undo segment when it is started.
C.More than one transaction cannot share the same extent in the undo tablespace.
D.The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

多项选择题View the Exhibit1， which shows the options that are selected to create the user SL_REP. View the Exhibit2 andexamine the contents of DATABASE_PROPERTIES.  Which two statements are true regarding this user（）

A.The user is authenticated by the operating system.
B.The objects created by the user are placed in the USERS tablespace.
C.The user does not require quota on the TEMP tablespace to perform sort operations.
D.The user is forced to change the password at the first login to the database instance.
E.The objects created by the user in future are unlocked to be accessed by all the users in the database bydefault.

多项选择题WhichtwofilesinthedatabasecanbeconfiguredforautomaticbackupsbyusingtheautobackupfeatureinRecoveryManager（RMAN）（）

A.Data files
B.Control files
C.Parameter file
D.Online redo log files
E.Server parameter file

单项选择题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）

A.Take the USERS tablespace offline and re-create the lost data file.
B.Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
C.Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
D.Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online