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（）

多项选择题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

单项选择题Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario()

A.The minimum memory size for the database buffer cache is set to 100 mb.
B.The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb
C.The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
D.The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb