多项选择题

You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.
The data should be spread across two data files.
A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）

A.set PCTFREE and PCTUSED to 50
B.specify extent allocation as Uniform
C.specify extent allocation as Automatic
D.create the tablespace as bigfile tablespace
E.create the tablespace as smallfile tablespace
F.set segment space management to Automatic
G.use the RESIZE clause while creating the tablespace

<上一题目录下一题>

热门试题

单项选择题Inyourdatabase，youdiscoveredthatatempfileinalocallymanagedtemporarytablespacehasbeendeletedattheoperatingsystemlevel.Howwouldyourecoverthetablespace？（）

A.flash back the database
B.perform point-in-time recovery
C.perform a full database recovery
D.drop and re-create the tablespace
E.use Recovery Manager （RMAN） to recover the database

多项选择题our database is in the MOUNT state and you execute the following command to open it： ALTER DATABASE OPEN What two actions are performed as a result of this command？（）

A.All control files are opened.
B.All redo log files are opened
C.The password file is opened.
D.The parameter file is opened.
E.All online data files are opened.

单项选择题Anyonewhoknowsjustthehostnameandthelistenernamecanhavefullcontroloverthelistener.Theycanstopthelistenerandalsoobtaindetailedinformationaboutthelistener，database，andtheconfigurationoftheapplication.Howwouldyouavoidthisscenario？（）

A.lock the listener
B.hide the listener
C.create multiple listeners
D.run listener on a remote client
E.set a password for the listener
F.store listener.ora in a non-default location

单项选择题Youareworkingona24x7（available24hoursperday，7daysperweek）productiondatabase.Anoperatingsystem（OS）userdeletesthealertlogfileaccidentally.Whichstatementinthisscenarioistrue？（）

A.The database crashes.
B.The DBA needs to re-create the file.
C.The file gets re-created automatically.
D.The file gets restored automatically from the last backup.
E.The DBA needs to perform a complete database recovery.
F.The DBA needs to perform an incomplete database recovery.

单项选择题Becauseofapoweroutage，instancefailurehasoccurred.Fromwhatpointintheredologdoesrecoverybeginandwheredoesitend？（）

A.current redo log and inactive redo log
B.checkpoint position to end of redo log
C.beginning of redo log to end of redo log
D.all redo logs before the point of last commit
E.beginning of redo log to checkpoint position